It would be helpful to have some sample data to see more clearly the
matching criteria you wish to do.
I might suggest you visit the Tips and Techniques section of my web site
http://www.sconsig.com and scan through the various tips (also try doing a
FIND in the window on key words such as "merge", "fuzzy", "linking", "SQL",
"closest", "match" and maybe other key words I haven't mentioned.
When you have some sample data, I would be happy to see what you have and
maybe offer a possible solution but can not promise anything. When I do my
fuzzy match/merge routines, it normally takes me about 30-40 hours to
produce a customize solution for a given client based upon their criteria
Hope the existing tips might be of some help.