The String Matcher node is able to compare two lists of strings, compute the distance between these strings and list the most similar strings in the output table. The node requires two input data tables. A data table containing the strings to compare and a data table containing a dictionary. The String Matcher finds for each element of the data table the most similar words in the dictionary table. To compare the elements the levenshtein-damerau-distance is used. This function calculates how many insertions, deletions, changing and swappings are at least necessary to change one word into another. To find an optimal solution it is necessary that the weight of two switches is greater or equal than the weight of an insert and a deletion.
Options
Popular Predecessors
Excel Reader (XLS)8 %File Reader7 %- GroupBy5 %
- Table Creator3 %
- String Manipulation3 %
- Excel Reader2 %
Row Filter (deprecated)2 %Database Reader2 %- Save Workflow2 %
Cell Splitter2 %- Column Filter2 %
Excel Reader (XLS)1 %- Joiner1 %
- Molecule Type Cast1 %
- Chunk Loop Start1 %
Number To String1 %XLS Reader1 %- Duplicate Row Filter1 %
- Cell Splitter< 1 %
Column Rename< 1 %- Parallel Chunk Start< 1 %
- Missing Value Column Filter< 1 %
- Pivot< 1 %
- Rule-based Row Splitter< 1 %
Strings To Document< 1 %- Ungroup< 1 %
- Unpivot< 1 %
- Index Query< 1 %
- String Matcher< 1 %
- Number to String< 1 %
- Chi-Square Keyword Extractor< 1 %
- Concatenate< 1 %
- Column Combiner< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- RowID< 1 %
- Sorter< 1 %
- Rule-based Row Filter< 1 %
- Bag Of Words Creator< 1 %
Loop End< 1 %- String to Number< 1 %
- Nominal Value Row Filter< 1 %
Excel Reader (XLS)< 1 %- File Reader< 1 %
- Group Loop Start< 1 %
- Constant Value Column< 1 %
- Reference Row Splitter< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Rule Engine< 1 %
- Empty Table Creator< 1 %
Bag of Words Creator< 1 %- String Manipulation (Multi Column)< 1 %
- CSV Reader< 1 %
- Table to String< 1 %
Variable to Table Row< 1 %- Case Converter< 1 %
- Column Aggregator< 1 %
- Filter Apply Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Subset Matcher< 1 %
- Missing Value< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Keygraph Keyword Extractor< 1 %
- Case Converter< 1 %
- Tag Filter< 1 %
- Document Data Extractor< 1 %
- Sentence Extractor< 1 %
- Strings to Document< 1 %
- Cross Joiner< 1 %
- Shuffle< 1 %
- DB Query Reader< 1 %
- Stresser< 1 %
- Column Expressions< 1 %
- Snowball Stemmer< 1 %
- Variable to Table Row< 1 %
- Column Comparator< 1 %
- Table Manipulator< 1 %
- Missing Value (Apply)< 1 %
- Table Editor (JavaScript)< 1 %
- Table Reader< 1 %
- Google Sheets Reader< 1 %
- CASE Switch End< 1 %
Table Row To Variable Loop Start< 1 %Line Reader< 1 %- Reference Column Filter< 1 %
- Partitioning< 1 %
- Data Generator< 1 %
Document Data Extractor< 1 %- Term to String< 1 %
- R Snippet< 1 %
- String to Date&Time< 1 %
List Files< 1 %- DB Reader< 1 %
- Kuhlen Stemmer< 1 %
- Porter Stemmer< 1 %
- JSON Path< 1 %
- RDKit Canon SMILES< 1 %
- Row Filter (Labs)< 1 %
- Advanced MolConverter< 1 %
- Create Collection Column< 1 %
- Java Edit Variable< 1 %
Recursive Loop Start (2 ports)< 1 %- Column Merger< 1 %
- Category to Class< 1 %
- String to Term< 1 %
- Decision Tree Predictor< 1 %
- Filter Apply< 1 %
- IF Switch< 1 %
- Tika Parser< 1 %
- Table View (JavaScript)< 1 %
- Java Snippet< 1 %
Generic Loop Start< 1 %Recursive Loop Start< 1 %String To Number< 1 %- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Numeric Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- OpenBabel< 1 %
- Math Formula< 1 %
- DF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Modifiable Term Filter< 1 %
- PDF Parser< 1 %
- Split Collection Column< 1 %
Recursive Loop End< 1 %- Column Name Extractor< 1 %
- SDF Extractor< 1 %
- Similarity Search< 1 %
- Dictionary Filter< 1 %
- Tags to String< 1 %
- Date&Time to String< 1 %
- Date Field Extractor (legacy)< 1 %
- String Similarity< 1 %
- Duplicate Filter< 1 %
- Domain Calculator< 1 %
- Math Formula (Multi Column)< 1 %
- Tika Parser URL Input< 1 %
- Replacer< 1 %
Regex Extractor< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %CSV Reader< 1 %Table Reader< 1 %- Column List Loop Start< 1 %
Concatenate (Optional in)< 1 %- Rank< 1 %
- String Splitter (Regex)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- SDF Reader< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Term Co-Occurrence Counter< 1 %
- Frequency Filter< 1 %
- NGram Creator< 1 %
- N Chars Filter< 1 %
- Document Data Assigner< 1 %
- GET Request< 1 %
Extract Date&Time Fields< 1 %- Molecule to CDK< 1 %
- HTTP Retriever< 1 %
- Binary Objects to Strings< 1 %
Variable to Table Column< 1 %Database Connection Table Reader< 1 %- Cell Splitter By Position< 1 %
Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Constant Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- Rule Engine Variable< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- TF< 1 %
- Diacritic Remover< 1 %
- Dictionary Replacer (File-based)< 1 %
- Punctuation Erasure< 1 %
- RegEx Filter< 1 %
Stop Word Filter< 1 %- Stop Word Filter< 1 %
- Flat File Document Parser< 1 %
- Unique Term Extractor< 1 %
- String Configuration< 1 %
- List Box Widget< 1 %
- Table to JSON< 1 %
- Parameter Optimization Loop Start< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒1)< 1 %Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %Python Script (2⇒2)< 1 %- Python Source (legacy)< 1 %
Hash Calculator< 1 %- Strings to Binary Objects< 1 %
- Table Row to Variable< 1 %
- String to SVG< 1 %
- Create Table Structure< 1 %
- Double to Integer< 1 %
- HiLite Row Splitter< 1 %
- Number Rounder< 1 %
- Rule Engine (Dictionary)< 1 %
- Empty Table Switch< 1 %
- Counter Generation< 1 %
- Random Matcher< 1 %
Read Excel Sheet Names (XLS)< 1 %- Markup Tag Filter< 1 %
- List Files/Folders< 1 %
- XPath< 1 %
- Remove Empty Rows< 1 %
- HTTP Result Data Extractor< 1 %
Views
- This node has no views
Workflows
03_Co-occurrence_NetworkKNIME Hub- 03_Co-occurrence_NetworkKNIME Hub
- 03_Co-occurrence_NetworkKNIME Hub
- 09_Fuzzy_String_MatchingKNIME Hub
- 09_Fuzzy_String_MatchingKNIME Hub
- Show all 36 workflows
Links
- Similarity search?by izaychik63 on 2019-07-15forum.knime.com/p/65532
- Text processing and comparison of two different set of documentsby HansS on 2019-08-04forum.knime.com/p/67111
- Better Comparison in String manipulationby izaychik63 on 2019-09-20forum.knime.com/p/70552
- Fuzzy Text Match/Similarity Searchby izaychik63 on 2019-09-18forum.knime.com/p/70378
- Allocate Misspelled country names to correct country namesby armingrudd on 2019-05-08forum.knime.com/p/60168
- Show all 6 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.