Yes, I have implemented Fuzzy-Search-xsOData before. I used CDS-Files to create the table and added the Fuzzy-Search Functionality like this:
namespace users.i320500.oDataFuzzySearch; @Schema: 'I320500' context searchDemoModel { @Search.searchable: true define view V_COMPANIES as select from COMPANIES as COMPANY { @EnterpriseSearch.key : true COMPANY.ID, @Search.defaultSearchElement: true @Search.ranking: #HIGH @Search.fuzzinessThreshold : 0.8 COMPANY.COMPANY_NAME }; };
Create an xsodata-file. (does not need to contain anything special, just as desired)
You can use this url to search using Fuzzy:
service.xsodata/Companies/?$format=json&search=SAP
Add a comment