The following query returns a result of zero. The 2-grams 'ab' and 'bc' match, but they are not within 1 position of each other.
SELECT NGRAM ('abc','yyabc',2, 1);
The following query returns a result of zero. The 2-grams 'ab' and 'bc' match, but they are not within 1 position of each other.
SELECT NGRAM ('abc','yyabc',2, 1);