SDU Tools: Extract trigrams from strings in T-SQL

added by DotNetKicks
8/24/2018 1:26:32 PM

1 Kicks, 1414 Views

Fellow MVP Paul White and others have discussed the indexing of small segments of strings, to make fast indexes that I think are somewhat like full-text indexes but potentially more efficient. Three character substrings are common, and are known as trigrams.