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 Successors
- Joiner7 %
- Excel Writer4 %
Row Filter (deprecated)4 %- CSV Writer3 %
- GroupBy3 %
Column Appender2 %- Loop End2 %
- Column List Loop Start2 %
- Value Counter2 %
- Parallel Chunk End2 %
- Duplicate Row Filter2 %
- IF Switch2 %
- Cell Splitter1 %
- String Replacer1 %
- Column Filter1 %
Row Splitter (deprecated)1 %- Reference Row Filter1 %
Column Rename1 %- String Matcher1 %
- Missing Value1 %
- Math Formula1 %
- Duplicate Filter< 1 %
- Missing Value Column Filter< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter< 1 %
- Conditional Box Plot (legacy)< 1 %
- Similarity Search< 1 %
- Term to String< 1 %
Loop End< 1 %- Fuzzy Rule Learner< 1 %
- Concatenate< 1 %
Concatenate (Optional in)< 1 %Cell Replacer< 1 %- Column Aggregator< 1 %
- Column Appender< 1 %
- Constant Value Column< 1 %
Joiner< 1 %- Sorter< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Unpivot< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- Timer Info< 1 %
- String Distances< 1 %
- Column Expressions< 1 %
- Porter Stemmer< 1 %
- Document Data Assigner< 1 %
- Strings to Document< 1 %
- XPath< 1 %
- String Similarity< 1 %
Database Update< 1 %Table Writer< 1 %- Loop End (Column Append)< 1 %
- Row Filter (Labs)< 1 %
String Replace (Dictionary)< 1 %- Table Indexer< 1 %
Excel Writer (XLS)< 1 %- Term Co-Occurrence Counter< 1 %
- RegEx Filter< 1 %
- Tag Cloud< 1 %
- String to Path< 1 %
- Java Snippet< 1 %
- Subset Matcher< 1 %
- Reference Column Resorter< 1 %
- Color Manager< 1 %
- Matrix Distance< 1 %
- Math Formula (Multi Column)< 1 %
- Frequency Filter< 1 %
- Keygraph Keyword Extractor< 1 %
- Markup Tag Filter< 1 %
- Dictionary Filter< 1 %
- RDKit Interactive Table< 1 %
CSV Writer< 1 %- Java Edit Variable< 1 %
Recursive Loop End< 1 %Scorer< 1 %- Rank< 1 %
- RowID< 1 %
- Numeric Row Splitter< 1 %
- Top k Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Interactive Table (legacy)< 1 %
- Counter Generation< 1 %
- Distance Matrix Writer< 1 %
- Scatter Plot (JFreeChart)< 1 %
XLS Writer< 1 %Excel Sheet Appender (XLS)< 1 %- DF< 1 %
- TF< 1 %
- Category to Class< 1 %
- Document Vector< 1 %
- String to Term< 1 %
- Term Neighborhood Extractor< 1 %
- Table View (JavaScript)< 1 %
- Parameter Optimization Loop End< 1 %
- Append to Collection< 1 %
- Strings to Binary Objects< 1 %
- String to URI< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %Database Writer< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Recursive Loop End (2 ports)< 1 %Naive Bayes Learner< 1 %- Fuzzy c-Means< 1 %
- k-Means< 1 %
- Regression Predictor< 1 %
- Tree Ensemble Predictor< 1 %
- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
- Column Comparator< 1 %
String To Number< 1 %- Column Merger< 1 %
- Column Resorter< 1 %
- One to Many< 1 %
- Cross Joiner< 1 %
- Table Validator< 1 %
- Edit Nominal Domain< 1 %
- Reference Column Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- Pivot< 1 %
- String Splitter (Regex)< 1 %
- Extract Table Dimension< 1 %
- Molfile Writer< 1 %
- Distance Matrix Calculate< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- HeatMap (JFreeChart)< 1 %
- Index Query< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Java IF (Table)< 1 %
Send to Tableau Server (TDE)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Tika Language Detector< 1 %
- Case Converter< 1 %
- Hyphenator< 1 %
- Punctuation Erasure< 1 %
- RSS Feed Reader< 1 %
- Dictionary Tagger< 1 %
Wildcard tagger< 1 %- OpenNLP NE Tagger< 1 %
- Bag Of Words Creator< 1 %
- Tags to String< 1 %
- Document Viewer< 1 %
- Tagged Document Viewer< 1 %
- Python View (legacy)< 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.