I have a table in mySql database containing the complete information of a user. Now, I want to find the record of the user on the basis of user name entered by user. And I want to make my matching intelligent for example if user enters "Bilal Ahmed" and the actual entry in table is "Bilal Ahmad". Notice there is the difference of just single character. Soundex will be time consuming and will not effective too from accuracy point of view as I have 17 lakh records increasing dat by day ... kindly suggest me how I can approach to this issue ?