Speeding up LIKE '%text%' queries

Recently I did some experminets with n-grams indexes used to speed-up full text search in a plain SQL database. The results are really promising.