Example

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);