Example with trigramm similarity function #django #python

trigramm_similarity_example.py

from django.contrib.postgres.search import TrigramSimilarity


def find_product_using_trigram_similarity(
    pricelist_product: str, min_similarity=0.3
) -> Optional[Product]:
    """Find the most similar product to the pricelist product
    using trigram similarity search.
    """
    return (
        Product.objects.annotate(
            similarity=TrigramSimilarity("name", pricelist_product)
        )
        .filter(similarity__gt=min_similarity)
        .order_by("-similarity")
        .first()
    )