Use Soundex for indexing/searching by name

We've run into several cases where an admin tries to find someone (typically for recording service attendance or a financial transaction), but can't find them due to a spelling variation. When this happens, we often times run into the admins creating duplicate people, which we then need to merge together when we run our duplicate people check each quarter.

Soundex is an algorithm for indexing names based on how they sound, rather than the literal spelling. If the search used Soundex for name matching, it think it would drastically reduce these cases of not being able to find people, and would make the search feature a bit more user friendly.

Many programming languages and database query engines have variations of the Soundex algorithm built-in. For more information:

Login or Signup to post a comment