HI , Following php functions may be usefull http://www.php.net/soundex http://www.php.net/similar_text Just try to make good algoritham ;) Zareef Ahmed "Pete Holsberg" <pjh@xxxxxxxx> wrote in message news:Pine.GSO.4.10.10409052137110.20729-100000@xxxxxxxxxxxxxxxxxx > Is there a way to program MySQL so that it can find the > name "Smyth" if the user looks for "Smith"? And similar > mispellings that are similar in sound. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php