fuzzy matching

[Olly]

Hi,
I've got list of people's names that I need to match against another list of peeps

Anyone know of any good routines for this kind of fuzzy matching?
Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ?

thanks very much

[doodab]

Hi,
I've got list of people's names that I need to match against another list of peeps

Anyone know of any good routines for this kind of fuzzy matching?
Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ?

thanks very much

I've used oracle's implementation of this before.

Soundex - Wikipedia, the free encyclopedia

[rsingh]

There's also a version in MSSQL for this.

See the following page

[Olly]

oops forgot to add....this is running under MS Access

[Olly]

This looks like the puppy Fuzzy Matching Demo in Access - CodeGuru

a DB of names and uses a few fuzzy algorithms...looks like I've got my work cut out digging through it all

[Platypus]

I've looked into this very heavily in the past.

Arguably, SMITH and MSITH are the same name, due to a typo. Or SMITH and WMITH

In my case, I used several algorithms to judge similarity between names and addresses, and weighted them to give a final score.

Here's a link you may find useful:
Approximate string matching - Wikipedia, the free encyclopedia

Also Google for N-Gram, Levenstein and Hamming.

[mudskipper]

oops forgot to add....this is running under MS Access

Maybe this will be useful...

[Olly]

right then...I'm getting there with this
I've built a small table from existing matched data of names and abbreviations
eg. William = Bill

I'd really like a full multicultural data set...any pointers please?