Using the Soundex Algorithm in Microsoft Access

The #Soundex algorithm is a phonetic algorithm to describe how words sound, particularly names. It generates identical “codes” for homophone words and thus allows to search for names by their sound.
Many database systems have a built-in Soundex function. Unfortunately, #MsAccess is not one of them. In this video I’ll show an implementation of Soundex in #VBA and explain how to use it in a Microsoft Access database.
The rules of the Soundex algorithm are maintained by the United States National Archives and Records Administration. You’ll find them at: www.archives.gov/research/cen...
Download the sample database I used for this video here: codekabinett.com/download/Nor...
00:00 Intro
00:33 Explaining Soundex
10:00 Soundex in Access and VBA
22:14 Further thoughts on implementation

[@johnclark851]

Very comprehensive coverage on a pragmatic topic. I can see a genuine application of this for service based companies who rely on user input. How you addressed possible pitfalls and how to mitigate them was nicely done, Philipp.

[@jimstauble9375]

Interesting concept. Can I download the procedures you have written to study the idea?

[@codekabinettcomen]

Look at the description of the video. There is a download link for the sample application used in the video.

[@abbottassociatesllcattorne5723]

Love using Soundex. Is there any way to sort the query results by soundex value, so that the most likely results rise to the top?

[@codekabinettcomen]

Actually, I don't know how it would be possible to identify "most likely" results in the context of sorting.