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 “libelist” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
libelist1031082(None) 
libelists1146951libelists
biblist11310832bib_list
libelant1048562libelant
libeling1139872libeling
libels85112692libel_s_
liberalist1249062liberalist
likeliest1346122likeliest
liveliest1247092liveliest
ableist9311773_ableist
alienist8411993ali_enist
arbalist10313333arbalist
arbelest1049503arbelest
bemist105216963__bemist
bibelot1167343bibel_ot
bibelots1295133bibelots
biblists1236873bib_lists
cabalist12314503cabalist
delist74625053__delist
diabolist1256493diabolist
dialist8517763di_alist
diallist949553diallist
duelist8511413_duelist
fabulist1347673fabulist
fideist1139753fide_ist
fidelista1343203fidelista
finalist113014733finalist
firelit10310863fireli_t
globalist1256763globalist
idealist9310653_idealist
idylist1146653_idylist
kabalist14410083kabalist
kibeis12469803kibe_is_
labeling11311643labeling
labels84515683label_s_
legalist9512393legalist
legist71315253l__egist
libel74116103libel___
libelants1145303libelants
libeled10249413libel_ed
libelee92510983libel_ee
libelees10227213libelees
libeler9219003libel_er
libelers10238623libelers
libellant1145693libellant
libelled11317213libelled
libellee10227733libellee
libeller10297433libeller
libelling1236873libelling
libelous1047193libelous
liberalise1247593liberalise
liberalism1447043liberalism
liberalists1346403liberalists
libers84721443libe_rs_
librettist12123163librettist
liefest1038443li_efest
lievest1048343li_evest
lifeless11228143lifeless
lifelike15166223lifelike
lifeline11167663lifeline
likelier1235283likelier
likest104914383like__st
likewise1543263likewise
limberest1345513limberest
limeless10249663limeless
limelight1544243limelight
lineless82711943lineless
linelike12159003linelike
linguist948573linguist
literalist10411533literalist
littlest8309243littlest
littlish1145043littlish
livelier1136873livelier
livelily1444103livelily
liverish1447863liverish
livest95315733live__st
lobbyist1543533lobbyist
lobelia947213lobeli_a
lobelias1047203lobelias
lobeline1039963lobeline
localist101613963localist
loneliest949443loneliest
loveliest1246973loveliest
loyalist111511133loyalist
lutenist8610663lutenist
midlist10312513mi_dlist
modelist11310503modelist
niellist848353niellist
nihilist1147163nihilist
novelist1149453novelist
obelise9310173_obelise
obelisk1345193_obelisk
obelism1138203_obelism
panelist10414503panelist
pietist9414033pi_etist
relist64628413__relist
simplist12249683simplist
timeliest1147233timeliest
titlist7312923ti_tlist
tribalist1149953tribalist
vibist11610583vib__ist
violist10312143vi_olist
vitalist11313393vitalist
wifeliest1545883wifeliest
wiseliest1237723wiseliest
zibeline1946363zibeline

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621067.79618748.3
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.27821586.3
 
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.