Using 9.0.2 Sql Search, searching for "tent" brings up a product like 54 can cooler with following in description, along with other weird results. Searching for the same on their Gold site with Sql Search didn't do it.

Perfect soft cooler to bring what you need to any event
Great for a BBQ, the beach, sports events, gatherings, and more
Keeps the ice up to 3 days at temperatures up to 90F
Zippered design helps keep contents cool
Holds up to 54 standard cans
Front pocket can easily store a phone, wallet, keys, etc
Collapsible for space-saving and compact when not in use
Expands up to 15" x 15" x 9"
Adjustable shoulder strap makes it easy to take on the go

Nothing in sku, name, search keywords with "tent" in it.

Why? Maybe because of "contents"?

The search options when it comes to MSSQL are quite weak in Ablecommerce, at least compared to other platforms. I am starting to rely more on the additional search keywords under the additional settings of products to better refine my results.

We have identified our top 50 products, and using Google search and some backend SEO tools, we can determine what search parameters people are using to search for products. We are making sure that the search parameters are included in the additional search keyword setting.

It's amazing to us that people still use the term "walkie-talkie" when referring to, professional two-way radios that can cost over 1K each.

I hope this helps