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 “libelling” 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.

138 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
libelling123688(None) 
labelling1238091labelling
libeling1139871libe_ling
belling103825072__belling
labeling11311652labe_ling
levelling13206982levelling
libellant1145702libellant
rebelling122111162rebelling
zibelline2044302zibelline
balling104424763__balling
bellings113811153__bellings
bellying14359073__bellying
belting104119133__belting
belying133612443__belying
bevelling15227453bevelling
bielding12237473bi_elding
billing103823853__billing
bolling103820883__bolling
bowelling1566493bowelling
bulling104324793__bulling
caballing1436883caballing
celling103921263__celling
chiselling1644683chiselling
corbelling1546713corbelling
cupelling1436283cupelling
dialling10310783di_alling
dibbling14247333dib_bling
dispelling1447613dispelling
dowelling1466253dowelling
drivelling1543983drivelling
duelling103410733_duelling
dwelling13368413_dwelling
excelling1935643excelling
expelling1936133expelling
felling113321133__felling
fielding13206863fi_elding
filling113520803fi__lling
fuelling123410153_fuelling
gavelling14286883gavelling
gelling93219763__gelling
gilling93520383gi__lling
gimballing16202923gimballing
gruelling1155603gruelling
helling114623223__helling
hilling113821773hi__lling
hireling121210993hire_ling
hirselling1444833hirselling
hovelling1636163hovelling
impelling1436913impelling
jelling153516613__jelling
jewelling2034833jewelling
kibbling17225703kib_bling
killing123118723ki__lling
knelling13319023_knelling
kvelling16146513_kvelling
lalling83519633l__alling
laurelling1144473laurelling
leveling122910433leve_ling
libelant1048563libe_lant
libelist10310823libe_list
libellants1243603libellants
libelled11317213libell_ed
libellee10227733libell_ee
libellees11274983libellees
libeller10297433libell_er
libellers11236033libellers
libellous1143643libellous
liberating1349253liberating
libertine1147433libertine
librating1239053librating
licencing1443853licencing
licensing1244753licensing
lifeline11167663life_line
lifelong1242633life_long
likening13246893like_ning
lilting83515383li__lting
limbering1488793limbe_ring
livelong1243403live_long
livening12248153live_ning
livering122012383live_ring
lobeline1039963lobe_line
lolling83415783l__olling
lowballing1642273lowballing
lulling83616803l__ulling
melling102822633__melling
milling103223683mi__lling
misbilling1545543misbilling
modelling1336883modelling
nibbling13256503nib_bling
nickelling1743643nickelling
nielloing1043893ni_elloing
nilling83619563ni__lling
panelling1239083panelling
pilling103722563pi__lling
pinballing1544013pinballing
quelling18259793_quelling
ravelling13269253ravelling
rebilling12228833rebilling
refelling132211313refelling
relabelling1442663relabelling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revelling132412553revelling
riesling939013ri_esling
rilling84023623ri__lling
rivalling1335963rivalling
rowelling1366993rowelling
selling83225833__selling
shelling123515213_shelling
sibling10814423sib__ling
sibylline1442893sibylline
sideling101012183side_ling
smelling113712733_smelling
snelling93913563_snelling
snivelling1444293snivelling
spelling113315233_spelling
swelling123212753_swelling
swivelling1743413swivelling
telling83321083__telling
tilling83522783ti__lling
tinselling1145523tinselling
towelling1366253towelling
unbelting1237663unbelting
unselling10810333unselling
upwelling1535233upwelling
vialling1237223vi_alling
vitellin11105403vitellin_
vitelline1285853vitelline
vitellins1285443vitellins
welling112920313__welling
wielding13286863wi_elding
willing113821613wi__lling
yelling113516703__yelling
yielding13205033yi_elding
yodelling1435193yodelling
zibeline1946363zibe_line
zibellines2143493zibellines

Search took 10 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411389.04616431.7
3Display Results1381380.0602300.0
 (SQL Overall)1786911389.52918752.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.