Troubleshooting Search Results for Health Products

The next thing to try is setting exhaustive_search: true

If that also doesn’t work, could you adapt this script with your schema and a few sample records to replicate this issue?

Result with exhaustive search:
{
"facet_counts": [],
"found": 6763,
"hits": [
{
"document": {
"amp_drug_tariff_id": "20072911000001103",
"category": "Silk vest small adult",
"colour": "White",
"drug_tariff_id": "20073011000001106",
"flavour": "",
"id": "20073011000001106",
"inactive": false,
"name": "Skinnies Silk vest short sleeve small adult White (Dermacea Ltd) 1 device",
"product_name": "Skinnies Silk vest short sleeve small adult",
"quantity": "1",
"size_weight": "",
"sub_pack_information": "",
"supplier": "Dermacea Ltd",
"tariffs": "Part IXa",
"unit_of_measure": "device"
},
"highlights": [
{
"field": "product_name",
"matched_tokens": [
"sleeve",
"small"
],
"snippet": "Skinnies Silk vest short <mark>sleeve</mark> <mark>small</mark> adult"
}
],
"text_match": 144681433930137601
},
{
"document": {
"amp_drug_tariff_id": "15037711000001107",
"category": "Elasticated viscose stockinette vest small adult",
"colour": "Beige",
"drug_tariff_id": "15039111000001100",
"flavour": "",
"id": "15039111000001100",
"inactive": false,
"name": "Skinnies Viscose stockinette vest long sleeve small adult Beige (Dermacea Ltd) 1 device",
"product_name": "Skinnies Viscose stockinette vest long sleeve small adult",
"quantity": "1",
"size_weight": "",
"sub_pack_information": "",
"supplier": "Dermacea Ltd",
"tariffs": "Part IXa",
"unit_of_measure": "device"
},
"highlights": [
{
"field": "product_name",
"matched_tokens": [
"sleeve",
"small"
],
"snippet": "Skinnies Viscose stockinette vest long <mark>sleeve</mark> <mark>small</mark> adult"
}
],
"text_match": 144681433930137601
},
{
"document": {
"amp_drug_tariff_id": "23589211000001108",
"category": "Tubing and accessories",
"colour": "",
"drug_tariff_id": "23589311000001100",
"flavour": "",
"id": "23589311000001100",
"inactive": false,
"name": "Prosys leg bag sleeve small PLS3881 24cm-40cm (CliniSupplies Ltd) 4 device",
"product_name": "Prosys leg bag sleeve small",
"quantity": "4",
"size_weight": "24cm-40cm",
"sub_pack_information": "",
"supplier": "CliniSupplies Ltd",
"tariffs": "Part IXb",
"unit_of_measure": "device"
},
"highlights": [
{
"field": "product_name",
"matched_tokens": [
"Prosys",
"sleeve",
"small"
],
"snippet": "<mark>Prosys</mark> leg bag <mark>sleeve</mark> <mark>small</mark>"
}
],
"text_match": 144681433930137601
}
],
"out_of": 165394,
"page": 1,
"request_params": {
"collection_name": "drug_tariff",
"per_page": 3,
"q": "prosys geoff sleeve small"
},
"search_cutoff": false,
"search_time_ms": 15
}

So the result we want first was the third one. Given more tokens matched, I'm surprised it had the same text_match score...

Actually, without exhaustive search the result is similar - lots of results with the same text_match score - but the result we want first has the most matched_tokens so I would expect it to be the highest text_match score

In your case the word to drop exists in the middle of the search query…

Need to think through how to solve this without a performance impact… Let me get back to you on this in a few days

This would still help to build a good test case: https://typesense-community.slack.com/archives/C01P749MET0/p1685723917693439?thread_ts=1685723650.719949&cid=C01P749MET0