String matching in one column

Hi!

I have a question regarding the matching of strings in one column.

There are three adress columns, which are partially filled but also contain empty entries. Initially, I replaced all empty entries with and combined the three address columns into a single one. To simplify, I only kept this adress column and the corresponding name column in the table. Then I removed all .

My problem is that I don’t have two columns but one to compare. When testing with string similarity node every entry in the similarity column has the value 1 because I could only compare one address with itself.

How can I check if these addresses match or show similarities?

Thanks in advance!