# Fuzzy Search

**URL:** <https://community.glideapps.com/t/fuzzy-search/70547>\
**Category:** Ask for Help\
**Created:** [February 6, 2024, 6:56am UTC](https://community.glideapps.com/t/fuzzy-search/70547 "2024-02-06T06:56:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [February 6, 2024, 6:56am UTC](https://community.glideapps.com/t/fuzzy-search/70547/1 "2024-02-06T06:56:39Z")

</div>

Hi, I am wondering if it is possible to do a fuzzy search in Glide, I have a drawing register with the names of each drawing in a project and I also have a uploaded drawing table. Once uploaded, each drawing will be assigned to an item on the the register. In order to speed up the linking process, I would like to search the drawing register list based on the file name of the uploaded PDF. The closest match is then suggested as the one to be linked and the user either verifies it is or picks another one.

Often the file name won’t be an exact match to the register item, hence the fuzzy search.

Cheers

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 7, 2024, 12:02am UTC](https://community.glideapps.com/t/fuzzy-search/70547/2 "2024-02-07T00:02:22Z")

</div>

My thinking is you can add a user-specific column and point the text entry there, then decide to either use a JavaScript approach to match that search term against your file names to return a percentage match, or maybe turn both the file name and the search term into a bunch of keywords using AI, and then try to match the arrays together. Whatever matches the most keywords win.

---

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [February 7, 2024, 8:12am UTC](https://community.glideapps.com/t/fuzzy-search/70547/3 "2024-02-07T08:12:08Z")

</div>

Thank you for the suggestion. I was thinking about the Javascript approach but are you able to help me with the input?

Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 8, 2024, 1:02am UTC](https://community.glideapps.com/t/fuzzy-search/70547/4 "2024-02-08T01:02:47Z")

</div>

Sorry, it was just a thought, I have no ready-made snippet. You can try searching Stackoverflow or use ChatGPT to craft a snippet with a prompt like “calculate percentage of match between 2 strings/sentences”.

---

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [February 9, 2024, 9:02am UTC](https://community.glideapps.com/t/fuzzy-search/70547/5 "2024-02-09T09:02:57Z")

</div>

Cool. Thank you
