Matching misspelled or differently spelled names

I have 2 lists of company names, list A and list B. I want to find all the names in A that are also in B. Problem is, some of the names in A are spelled differently than in B, but are the same entity. For example, List A has 'Amazon', and List B has 'Amazon.com.' How do I tell Excel to find a misspelled match, so to speak, like this? I originally tried using 'COUNTIF' and then counting the ones that match, but the spelling differences make it not possible that way

Please see attached spreadsheet for example and feel free to ask any clarifying questions. Note that these lists are relatively small, the real stuff I'm working in has thousands of names that I need to do this to...hence manually checking each name would be a colossal pain.

Dom

Originally Posted by Richard Buttrey

Hi,

You really need a fuzzy logic tool to help you detect mis-spellings. Microsoft have an Excel Add In here http://www.microsoft.com/en-us/downl....aspx?id=15011 which I have found useful on several occasions.

OK. I tried downloading that and using it just on this table. It doesn't seem to be working. Is there a video on how to use it or something? Either I'm having trouble figuring it out or the add-in is bugging out. I think something like this would definitely help if it worked. I definitely need something that could pick up that 3-D 'mis-spelling' for the main, and bigger, tables I'll be workin' with. They have thousands of names that have potentially similar mis-spellings.

Thanks!
Dom