# Join Adresses with different Writings

**URL:** <https://forum.knime.com/t/join-adresses-with-different-writings/78468>\
**Category:** KNIME Analytics Platform\
**Created:** [April 11, 2024, 12:28pm UTC](https://forum.knime.com/t/join-adresses-with-different-writings/78468 "2024-04-11T12:28:35Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [April 11, 2024, 1:51pm UTC](https://forum.knime.com/t/join-adresses-with-different-writings/78468/2 "2024-04-11T13:51:49Z")

</div>

@JoshuaBoth you can take a look here.

> **[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…

You can join together addresses with similarity

> [@Fuzzy Matching on One Column to then form Group IDs](https://forum.knime.com/t/fuzzy-matching-on-one-column-to-then-form-group-ids/78240/2):
>
> @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”) … … and then the threshold you set for matches (0.25). In the end if possible each items will either be in a group or will be its own group:

> [@Fuzzy match rows in one column](https://forum.knime.com/t/fuzzy-match-rows-in-one-column/75366/7):
>
> @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: You can edit the threshold which would constitute a similarity ([Similarity Search – KNIME Community Hub](https://hub.knime.com/knime/extensions/org.knime.features.distmatrix/latest/org.knime.distmatrix.similaritysearch.SimilaritySearchNodeFactory/)) and maybe also configure the method. If you set the threshold to 0.33 (instead of 0.25) the result would be this: What you could do would be to try change the order of the wor…

---

_[View the full topic](https://forum.knime.com/t/join-adresses-with-different-writings/78468)._