fuzzy matching

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Olly replied

14 June 2010, 12:24
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?
Leave a comment:
mudskipper replied

11 June 2010, 15:50
Originally posted by Olly View Post

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

Maybe this will be useful...
Leave a comment:
Platypus replied

11 June 2010, 13:28
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.
Leave a comment:
Olly replied

11 June 2010, 12:59
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
Leave a comment:
Olly replied

11 June 2010, 12:51
oops forgot to add....this is running under MS Access
Leave a comment:
rsingh replied

11 June 2010, 12:46
There's also a version in MSSQL for this.

See the following page
Leave a comment:
doodab replied

11 June 2010, 12:39
Originally posted by Olly View Post

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
Leave a comment:
Olly started a topic fuzzy matching

11 June 2010, 12:38
fuzzy matching

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
Tags: fuzzy matching