My linking script block entry is an implementation of the Levenshtein Distance Algorithm to suggest links between two sets/tables of data. The algorithm produces a metric that determines how alike two strings are and in this base, we make a link between the records that are “sufficiently” similar.

This script could be used to match two sets of data – for example a “master” customer list and a second set of customer data from another source. The script would suggest that, perhaps “Mr Jonathon Bowe” could be matched with “Jonathan Bowen”.

Check out the Airtable Universe base with this script in action here.

See the source for examples and how to use the script.