Fuzzy search for a large text data cell- How does it work?

steven.h.liu.1 · 2025-03-25T06:05:07.269Z

Hi- I am wondering how does Fuzzy search work when I have a large block of text in a data cell,

Specifically, I am storing an API call’s raw text into a database with the hope that Fuzzy search can identify key words within that text block to surface the right entry, but it doesn’t seem to be working.

Is the sensitivity based on the text field itself (e.g., the search input matches 70% of the total text block) or does it look for specific key words in a text block?

Update

I tried with a smaller set of text (see below). I don’t think Fuzzy search goes beyond the first ~50 characters of the text as its search scope (bolded below).

** Ramen🍜 & Boba🧋**
** Traemos los sabores auténticos de** tierras asiáticas,
con el fin de llevarte a Asia a través de nuestros platillos🌏

Is this an user error or a known bug? @ZeroqodeSupport

Update 2 Solved it. I needed to adjust the “distance” setting to expand the search range

ZeroqodeSupport · 2025-03-25T12:04:41.153Z

Hi @steven.h.liu.1,
Thank you for reaching out.

steven.h.liu.1:

Update 2 Solved it. I needed to adjust the “distance” setting to expand the search range

Glad you found a solution.

Please feel free to reach us again when you need some help or assistance. It will be a pleasure to cooperate.

By the way, if you like our plugin you can rate it by going to the Plugins tab in Bubble editor. Find the plugin by name and give it as many stars as it deserves. We would appreciate it a lot!

Take care!

Support Team
Browse all Zeroqode Plugins for Bubble

steven.h.liu.1 · 2025-03-25T16:41:06.711Z

Thanks!

While I have you here, do you know a work-around solution to include a tag system (option set) into the search criteria? For example, creating another “text” field copying the option set, etc.

ZeroqodeSupport · 2025-03-26T14:25:46.568Z

Hi @steven.h.liu.1,

Thank you for your reply.

Unfortunately, we don’t have a similar example on the plugin demo page, but here are some general suggestion.

Create a Text Field for Storing Tags:
You can create a text field in your database that copies the selected option set value into it (e.g., when users choose tags or categories, it will be saved as a text value). This will allow the search system to query against it.
Use the Plugin’s Search Features:
Once the text field is populated with the selected tags or options from the option set, you can use the ZQ Fuzzy Search or Autocomplete functionality to search within this text field, and filter results based on the tags.

You can add up to 5 fields from your DataBase to search through. See the screen below.

image1673×871 62.7 KB

Hope this helps.
Regards,

Support Team
Browse all Zeroqode Plugins for Bubble