drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: Fuzzy string matching functions
Open
db/mysql
db/postgres
enhancement
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
### Describe what you want
[Postgres - fuzzystrmatch](https://www.postgresql.org/docs/current/fuzzystrmatch.html)
[MySQL - soundex](https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_soundex)
Implement `levenshtein`, `daitch_mokotoff` and `soundex` for Postgres.
Implement `soundex` for MySQL.
Maybe added under `drizzle-orm/sql/expressions/conditions`.
`fuzzystrmatch` would need to be loaded via `create extension ...`, need a way to either handle missing or infer it.
note: `soundex` doesn't work well with multibyte encodings like utf-8, document as necessary.
Contributor guide
Assessment
This issue has not been assessed yet.