Join Adresses with different Writings

[mlauber71]

@JoshuaBoth you can take a look here.

address deduplication, string similarity and fingerprinting (a collection) –...

You can join together addresses with similarity

Fuzzy Matching on One Column to then form Group IDs

@qdmt you could try and adapt this example: It does work without a ground truth but just will try to group the Term you create into distinctive groups based on the items you put into the string (called “Description”) … [image] … and then the threshold you set for matches (0.25). [image] In the end if possible each items will either be in a group or will be its own group: [image]

Fuzzy match rows in one column

@robvp I once created this workflow that would group addresses without a ground truth against which to match. Maybe you can adapt that. If you apply this it looks something like this: [image] You can edit the threshold which would constitute a similarity (Similarity Search – KNIME Community Hub) and maybe also configure the method. [image] If you set the threshold to 0.33 (instead of 0.25) the result would be this: [image] What you could do would be to try change the order of the wor…