1.3.3.8.25 Comparison: Date Edit Distance
The Date Edit Distance comparison determines the Character Edit Distance between two Date values and Date Arrays.
Use the Date Edit Distance comparison to find either exact or close date matches. Use Date Edit Distance when dates have been manually specified in a system, rather than generated automatically, so the dates may be subject to typographical errors - for example to identify the values "01/08/1972" and "01/08/1772" as a possible match with a Date Edit Distance of 1.
This comparison supports the use of result bands.
Example Configuration
In this example, the Date Edit Distance comparison is used on a Date of Birth identifier to match people. Exact date matches (where the edit distance is 0) are categorized as matches, if the Name also matches. Close date matches (where the edit distance is 1) are categorized as possible matches (for review), if the Name also matches.
Match No Data pairs? = No
Ignore day? = No
Ignore month? = No
Ignore year? = No
Ignore century? = Yes
Time zone = Director Time Zone
Example Results
The following table shows example comparison results using the above configuration:
Table 1-64 Example Results: Date Edit Distance
| Value A | Value B | Comparison Result |
|---|---|---|
|
01/08/1972 |
01/08/1772 |
1 |
|
25/12/2006 |
25/12/1996 |
3 |
|
30/11/1999 |
30/11/1899 |
1 |