I'm looking for a snippet of VBA code that can be used in Access to perform a search on a set of strings such that:
If "applesauce road" is sought,
"aplesauce road", "applesc rd", etc.... will be found. (And vice versa?)
In other words, a fuzzy search that will rank similar text strings by content and sequence of characters, to enable misspellings and alternate spellings to be considered as potential matches.
As far as I'm concerned, the code can be independent of Access so long as it is in some form of VB/BASIC and doesn't rely on functions to which I don't have access...so to speak... I'll migrate it so that it works for my application.