Should SQL full text search match the value test2 when searching for test? if i have table data that is indexed using full text search in Microsoft SQL server 2005 that includes raw table data such as "test2" should a query using FTS find a match if the search string is "test"?
Yes you can use full text search in this case.

Select * from your_table WHERE CONTAINS(your_column, '"test*"' );


will find test2.

See section 

C. Using CONTAINS with prefix_term in msdn