<p>Using Lucene, one can retrieve the terms contained within in an index, i.e. the unique, stemmed words, excluding stop-words, that documents in the index contain. This is useful for generating autocomplete suggestions amongst other things. Is something similar possible with MS SQL Server full text indices?</p>

You can use the new system view in SQL Server 2008 to get you the terms and count of occurrences, is this what you want?
```
```
sys.dm_fts_index_keywords_by_document
( 
    DB_ID('database_name'),     
    OBJECT_ID('table_name') 
)
```
```
You need to supply the
```
db_id
```
and
```
object_id
```
of the fulltext table. This is the MSDN link for this:
sys.dm_fts_index_keywords_by_document
.