One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, I play around with a trigram-type implementation in SQL Server.