Trigram Wildcard String Search in SQL Server Paul White discusses the pros and cons of maintaining three-character substrings (trigrams) to speed up wildcard searches. Paul White ◆ September 8, 2017 18
Follow-up #1 on leading wildcard seeks Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches. Aaron Bertrand ◆ February 8, 2017 12
One way to get an index seek for a leading %wildcard In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server. Aaron Bertrand ◆ February 3, 2017 32