Home > DupeBlocker Step by Step Instructions > Scenarios > Mapping Types Described in Detail

Mapping Types Described in Detail

Country Match

Standardizes field values for the recognized countries of the world based on rules established in the Country Filtering list in DupeBlocker Settings.  It will recognize the long name of a country, the 2 digit ISO short form, the 3 digit ISO short form and the numeric ISO country value as possible matches of each other.  These lists are customizable.

Domain

Allows for the independent analysis of the domain information contained within a website URL or email address.  For email addresses it uses any information to the right of the @ sign.  For web pages it parses the XXXXX.com portion.

Exact

100% match of every character.

First Name

Applies the Nickname Filtering list in DupeBlocker Settings.  The Nickname list will see Bill, William and Billy as potential duplicates of each other.  This list is customizable.

First XX Letters

Compares the first XX letters in a field.  When selected, the number of letters to be matched needs to be specified in scenario rule.  Commonly used as looser technique for identifying matches for Account/Company Names and to match just on first initial of First Name.



Numeric

Compares only the numeric values in a field.  All other characters, such as spaces or punctuation, will be ignored by the deduper.  Commonly used with phone numbers to just look at the series of numbers regardless of punctuation.

Relaxed NA Phone Match

Designed specifically for 10 digit North American phone numbers.  Ignores all non-numeric characters and spaces, leading 0's or 1's, area codes and extensions.  For example, +1 (888) 555-1212 x55 will be interpreted as "5551212" and will match to 888-555-1212.  Since area codes are ignored, will also match to (617) 555-1212 to (781) 555-1212.

Relaxed Street Address Match

Parses the street address to the lowest common denominator, street number and name.  Although based on North American standards, it has also proved effective with most country address formats.

Example:

Apt#4, 123 Pavillion Street
123 Pavillion, Apt 4
4-123 Pavillion Ave NW
Are all seen as the lowest common denominator of "123 Pavillion"

Street Address Match

Slightly more rigid than Relaxed Street Address Match.  Matches a street abbreviation with it's long equivalent.  For example, crescent -> cres, road -> rd, street -> st, etc.  Will also match other common abbreviations in street addresses.  For example, North -> N, Suite -> Ste etc.

Zip 5 and 9

Matches a 5 digit USPS zipcode to it's 9 digit equivalent.

DupeBlocker Settings

More information on customizing DupeBlocker Settings for use with the following mapping types, Cleaned Account Name, FirstName, Country Match can be found in DupeBlocker Installation -> Initial Configuration of DupeBlocker ->DupeBlocker Settings.

Mapping Options

Additional mapping options, English Fuzzy, Transpose and AlphaClean, can be added to further refine the match.

• English Fuzzy:  Phonetics engine capable of analyzing words for how they sound when pronounced.  Through a technique of removing vowels and analyzing the remaining consonants the fuzzy engine works well for matching fields with spelling mistakes.  Numeric characters are ignored with this option.  DO NOT USE for matching phone numbers or other fields that contain numeric characters that you do not wish to ignore (i.e. street addresses).
• Transpose:  Matches all words in a field regardless of their order.  For example, "Smith and Jones" will match to "Jones and Smith".
• AlphaClean:  Strips out non-alphanumeric characters.  Just look at A-Z and 0-9, ignore everything else.  Commonly used to ignore punctuation in a field.

See also