Re: newbie SOUNDEX question

2002-06-07 Thread Dave Callaghan
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

newbie SOUNDEX question

2002-06-07 Thread Dave Callaghan
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