String Similarity

Go to Product

Allows to calculate various string similarity metrics between two strings, like n-gram overlap, Levenshtein, and Jaro-Winkler.

If one of the input cells contains a “missing value”, a missing value will be returned as output as well.

Options

Text input 1
The column in the input table with the first string.
Text input 2
The column in the input table with the second string.
Similarity column name
The name of the column in the output table which contains the similarity value.
Similarity measure
The similarity measure to calculate.

Input Ports

Icon
Table which contains two columns with strings to compare to each other.

Output Ports

Icon
Table with an appended column holding the similarity between the strings for each row.

Popular Predecessors

  • Excel Reader (XLS)5 %
  • Joiner4 %
  • Column Appender3 %
  • Excel Reader (XLS)3 %
  • Column Rename3 %
  • Rule Engine3 %
  • File Reader2 %
  • Java Snippet2 %
  • Cross Joiner2 %
  • Joiner2 %
  • Ungroup2 %
  • Strings To Document2 %
  • Case Converter2 %
  • Column Aggregator2 %
  • Unpivoting2 %
  • Duplicate Row Filter2 %
  • Column Filter1 %
  • String Manipulation1 %
  • Term co-occurrence counter1 %
  • TF-IDF Similarity1 %
  • Sorter1 %
  • Concatenate1 %
  • Cell Splitter1 %
  • Constant Value Column1 %
  • Row Splitter1 %
  • GroupBy1 %
  • String Replacer1 %
  • Rule-based Row Splitter1 %
  • String Similarity1 %
  • Reference Row Filter1 %
  • Rank1 %
  • Similarity Search1 %
  • Group Loop Start1 %
  • Loop End1 %
  • Table Creator< 1 %
  • Column Resorter< 1 %
  • Row Filter< 1 %
  • Missing Value< 1 %
  • Rule-based Row Filter< 1 %
  • XLS Reader< 1 %
  • String Matcher< 1 %
  • Column Comparator< 1 %
  • Number To String< 1 %
  • Column Appender< 1 %
  • Column Expressions< 1 %
  • Variable to Table Column< 1 %
  • Table Row to Variable< 1 %
  • Table Row To Variable Loop Start< 1 %
  • Column Splitter< 1 %
  • String Manipulation (Multi Column)< 1 %
  • Excel Reader< 1 %
  • Column Rename (Regex)< 1 %
  • CSV Reader< 1 %
  • Lag Column< 1 %
  • Java Snippet (simple)< 1 %
  • Bag of Words Creator< 1 %
  • XPath< 1 %
  • Variable to Table Column< 1 %
  • Math Formula< 1 %
  • Document Grabber< 1 %
  • Document Data Extractor< 1 %
  • ContentExtractor< 1 %
  • Table Column to Variable< 1 %
  • N-Gram Extractor< 1 %
  • CSV Reader< 1 %
  • Nominal Value Row Splitter< 1 %
  • Number Filter< 1 %
  • Database Connection Table Reader< 1 %
  • Loop End< 1 %
  • Chunk Loop Start< 1 %
  • Column Combiner< 1 %
  • Excel Reader (XLS)< 1 %
  • NGram creator< 1 %
  • Case converter< 1 %
  • Single Selection Input QuickForm (legacy)< 1 %
  • Spell Checker (simple)< 1 %
  • Table Row to Variable< 1 %
  • Missing Value (Apply)< 1 %
  • RowID< 1 %
  • Document Data Extractor< 1 %
  • Table Row To Variable Loop Start< 1 %
  • Pivoting< 1 %
  • Dict Replacer (2 in ports)< 1 %
  • Bag Of Words Creator< 1 %
  • Term to String< 1 %
  • Column Distance< 1 %
  • Load Text Files< 1 %
  • Strings to Binary Objects< 1 %
  • Database Reader< 1 %
  • Column List Loop Start< 1 %
  • Filter Apply Row Splitter< 1 %
  • Reference Row Splitter< 1 %
  • Partitioning< 1 %
  • Numeric Row Splitter< 1 %
  • Target Shuffling< 1 %
  • CASE Switch Data (End)< 1 %
  • Parallel Chunk End< 1 %
  • Tika Language Detector< 1 %
  • Kuhlen Stemmer< 1 %
  • GET Request< 1 %
  • Bio Sequence Reader< 1 %
  • RDKit Count-Based Fingerprint< 1 %
  • Information Gain Calculator< 1 %
  • Regex Extractor< 1 %
  • PalladianNer< 1 %
  • Cell Splitter< 1 %
  • Row Sampling< 1 %
  • Transpose< 1 %
  • DB Insert< 1 %
  • Parameter Optimization Loop Start< 1 %
  • Corpus Creator< 1 %
  • HTML Parser< 1 %

Popular Successors

Views

This node has no views

Workflows

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.