MULT_EXACT comparison

Compares all words in one column of a record with all words in the same column of a second record.

Required Columns

The following data source and reference source columns are required.

  • Data. The character string from the data source.
  • Reference. The character string from the reference source.

Example

This comparison is similar to array matching, except that the individual words are considered to be the array elements. This match comparison allows matching of free-form text where the order of the words might not matter and where there might be missing words or words in error. The score is based on the similarity of the columns.

For example, the first address matches the second address if all words are inspected.


Building 5 Apartment 4-B


Apartment 4-B Building 5