Partial Match List

Partial matching is often problematic.

I've run your two lists through some experimental software which aims to identify best matches by looking for short substrings of characters in common.

Please see the two attachments.

Save the TSV file to a convenient location and open up the workbook.

Hit the go button and pick the TSV file at the prompt.

You will then get a form which will show the 20 closest matches for each of the terms in column E. Click the appropriate radio button and then move to the next one.