robust soundex variant)
> would get this case right, and all the
mis-spelling systems I've ever
> implemented have been suplemented with a set of
heuristics (like searching
> for all single-letter drops, adds, and
transpositions) and often a
> mis-spelling database in an attemp
I want to use SOUNDEX for name queries, but I don't
seem to be doing it correctly.
As a test, I made a small table and popluated it
with my name. My goal is to be able to find my name
'Callaghan', with its most common misspelling
'Callahan'.
I've read the MySQL doc, so I know how to actual