Typo generator in Excel

[chiragpatnaik]

Hello,

I need to create a list of typos basis a starting list. Would anyone have any pointers on how do I get started on this?

eg for the following

Adam
Bob
Charlie

generate as many typos as possible like so in the succeeding columns, like so

Adam, aadm, adma, ama, adm etc
Bob, bbo, obb
Charlie, Charlei, cahrlie

I tried doing this though an online tool, but it will take way too long for the 1000 odd words that I need to do this for.
Spelling Typo Generator ~ Keyword Mispelling Tool

Any help is much appreciated.

CP

 

[Sinon]

Not sure what you want to use the list for but, instead of creating a list of all possibilities, you can try to do an approximate lookup with vlookup or index match. So if you are looking for an Adam, these 2 might provide other versions of Adam that are similar enough to Adam. You could also try the Fuzzy Lookup add-in Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center
There is no perfect solution though.