How to fuzzy query

[honghui0929]

Like sql:
select*from table where name like %tom%

[dfahlander]

db.table.filter(row => /tom/i.test(row.name))

The query cannot utilize an index (and would not on an SQL db either) - a full table scan will be performed. However, if you want like tom% (prefix search), indexes can be utilized on an ordinary SQL db, and in Dexie, that would be

db.table.where('name').startsWithIgnoreCase('tom')

Full Text Search indexes are another story and can be used to fuzzy search as well. Possible with dexie but not out of the box. Need to store search words in a multiEntry index. See samples on docs page for that.