I have indexed the "Contenido" field in Full Text. Searching with CONTAINS/CONTAINSTABLE in Like mode yields no matches when using words that contain the text "ous" (house). If I remove the asterisks and I write 'house', the text is found.
USE [Esp Libros en Español]
GO
SELECT SQL_TABLE.*, FT.* FROM [Libro_Sanchez Aguilar, Agustin - Don Quijote] AS SQL_TABLE
INNER JOIN CONTAINSTABLE([Libro_Sanchez Aguilar, Agustin - Don Quijote],
[Contenido], '*ous*') AS FT ON FT.[KEY] = SQL_TABLE.Id
WHERE (ESTADO IS NULL OR ESTADO = ' ') AND [Pagina] = 92
ORDER BY RANK, Pagina, Parrafo, Linea, Palabra
-----------------
SELECT SQL_TABLE.* FROM [Libro_Sanchez Aguilar, Agustin - Don Quijote] AS SQL_TABLE
WHERE (ESTADO IS NULL OR ESTADO = ' ') AND
CONTAINS ([Contenido], '*ous*') AND [Pagina] = 92 ORDER BY Pagina, Parrafo, Linea, Palabra