Fuzzy search is taking too long

[lukasmueller]

As a temporary workaround, remove requirement for curator role to deactivate fuzzy search

[dwaring87]

I don't know how the fuzzy search is implemented in breedbase, but there are ways of doing an edit distance query directly in postgres: https://medium.com/@simeon.emanuilov/levenshtein-distance-in-postgresql-a-practical-guide-ef8262f595ae

To enable the function: CREATE EXTENSION fuzzystrmatch;

Then, you can query the database to find matches:

SELECT * FROM stock WHERE levenshtein(uniquename, 'SEARCH TERM') <= 3

[lukasmueller]

Oh that would be great Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: David Waring ***@***.***> Sent: Thursday, January 30, 2025 11:30:33 AM To: solgenomics/sgn ***@***.***> Cc: Lukas A. Mueller ***@***.***>; Assign ***@***.***> Subject: Re: [solgenomics/sgn] Fuzzy search is taking too long (Issue #5282) I don't know how the fuzzy search is implemented in breedbase, but there are ways of doing an edit distance query directly in postgres: ***@***.***/levenshtein-distance-in-postgresql-a-practical-guide-ef8262f595ae To enable the function: CREATE EXTENSION fuzzystrmatch; Then, you can query the database to find matches: SELECT * FROM stock WHERE levenshtein(uniquename, 'SEARCH TERM') <= 3 — Reply to this email directly, view it on GitHub<#5282 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAAV7F4IXOV6FD3Y3D5CLUD2NJHSTAVCNFSM6AAAAABV3MHKFOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMRUHE3TQMRZHA>. You are receiving this because you were assigned.Message ID: ***@***.***>

[lukasmueller]

Replace the fuzzy search in the accession upload with this method; also add a fuzzy search to the list validation