pg_similarity is very handy tool for text comparision and GCP has support for it, our application uses it heavely to compare string values and it's a mandatory requirement for us.