1.3.4.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