TANIMOTO() scalar function

The TANIMOTO scalar function quantifies the degree of similarity between two sets of data in a specified table or view.

Syntax

tanimoto_[coefficient | distance]
  ( <column-name>,
    {
      (<select-statement>) |
      [<item-list>]
    }
  )

Argument	Description	Required
`tanimoto_coefficient`
`tanimoto_distance`
`<column-name>`	Name of column named in SELECT statement the function is a part of	Optional
`<select-statement>`	Nested SQL statement to obtain values
`<item-list>`	comma separated list of items found in the table named in the surrounding SELECT statement.	Yes

The function is used in a SELECT statement and requires:

The Jaccard index and Tanimoto similarity are widely used for assessing the similarity between sets of elements.

Returns	Description
`0`	No common elements found in results
`1`	Identical sets found in results

Create table:

CREATE TABLE tanimoto_test (_id id, stuff stringset);

Insert values:

INSERT INTO tanimoto_test VALUES
(1, ['cookies', 'milk']),
(2, ['cup', 'plate']);

SELECT *, tanimoto_coefficient (stuff, [milk, chocolate, cookies, cup])
  AS
    distance
  FROM
    fbtest
  ORDER BY distance;