Worked on the basecamp/fizzy repository to address a critical issue in multi-term SQLite FTS5 search functionality. Focused on backend development using Ruby on Rails and Ruby, the work involved correcting the join logic within search queries to eliminate ambiguous column errors that previously resulted in 500 server errors. This solution not only stabilized complex search behavior but also improved the reliability of user-facing search features. To ensure ongoing correctness, a regression test was added to enforce that all search terms must match in multi-term scenarios, enhancing test coverage and contributing to the overall health and maintainability of the codebase.