Dear Knimers, Please need help to identify all the similar address with different variation Address variation XX Union Sq E Frnt 4C New York NY 10003-3314 XX Union Sq E New York NY 10003 XXX E 38th St Fl 19 New York NY 10016-2708 XXX E 38th St New York NY 10016-2708 1st and 2nd address is Similar only 4C and ‘-3314’ is different. 3rd and 4th address is similar ‘Fl 19’ is different. Please share me a workflow to identify 1000 address like above examples Thank you

You might want to check out these collections: [image] 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 simila… [image] Namensabgleich KNIME Analytics Platform This sounds like a job for adress deduplication or ‘fingerprinting’ Concerning adress deduplication @wiswedel provided some very useful workflows https://hub.knime.com/knime/spaces/Examples/latest/02_ETL_Data_Manipulation/05_Indexing_Searching/03_Example_for_Fuzzy_Address_Matching Fingerprinting using adresses (ignore the title) Compare string similarities (you may have to set a threshold) You would need Palladian for that: Repository to install Palladian http://download.nodepit.c…

To find Address Variation

KNIME Analytics Platform

mlauber71 July 7, 2021, 1:45pm 2

You might want to check out these collections: