Compare and Match Similar Strings

[SamanthaW]

Is it possible to return a true value when comparing stings that are only similar and not identical??

I have a list of current folder names and a list of desired folder names. I want to match a current folder name with a similar desired folder name i.e.

Jane, Smith and Jane Smith
ABC Family Trust and ABC Family Unit Trust

I have found using strcomp and = will only match strings that are identical. I have been playing with "Like" but can't think of the best way to go about it.

Any help is greatly appreciated.

 

[Remou]

You may wish to consider Soundex and Levenshtein Distance.

http://allenbrowne.com/vba-Soundex.html

http://wiki.lessthandot.com/index.php/Comparing_Words:_Levenshtein_Distance

http://lessthandot.com