Phonetic Search

[Kundan]

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: https://www.mrexcel.com/forum/microsoft-access/1085969-phonetic-search.html
Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3

[OBP]

Nope, no code.
If you want it you will have to build it.
Ideally you control the input to prevent that kind of error.

[PhilS]

Allen Browne has a Soundex Implementation in VBA (http://allenbrowne.com/vba-Soundex.html) on his website.
I would recommend you store the Soundex-Value of the fields you want to search in together with the data in the table and compare to these fields in your search query. Computing the Soundex for a large number of records during query execution will severely degrade performance.