Albert D. Kallal published an how to implement a “soundex” search in Access. For the uninitiated, a soundex search returns not only exact matches, but also any near matches that sound like the search term. For e.g., searching for Cindy also returns Cyndi, Cynthia, or Cinda.
Here’s an excerpt: “While for many, the idea of an intelligent search form in Access that allows fuzzy name matching sounds like real magic. To us folks who been around a long time we instantly recognize this as a soundex type of search. While we’re not going to build next great search engine in Access, it’s rather easy to build a search based on names that sound the same. The end result is a search form that behaves much like using any modern search engine on web where exact name spelling matches aren’t required for search.”
More Info: Code samples and Example database