by I'm using SQL Server 6.0 with a name & address database of around 1.5
million rows. I need to do the usual telephone query type stuff; given
a vague & mis-spelt name & address, place a small list of potential
matches into a list box, then select the best fit.
I'd be interested to share information with anyone else involved in
this sort of problem.
Particular questions are: how I can use Soundex, with my own
optimised variant of Soundex ? (Standard Soundex doesn't do Welsh
llanguagio very well !) Whats the best way to graft in a C++ function?
How can I best develop a "score" for "quality of match" that takes
into account all the fields in the search (which depends on what we've
been supplied with), and can weight them differently between fields ?
Thanks
--
If all it takes is an infinite number of monkeys with typewriters,
how come AOL haven't written any Shakespeare yet ?