View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Comparison between two similar strings



http://www.merriampark.com/ld.htm

Levenshtein Distance Algorithm. Link has sample code in VB.

Soundex is another approach.

Your second example would be difficult to call the same I would guess.

http://www.levenshtein.net/levenshtein_links.htm


--
Regards,
Tom Ogilvy


"Matt" wrote:

Hi,

I have two arrays of name and I would like to check if some of the
names are present in both of the arrays.
But the names can be mispelled, or differently entered in the two
arrays, for example:

-Alberto Parreira , albeerto parteira
-alberto parreira , alberto juan fernandez parreira
-alberto-juan parreira , alberto juuan parreira

Do you have an idea of a function that could tell me: those two
strings represents (at for example 80% sure) the same person ?

Cheers