This should work for you.
Declare @text Nvarchar(500)='Here, is my text'
Declare @limit int=10
Declare @CuttText Nvarchar(500)
select @CuttText=Substring(@text,1,@limit)
Declare @Spaceindex int,@Reverse Nvarchar(100)
set @Reverse=Reverse(@CuttText)
select @Spaceindex=Charindex(' ',@Reverse)
select Reverse(Substring(@Reverse,@SpaceIndex+1,LEN(@CuttText)))