ClickHouse has been completely re-engineered to offer a faster, leaner, and fully integrated full-text search (FTS) feature, optimized for its columnar database design. By transitioning from a Bloom-filter-based approach to a native inverted index, ClickHouse now supports high-performance search capabilities directly within the database. The new design includes advanced data structures like Finite State Transducers (FSTs) for space-efficient dictionaries and Roaring bitmaps for fast, compressed posting lists. These innovations enable efficient querying without reading the text column, significantly improving speed and reducing resource usage. Recent updates have introduced a more intuitive API, new tokenizer options, improved compression techniques, and enhanced compatibility with ClickHouse Cloud. Additionally, the system now supports fast row-level searches using the index alone, resulting in considerable performance gains, especially for frequent search terms. The revamped full-text search is available for a private preview, inviting early adopters to test and provide feedback.