create fulltext catalog Test;
go

create table dbo.t
(
 id int constraint PK_t primary key,
 s nvarchar(1000)
);
go

insert dbo.t values (1, N'Много огромных flying тарелок');
go

create fulltext index on dbo.t
(s language neutral)
key index PK_t
on Test
with (change_tracking = auto);
go

while fulltextcatalogproperty('Test', 'PopulateStatus') <> 0
 waitfor delay '00:00:01';
go

select * from dbo.t where contains(s, N'formsof(inflectional, fly)', language 1033);
select * from dbo.t where contains(s, N'formsof(inflectional, тарелка)', language 1049);
select * from dbo.t where contains(*, N'formsof(inflectional, огромный)', language 1049);
go

drop table dbo.t;
drop fulltext catalog Test;
go