i'm trying to sort the trigram search result in postgres not only by the distance but prefix and suffix too. I know the trigram result put more weight on leading matches but sometime suffix matches showing closer distance.
is it possible to order by search_on NOT ILIKE keyword% in django?