# To find Address Variation

**URL:** <https://forum.knime.com/t/to-find-address-variation/34461>\
**Category:** KNIME Analytics Platform\
**Created:** [July 7, 2021, 1:41pm UTC](https://forum.knime.com/t/to-find-address-variation/34461 "2021-07-07T13:41:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prag\_Mor](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/7c8e57/32.png) [@Prag\_Mor](https://forum.knime.com/u/Prag_Mor)\
**Post date:** [July 7, 2021, 1:41pm UTC](https://forum.knime.com/t/to-find-address-variation/34461/1 "2021-07-07T13:41:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [July 7, 2021, 1:45pm UTC](https://forum.knime.com/t/to-find-address-variation/34461/2 "2021-07-07T13:45:13Z")

</div>

You might want to check out these collections:

> **[address deduplication, string similarity and fingerprinting (a collection) –...](https://hub.knime.com/mlauber71/spaces/Public/_adress_dedupe_string_similarity~MpPcaokcf9j8TF0j/current-state)**
>
> address deduplication, string similarity and fingerprinting (a collection) A few links and ressources I collected about address deduplication and string simila…

> [@Namensabgleich](https://forum.knime.com/t/namensabgleich/19232/2):
>
> 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](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…](http://download.nodepit.com/palladian/4.0)

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [January 6, 2022, 1:45am UTC](https://forum.knime.com/t/to-find-address-variation/34461/3 "2022-01-06T01:45:40Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.