Closest Match

[arnie1066]

Excel VBA:
Is there a way to check a string against a list of other strings and find it's closest match.

E.G
<List>
Freddie
Mr Fred
Mr Freddy
Fred Jnr
Isabel
Uncle Sam

<Input String>
Fredy


In this case it would be closer to Mr Freddy, how can i do that in code.
Even if i get a % match for each one i can then use the highest %.


So is this unmanagable??

[Ecniv]

uh yeah - in simplistic terms.

I think you could read up on phonetics of words, then match phonetics perhaps?

[arnie1066]

Thanks for the reply, just checked out phonetics in VBA and all of the strings are in chineese.

Could you give me an example of code or the main command so i can check further. The info on 'Phonetics' in vba seems to want to add strings (in chineese) to a cell, nothing about comparing.

I'm sure i'm missing something so if you could point a little more precise it would be a great help, cheers