Advanced search-method

elwin68

Does anyone have any experience with search-methodes?
I'm importing customer-names within Navision. When for example the name ‘smith’ is imported, the following names should be found: smith, smyth, smit.
Is there a solution for this problem.

Thanks in advance,

Elwin van den Bergh

Luc_VanDyck

Look at this page: http://www.outfitters.com/genealogy/what-soundex.html

It describes the algorithm for the Soundex code.
<start quote>
The Soundex code is an indexing system which translates names into a 4 digit code consisting of 1 letter and 3 numbers. The most familiar application of Soundex is its use by the US Bureau of the Census to create an index for individuals listed in the US census records after 1880.

The advantage of Soundex is its ability to group names by sound rather than the exact spelling. Take, for example, the name Paine. A census recorder or a family might spell the name variously as Paine, Pain, Pane, Payn, Payne, etc. The Soundex code for all of these is P500.
<end quote>

elwin68

Thanks for the answer. It's working great.

I wonder if there is a possibility to find names with a mistype in it.
Example: The imported name is: davidson
The names searched for: davitson, davidon
I know it isn't possible for 100%.

Elwin van den Bergh