Developer Discussions

[comecoze79]

Hi,

May I know if we can configure the Search Panel in GMSC? My users prefer fuzzy searching compared to the SQL searching hence is there any solution for this?

[jan.neumann · Accepted solution]

I don't think it's easily possible to customize the search panel. However, there are ways to simulate approximate string matching directly on the database level. I've found a couple of articles on the topic (related to SQL Server), you might find them helpful:

• http://www.sqlservercentral.com/articles/Fuzzy/159192/
• https://www.red-gate.com/simple-talk/sql/t-sql-programming/fuzzy-searches-sql-server/
• http://www.harshabopuri.com/sql-server-fuzzy-search-levenshtein-algorithm (custom developed database function)

[comecoze79]

Understood. Thank you very much for your assistance Jan.

Regards.