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

Popular Successors

  • Excel Writer (XLS)8 %
  • Column Splitter4 %
  • Top k Selector4 %
  • Excel Writer4 %
  • Loop End3 %
  • Loop End2 %
  • Column Comparator2 %
  • String Manipulation2 %
  • String Distances2 %
  • Similarity Search2 %
  • k-Means2 %
  • Concatenate2 %
  • Row Splitter2 %
  • Rule-based Row Filter2 %
  • Column Expressions2 %
  • Table View2 %
  • String Similarity2 %
  • TF-IDF Similarity2 %
  • CSV Writer1 %
  • Group Loop Start1 %
  • Recursive Loop End1 %
  • Column Resorter1 %
  • Duplicate Row Filter1 %
  • Column Filter1 %
  • Row Filter1 %
  • Row Filter (Labs)1 %
  • GroupBy1 %
  • Joiner1 %
  • Joiner1 %
  • Missing Value1 %
  • Rank1 %
  • Column Rename1 %
  • Numeric Row Splitter1 %
  • Sorter1 %
  • Rule Engine1 %
  • Rule-based Row Splitter1 %
  • Math Formula1 %
  • Concatenate (Optional in)1 %
  • Double To Int1 %
  • Normalizer1 %
  • Document Data Extractor1 %
  • RowID< 1 %
  • Matrix Distance< 1 %
  • Java Snippet (simple)< 1 %
  • Table Column to Variable< 1 %
  • Feature Selection Loop Start (1:1)< 1 %
  • Scorer< 1 %
  • Distance Matrix Pair Extractor< 1 %
  • Cell Splitter< 1 %
  • String Manipulation (Variable)< 1 %
  • Extract Table Spec< 1 %
  • Excel Writer (XLS)< 1 %
  • String Matcher< 1 %
  • Google Address Geocoder< 1 %
  • Web Searcher< 1 %
  • Fingerprint Similarity< 1 %
  • Similarity Viewer< 1 %
  • Split Collection Column< 1 %
  • Read Images< 1 %
  • Database Writer< 1 %
  • Loop End (Column Append)< 1 %
  • Chunk Loop Start< 1 %
  • Hierarchical Clustering< 1 %
  • Hierarchical Clustering (DistMatrix)< 1 %
  • MDS (DistMatrix)< 1 %
  • MDS Projection (DistMatrix)< 1 %
  • Random Forest Predictor< 1 %
  • Auto-Binner< 1 %
  • Case Converter< 1 %
  • Column Combiner< 1 %
  • Category To Number (Apply)< 1 %
  • String To Number< 1 %
  • Column Aggregator< 1 %
  • Column Appender< 1 %
  • Lag Column< 1 %
  • Constant Value Column< 1 %
  • Cross Joiner< 1 %
  • Filter Apply< 1 %
  • Nominal Value Row Filter< 1 %
  • Reference Row Filter< 1 %
  • Table Manipulator< 1 %
  • Partitioning< 1 %
  • Pivoting< 1 %
  • Value Counter< 1 %
  • Histogram< 1 %
  • Histogram< 1 %
  • Histogram (JavaScript)< 1 %
  • Math Formula (Multi Column)< 1 %
  • GroupBy Bar Chart (JFreeChart)< 1 %
  • Histogram Chart (JFreeChart)< 1 %
  • JPython Script 2:1< 1 %
  • XLS Writer (deprecated)< 1 %
  • XLS Writer< 1 %
  • Bag of Words Creator< 1 %
  • Strings To Document< 1 %
  • Document Viewer< 1 %
  • Tag Cloud< 1 %
  • Line Plot (JavaScript)< 1 %
  • Scatter Plot< 1 %
  • Tag Cloud< 1 %
  • JSON Transformer< 1 %
  • Node Neighbor Extractor< 1 %
  • Moving Aggregation< 1 %
  • Information Gain Calculator< 1 %
  • Corpus Creator< 1 %
  • N-Gram Extractor< 1 %
  • URL Extractor< 1 %
  • HTML Parser< 1 %
  • Ranking Services< 1 %

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.