--- andrew_maben <[EMAIL PROTECTED]> wrote: > A match on the initial letters is much too loose, an exact match is too > stringent. We're looking for the middle ground, erring (but not too far) > on the generous side. > > Any ideas? > > Thanks in advance for any light you may be able to shed. > > Andrew
You may need to make up your own synonym lists. However, the soundex() function for both PHP and MySQL is designed to address much of what you describe. Definition: http://en.wikipedia.org/wiki/Soundex PHP function: htpt://php.net/soundex MySQL function: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex James
