Overview
Research and document the best approach for implementing fuzzy search in TaskPilot, considering performance, user experience, and scalability.
Research Questions
- What's the maximum project count before in-memory search becomes slow?
- Can EF Core translate any fuzzy algorithms to SQL?
- What's the setup complexity for SQLite FTS5?
- How do other project management tools handle this?