SingleStore has integrated Full-Text Search (FTS) into its product, a highly requested feature that allows customers to build real-time applications with improved performance and relevance. FTS uses an inverted index data structure, stemming capabilities, and relevance scoring to provide faster search results compared to regular database queries. The integration with SingleStore is straightforward, leveraging the open-source Lucene technology, allowing users to specify columns for full-text indexing when creating a table. With FTS, users can mix structured and unstructured query types in their SQL queries, making it easy to take advantage of the feature without requiring extensive knowledge of full-text searching. The management of the full-text capability is transparent to the user, with automatic sharding, failover, rebalance, node addition and removal, backup/restore, etc., handled by the system. Users can utilize FTS for various use cases, such as autocomplete functionality, mixing structured and unstructured query types, and retrieving relevance scores in their queries.