how to find similar word with more similarities how to Find words with length less than or equal...

  declare @inp nvarchar(max),@data nvarchar(max)
  set @inp='You can dance, you can jive, having .... jove... jve, ...' 
  set @data = 'jeve'
  select @inp as results where @inp like '%' + @data +'%'


@inp not return any data, but i want show:

results 
=====
jive
jove
jve
I've never thought of SOUNDEX or DIFFERENCE as that useful, and they are certainly a bit old-fashioned these days.  However we can combine it with the full-text parser, and it does in fact answer this query.  Note the extra quotes in the search statement:

DECLARE @inp NVARCHAR(MAX), @data NVARCHAR(MAX)
SET @inp= '"You can dance, you can jive, having .... jove... jve, ..."' 
SET @data = 'jeve'

SELECT display_term, SOUNDEX(display_term) sdx
FROM sys.dm_fts_parser(@inp,0,0,0)
WHERE SOUNDEX(display_term) = SOUNDEX(@data)
 AND LEN(display_term) &lt;= LEN(@data)

SELECT display_term, SOUNDEX(display_term) sdx, DIFFERENCE(display_term,@data) diff
FROM sys.dm_fts_parser(@inp,0,0,0)


There is a fairly limited use case for these functions so if you have more complex examples then they probably won't extend.  Worth a mention though.