Similarity search

[ishvjosh]

I need to compare the names of vendor from two columns from the database and highlight cases where the name of vendors are not same. I don’t want to flag cases where the name mismatch is case sensitive, a small typo . How can i do this with similarity string? Is there any other way to go about it ?

[hmfa]

Hi @ishvjosh .

Have a look at this link. Maybe it helps you.

address deduplication, string similarity and fingerprinting (a collection)

address deduplication, string similarity and fingerprinting (a collection) A few links and ressources I collected about address deduplication and string similarity and fingerprinting A meta collection of KNIME ressources for address deduplication or ‘fingerprinting’ https://forum.knime.com/t/namensabgleich/19232/2?u=mlauber71 --------- Mr. Wiswedel is the man if it comes to address dedupe ... https://forum.knime.com/u/wiswedel/summary https://hub.knime.com/knime/spaces/Examples/latest/50_Appli…

Br

[danielesser]

String Similarity — NodePit

My first shot would be the String Similarity node from Palladian. The linked page contains example workflows and discussions.

Best regards,
Daniel