Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lieve” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lieve8631547(None) 
liege65314431liege
liever94611861liever
live76540991li_ve
nieve85613181nieve
sieve84918841sieve
slieve9359271slieve
alive85722512ali_ve
believe12519772believe
breve105317052breve
diene65720132diene
dive85634772di_ve
eve66331162__eve
five107629742fi_ve
give85829352gi_ve
grieve1047242grieve
hive106029672hi_ve
jive146123592ji_ve
keeve124512132keeve
laevo849362laevo
lave75642142l_ave
leave84723722leave
lee36068142l_e_e
leke85527402l_eke
lev66139422l_ev_
leva77020712l_eva
levee84023812l_evee
level84116552l_evel
lever85125162l_ever
levo76820062l_evo
levy106418502l_evy
liane54720662liane
lice66045062li_ce
lie38264522li__e
lied55838092lie_d
lieder74912322lieder
lief76036992lie_f
liefer9529572liefer
lieges74113442lieges
lien45339802lie_n
liens56525502liens
lier45942462lie_r
lierne638022lierne
liers55130402liers
lies46454192lie_s
lieu46534362lie_u
lieus56218482lieus
lievest1048342lievest
life75433732li_fe
like86040842li_ke
lime66244932li_me
line46965572li_ne
lipe66839732li_pe
lire47845292li_re
lisle53916722lisle
lite47054542li_te
lithe84922012lithe
litre55421462litre
lived95523722lived
liven85021732liven
liver85132962liver
lives86133192lives
livre85613252livre
love75234762l_ove
neve76224832_neve
niece74814502niece
nieves94311292nieves
olive84817152oli_ve
peeve104915252peeve
piece96717992piece
reeve84121322reeve
reive85522942reive
relieve105010692relieve
riever94811652riever
rive75537722ri_ve
siege66718442siege
sieved104611442sieved
sieves93216002sieves
sleeve93411592sleeve
slieves10378962slieves
thieve1235962thieve
vive105426622vi_ve
wive105931752wi_ve

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.313570897.8
2DLD Change Limit53800831.62333148.5
3Display Results83830.0165187.5
 (SQL Overall)178691831.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.