Compare and match 2 columns - ADD columns with mismatch result

Hello, Knime users!

I am a newbie on Knime and I was looking for a way to compare similar match from two different columns and files, so I found the topic below:

I have a problem where I have columns with text in 2 separate tables. I need to compare and match between the 2 columns. This would be an example: Table 1, Column 1: TRR6/7 Waterheater Table 2, Column 1: 654864273_ Waterheater TRR6/7 - Sparepart I need KNIME to compare and match between the 2 columns or give me a percentage of similarity. Thanks!

It worked very well for what I needed but I still wish to go a bit further.

I need to extract some more information using the query created my Mr. @aworker, and here is where I am stuck, and where I need your help.

1-) I need one additional column that can say for me what word it didnt find from one file to the other, for example:

File 1 has a row with the value: Honda Civic 1.5 Gasoline

The similarity process found a row in File 2 with the value: Honda Civic 1.5 Diesel

It has a distance of 0.25

I need a column saying that the word it did not find was Gasoline

2-) It would be good if I could get more then a unique result from the match, for example: I want to know every results where the distance on similarity check is from 0 to 0.3, not only the most similar match, and if it did not find anything on this range it should show no result at all.

Is any of these two topics possible to add on the original query? And if it how could I do that?

Thank you very much!