TSQL - Text field into table with one row per word

SQL Server 2012...

select * from sys.dm_fts_parser ( '"this is a-long text file file"', 1033, 0, 0 );

For more details, read
http://technet.microsoft.com/en-us/library/cc280463.aspx