I learned about trigrams when working on a personal project and trying to figure out how to do full text searches on postgres. Good blog post about it : https:

I learned about trigrams when working on a personal project and trying to figure out how to do full text searches on postgres. Good blog post about it : https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/ https://about.gitlab.com/blog/2016/03/18/fast-search-using-p... The docs: https://www.postgresql.org/docs/current/pgtrgm.html https://www.postgresql.org/docs/current/pgtrgm.html