Phonetic search

[prkundan]

In a Search Engine, even if we type something wrong how do they find out the correct word?
Is there any phonetic search?
For instance if in my DBthe word “John” is typed as “Jahn” or “Jan” or “Jon”. While searching I should get all these related entries. Is there any code for it?

 

[Macropod]

Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?64555-Phonetic-Search
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[stumac]

There is an old algorithm called Soundex that converts words into a code - for search engines that has been replaced with far more sophisticated solutions with each one using their own specific code.

Soundex may be a good start for you, here is a link to an Allen Browne page with the code for MS Access:

http://www.allenbrowne.com/vba-Soundex.html

 

[prkundan]

There is an old algorithm called Soundex that converts words into a code - for search engines that has been replaced with far more sophisticated solutions with each one using their own specific code.

Soundex may be a good start for you, here is a link to an Allen Browne page with the code for MS Access:

http://www.allenbrowne.com/vba-Soundex.html

Thanks a Lot!!!!!!!!! GOD BLESS YOU!!!