Find common Words in Strings
I have two tables containing names and I want to find which entries are the same (or nearly the same). Unfortunately, the data in the second table is quite messy. Therefore came up with the idea to match names if they have the same words.
Here is an example:
Table 1 might contain:
Doe, JohnTable 2 might contain something like:
Doe John
John Doe
Doe, John James
Mr. John Doe, Knime SpecialistIt might also contain similar entries which should not be matched, because they do not contain “John” and “Doe”
James Doe
Doo, JohnI would like to obtain some kind of matching score. I tried the string similarity nodes, but all of then rank
Doo, Johnhigher than
Mr. John Doe, Knime Specialist. This is bad for my application because I know that spelling mistakes are not very common, but permutations of words and additions (like “Knime Specialist”) are.