I have set up the Fuzzy match tool to match on an employee ID as the unique record, with Match criteria for Phone and Business Address.
I have some records where it is a 98% match and corrects Dr with Drive. But I have some records where they are identical, yet no matching score is computed:
| ID1 | ID2 | MatchScore | MatchScore_Phone | MatchScore_Bus_Address | MatchKey |
| G9AAAAP | G9AAAAP | | | | 1649213|1400 |
| G9AAAAP | G9AAAAP | | | | 1649213|500 |
| G9AAAAP | G9AAAAP | | | | 1649213|PLFRT |
| G9AAAAP | G9AAAAP | | | | 1649213|PRK |
| G9AAAAP | G9AAAAP | | | | 1649213|ST |
| | | | | | |
| 018HHHG | 018HHHG | | | | 1649213|1440 |
| 018HHHG | 018HHHG | | | | 1649213|500 |
| 018HHHG | 018HHHG | | | | 1649213|PLFRT |
| 018HHHG | 018HHHG | | | | 1649213|PRK |
| 018HHHG | 018HHHG | | | | 1649213|ST |
They have the same match keys, but it does not associate them together. Any help is appreciated, spent a couple hours on this and it doesn't make sense, especially when other records are matching, some with 100%, some with 98%, etc. From my understanding, as long as ALL keys match, it should associate them.