Skip to main content

How to configure stopwords against string variables

The Stopwords function strips specified words from a string variable before it's compared, so values that mean the same thing but differ in wording — like legal suffixes — can still match.
​

Set up the function

  1. In the rule builder, select Function, then choose Stopwords for the string variable you want to evaluate.

  2. Select the variable to screen — the field whose value will have stopwords stripped before comparison.

  3. Add your stopwords:

    • Type individual words directly, or

    • Select one or more existing lists. Every item in a selected list is treated as a stopword.

  4. Choose an operator, for example similar to for fuzzy matching or = for an exact match. The operators available depend on whether you're comparing against words or a list.

  5. Choose the value to screen against — words or a list, depending on the operator you selected.

  6. Set the fuzziness threshold to control how closely the stripped values need to match.
    ​

Example

Configure Limited Liability Company and LLC as stopwords, and "Apple Limited Liability Company" and "Apple LLC" are compared as "Apple" against "Apple." They'll now match at a lower fuzziness percentage than before, since the differing legal suffixes are stripped out before the comparison runs.

Did this answer your question?