On duplicate checks of type 'Fuzzy matching', you can apply phonetic search algorithms. You can use a phonetic search algorithm to check on duplicate names that sound similar, for example, John and Jon.
To apply a phonetic search algorithm to a duplicate check, set up a phonetic search rule and link it to a field in a duplicate check.
The supported phonetic search algorithm is Metaphone. You can apply these versions of the Metaphone algorithm:
You are advised to start applying phonetic search with the basic setup, that is with the selected Phonetic search algorithm.
Based on testing and experience, you can finetune the phonetic search rule setup by defining:
1. | Go to Data quality studio > Setup > Phonetic search rules. |
2. | Click New. |
3. | In the Phonetic search rule field, type a value. |
4. | In the Phonetic search algorithm field, select an option. |
5. | Sub-task: Set phonetic search rule parameters. |
5.1 | Expand the Parameters section. |
5.2 | In the Phonetic key maximum length field, enter a number. |
6. | Sub-task: Define words for which no phonetic search key is desired. |
6.1 | Expand the Ignored words section. |
6.2 | Click Add line. |
6.3 | In the Word field, type a value. |
Related to | Notes |
---|---|
Set up duplicate check |
  |