# Fuzzy match rows in one column **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [November 17, 2023, 8:34pm UTC](https://forum.knime.com/t/fuzzy-match-rows-in-one-column/75366 "2023-11-17T20:34:15Z")\ **Posts on this page:** 1\ **Showing post:** 7
**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:** [December 6, 2023, 7:07pm UTC](https://forum.knime.com/t/fuzzy-match-rows-in-one-column/75366/7 "2023-12-06T19:07:04Z")
@robvp I once created this workflow that would group addresses without a ground truth against which to match. Maybe you can adapt that. > [@How can I define and list the duplication in an adress data set sucessfully, with using String Distances node and Similarity Search node?](https://forum.knime.com/t/how-can-i-define-and-list-the-duplication-in-an-adress-data-set-sucessfully-with-using-string-distances-node-and-similarity-search-node/42568/12): > > @DAmei I had another look and I built a slightly over engineered workflow to try and get what you want combining some of the approached already mentioned. In your case there might not be a ground truth against wich to match but rather a lot of possible combinations. So configuration will be necessary and maybe exclude some obvious detaches in the first place. What the workflow does: the address is turned into a standardised string. The composition of the string will influence the matching. So… If you apply this it looks something like this: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/e/beb85d0728d489ea30736cc9d210d6a181af3142.png) 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. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/a/0af77890ae9fa13495174f8b55f89060b9c6acc2.jpeg) If you set the threshold to 0.33 (instead of 0.25) the result would be this: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/d/ad66bce384209833f0e7ca8e7dfddeab7362b39d.png) What you could do would be to try change the order of the words so that similar words would have other positions. > **[String Deduplication without Ground Truth - KNIME Forum (75366) – mlauber71](https://hub.knime.com/mlauber71/spaces/Forum/2023/String%20Deduplication%20without%20Ground%20Truth%20-%20KNIME%20Forum%20(75366)~BjpzeM4_4SlKnA-u/current-state)** > > Match similar addresses from one list together into similar groups KNIME Forum (75366) https://forum.knime.com/t/fuzzy-match-rows-in-one-column/75366/7?u=mlaub… [String Deduplication without Ground Truth - KNIME Forum (75366).knwf](https://forum.knime.com/uploads/short-url/bVMc5d6XdTdDNlT6n4NbusCpHt3.knwf) (192.9 KB) --- _[View the full topic](https://forum.knime.com/t/fuzzy-match-rows-in-one-column/75366)._