Use the Match Options dialog box to set advanced filtering criteria for the Check for Duplicates wizard. Options set here apply each time you check for duplicate data.
Option | Definition |
---|---|
Duplicate | Type a number to define the range of results that SpeedSearch marks as a duplicate. For example, if the range is between 50 and 100, any records that match 50% of their values will be returned as a duplicate. |
Possible Duplicate | Type a number to define the range of results that SpeedSearch marks as a possible duplicate. |
Not Duplicate | Displays the range of results that SpeedSearch marks as not a duplicate. This range is determined by the Duplicate and Possible Duplicate values. |
Use Stemming | Select this option to allow other grammatical forms of a word to be considered a duplicate. |
Use Phonic | Select this option to allow words that sound similar to be considered a duplicate. |
Use Synonym | Select this option to allows synonyms of a word to be considered a duplicate. |
Use Fuzzy | Select this option to allow words that are spelled differently to be considered a duplicate. After selecting this option, set the Fuzziness Level to determine how many character differences a word can have and still be considered a duplicate. |