Loading

Salesforce Duplicate Management — Fuzzy Match on First Name Doesn't Detect Expected Duplicates

Publish Date: Jun 4, 2026
Description

You may notice that certain name variations are not detected when utilizing First Name with Fuzzy Logic in Salesforce Duplicate Management Matching Rules, even when they exceed the Jaro-Winkler threshold. Please see the examples below.


Matching Rule (Contact): (Contact: FirstName FUZZY: FIRST NAME MatchBlank = FALSE) AND (Contact: LastName FUZZY: LAST NAME MatchBlank = FALSE) AND (Contact: Email EXACT MatchBlank = FALSE)


Example records where the duplicate rule IS detected:

 

First NameLast NameEmailJaro-Winkler Score (Fuzzy: First Name)
JonSputenbergerjsputen@gmail.comBase record (no score)
JonathanSputenbergerjsputen@gmail.com85
SamSmithssmith@gmail.comBase record (no score)
SamuelSmithssmith@gmail.com88
DanSteeledsteele@gmail.comBase record (no score)
DanielSteeledsteele@gmail.com88

Example records where the duplicate rule is NOT detected:

First NameLast NameEmailJaro-Winkler Score (Fuzzy: First Name)
RajPerumalr_perumal@ducks.caBase record (no score)
RajeshPerumalr_perumal@ducks.ca88
JayAloclekjaloclek@gmail.comBase record (no score)
JaysonAloclekjaloclek@gmail.com88
SalBrennersbrenner@gmail.comBase record (no score)
SalimaBrennersbrenner@gmail.com88



Resolution

When using Fuzzy Logic with First Name in a Salesforce Duplicate Management Matching Rule, not all name variations that exceed the Jaro-Winkler threshold will trigger a duplicate match. This occurs because fuzzy logic relies on pre-captured name patterns on the matching server — the detection is not based solely on the numeric score.
As you can see in the examples above, all of these records exceed the Jaro-Winkler threshold. However, only half of these records will detect the duplicates based on the above matching rule. The reason for this is due to scenarios where expected matches will return a negative result if the name variation pattern was not already captured on the matching server. Fuzzy logic is not meant to be exact.
Ideally, additional matching criteria should be put in place, such as address fields. This ensures that duplicate matches are returned from the server when utilizing fuzzy logic.


Knowledge Article Number

000389625

 
Loading
Salesforce Help | Article