Fuzzy Match Operation

Compare string values across two columns using approximate matching algorithms — Levenshtein edit distance or Soundex phonetic matching.

Fuzzy Match operations are available under Fuzzy Match > in the String column context menu. Two algorithms are supported.

Fuzzy Match sub-operations

Levenshtein

Computes the Levenshtein edit distance between each value in the source column and the corresponding value in a selected comparison column. The result is a numeric score representing the minimum number of single-character edits (insertions, deletions, or substitutions) required to transform one string into the other.

A lower score means the strings are more similar. A score of 0 means the strings are identical.

Levenshtein configuration

Field	Description
Select column to match	The column whose values are compared against the source column.
Create New Column	When enabled, writes the distance score to a new column.
Column Name	The name of the new column.

Example:

Source	Comparison	Levenshtein Distance
kitten	sitting	3
hello	hello	0

Soundex

Computes the Soundex phonetic code for each value in the source column and compares it to the Soundex code of values in a selected column. This allows matching strings that sound similar even if spelled differently.

Soundex configuration

Field	Description
Select column to match	The column whose phonetic codes are compared against the source column.
Create New Column	When enabled, writes the match result to a new column.
Column Name	The name of the new column.

Example:

Source	Comparison	Soundex Match
Smith	Smyth	true
Johnson	Jonson	true