Search database without fuzzy search?

Need help
1

Hello,

I’ve been digging into fuzzy-search and realised it may not be ideal in Bubble because it pulls the entire data source to the client before filtering, which burns a lot of WUs.

Use case
Users need to find items even if they type the title in Swedish or English. Each record therefore has two text fields: title_sv and title_en.

What I’ve read
The following posts were super helpful, but I’m still unsure how to handle bilingual searches neatly:

Naïve idea (probably not optimal)
Search on title_sv. If the repeating group returns 0 results, run the same query on title_en. it feels clunky and doubles the calls and im not even sure if its possible?

Question
Is there a smarter way to let users search in either language without blowing up WU usage?

Thanks in advance! :grinning_face_with_smiling_eyes:

2

Do a search for Items where title_sv contains X merged with Do a search for Items where title_en contains X

1 Like
3

Screenshot 2025-07-02 at 10.33.32
Screenshot 2025-07-02 at 10.33.32666×183 18 KB

Hi @georgecollier, thanks for the quick reply! Im not really sure what you mean, if you can guide me some more?

4

Use two searches in one expression, the results combined using :merged with operator.

1 Like
5

Im sorry im not following how to use two searches in one expression, even if i just try the following:

Screenshot 2025-07-02 at 10.37.26
Screenshot 2025-07-02 at 10.37.26665×145 15.6 KB

It returns nothing? even if i write it correct

Edit: I found the merge but still returns nothing?

Edit 2: i got it to work!! Big thanks!

6

@georgecollier is there a way to display a list of items for example if a search “Marketing” and a list now shows:

Marketing Manager1
Marketing Manager2

But not if the word is one long word but still contains the characters in it, for example:
Marketer

EDIT: I have “conatin keyword(s)” and not “contains” like you said… thank you :pray:

1 Like