Icon

03_​Example_​for_​Fuzzy_​Address_​Matching

Indexing and Searching plug-in for address database cleansing

This workflow demonstrates the Indexing & Searching plugin for address database cleansing.
It uses fuzzy queries to identify typos in a given address data base.
First an index is created on the data table. Once the index has been created it can be queried using a powerful query language.
The query syntax bases on the Lucene query syntax and supports among others phrase queries, wildcard queries, fuzzy queries, proximity queries, range queries, term boosting, grouping and boolean operators.

Evaluate the results by filtering the generated noisyaddresses This workflow demonstrates the usage of the Indexing & Searching plugin for address data base cleansing.For more information see the workflow metadata. Find it here: View -> Description 1k addressescreate index from the addresses for searchingconvert numbers such as PLZto string forfuzzy matchinglucene score > 2duplicatesto review -each row representsan address with the typos that occureduse configureto change thesensitifity levelof the fuzzy searchduplicate 50% of theaddresses by adding noisy entries by mutatingletters and generatinggiven name abbrevationsfilter resultsto show onlythe duplicateaddressesnot detected duplicates File Reader Table Indexer Number To String(deprecated) Row Filter GroupBy Search Duplicates Generate Noise Extract Duplicates ReferenceRow Filter Evaluate the results by filtering the generated noisyaddresses This workflow demonstrates the usage of the Indexing & Searching plugin for address data base cleansing.For more information see the workflow metadata. Find it here: View -> Description 1k addressescreate index from the addresses for searchingconvert numbers such as PLZto string forfuzzy matchinglucene score > 2duplicatesto review -each row representsan address with the typos that occureduse configureto change thesensitifity levelof the fuzzy searchduplicate 50% of theaddresses by adding noisy entries by mutatingletters and generatinggiven name abbrevationsfilter resultsto show onlythe duplicateaddressesnot detected duplicatesFile Reader Table Indexer Number To String(deprecated) Row Filter GroupBy Search Duplicates Generate Noise Extract Duplicates ReferenceRow Filter

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2025-02-18
Last update: 2026-07-19
Created with KNIME version: v4.1.1
Tags: ETLqueryindexing

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!