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

345 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
dappling143684(None) 
dapping133714791dapp_ing
applying1634652_applying
capping143819672capp_ing
dabbling14227972dabbling
daddling12258232daddling
daggling12237062daggling
damping133414002damp_ing
dandling112511732dandling
dangling112611232dangling
darkling1437482darkling
darling93418362da_rling
dartling1039562dartling
dawdling14236372dawdling
dazzling1834362dazzling
dimpling14199022dimpling
dipping134014832dipp_ing
dumpling14217892dumpling
dupping133711042dupp_ing
gapping134214782gapp_ing
grappling1544992grappling
happing153817232happ_ing
hoppling16206762hoppling
lapping124117022lapp_ing
mapping143413992mapp_ing
napping123514182napp_ing
poppling12227322poppling
rappeling1435962rappeling
rapping123619102rapp_ing
rippling13197572rippling
sampling13510642sampling
sapling103217862sa_pling
sapping123519312sapp_ing
suppling1359042suppling
tapping123317132tapp_ing
tippling13196702tippling
toppling13197352toppling
wapping153514602wapp_ing
yapping153412612yapp_ing
zapping213211472zapp_ing
adapting1236643adapting
addling10229833_addling
adopting1237453adopting
ailing74331013_a_iling
ambling121411793_ambling
amping114317573_amp_ing
aneling82719503_aneling
angling92816043_angling
ankling122912063_ankling
aping87327233_a_p_ing
appalling1444923_appalling
appealing1446493_appealing
applied1247483_applied
applier1137903_applier
applies11311213_applies
appoint11612483_appoint
apposing1337403_apposing
argling92812733_argling
babbling12228693babbling
baffling1756053baffling
bailing103723523ba_iling
baling94829693ba__ling
balling104424763ba_lling
bantling112612003bantling
battling113110493battling
bawling133813863ba_wling
bopping143512033bopp_ing
cabling124017553ca_bling
cackling172610943cackling
cageling12310843cageling
cajoling18318423cajoling
calling103826773ca_lling
camping143118973camp_ing
canaling112016413canaling
candling122313873candling
capelin11510973capelin_
capelins12311133capelins
capering132414963capering
caplin103216303ca_plin_
caplins113515993ca_plins
cappings15369493capp_ings
capsuling1444533capsuling
carling103727063ca_rling
caroling113317003caroling
carping123521083carp_ing
castling11311233castling
catling104819793ca_tling
caviling14310113caviling
chapping183710723chapp_ing
clapping153810603clapp_ing
copping143918593copp_ing
coupling13310783coupling
crapping153911453crapp_ing
crippling1644093crippling
cupeling1338863cupeling
cupping144312383cupp_ing
dabbing133511233da_bbing
dabblings15193883dabblings
dadoing1038523da_doing
daffing15369733da_ffing
dairying1336353dairying
dallying13368493dallying
damaging1337383damaging
damming133812743da_mming
damning114211633da_mning
dampening1535463dampening
dampings14377523damp_ings
dancing113611563da_ncing
danging103716093da_nging
dapple1138853dappl__e
dappled1336393dappl_ed
dapples1238993dappl_es
daring84928683da__ring
darking134217343da_rking
darklings1533983darklings
darlings103710383da_rlings
darning93817333da_rning
darting94020663da_rting
dashing125917893da_shing
dateline9810353dateline
dating85326483da__ting
daubing11358623da_ubing
daunting103310403daunting
dauphin1344383dauphin_
dauphine1444493dauphine
dauphins1444523dauphins
dauting93814763da_uting
davening13258873davening
dawing114819823da__wing
dawning124111013da_wning
dawting123610673da_wting
daylong1233973da_ylong
dayspring1642613dayspring
dazing175516513da__zing
dealing94323233d_ealing
decupling1534973decupling
defiling132812463defiling
depeopling1642643depeopling
deponing121211213deponing
deposing12129773deposing
deputing12238793deputing
develing133212733develing
deviling1311812853deviling
dialing94318173d_ialing
dialling10310783dialling
diapering1339033diapering
dibbling14247333dibbling
diddling12228743diddling
dindling112411163dindling
dirling93316073d_irling
doling84923133d__oling
dolling93817373d_olling
doodling11218403doodling
doping103919463d_op_ing
doubling1238153doubling
doweling13279763doweling
drabbling1544553drabbling
draggling1354613draggling
draping114213353drap_ing
drawling13318673drawling
drilling103311983drilling
dripping14278033dripping
drolling103510763drolling
drooling102610423drooling
dropping14309283dropping
duckling16247703duckling
dueling93614543d_ueling
duelling103410733duelling
dulling93418273d_ulling
dumping133712913dump_ing
dumplings15213853dumplings
duping104113633d_up_ing
dwelling13368413dwelling
eagling91113603ea_gling
eanling81416673ea_nling
empaling1338363empaling
exampling2143553exampling
fabling133413623fa_bling
failing113521333fa_iling
falling113621583fa_lling
fatling113815683fa_tling
flapping16298153flapp_ing
fopping153511133fopp_ing
frapping16348103frapp_ing
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
galling93921963ga_lling
gambling14218963gambling
gangling112411403gangling
gaoling93314653ga_oling
gaping105618923ga_p_ing
garbling12249453garbling
gargling11239203gargling
gasping113714363gasp_ing
gaveling133410163gaveling
gawping14418463gawp_ing
gipping133813123gipp_ing
grapplings1642323grapplings
gypping16305843gypp_ing
hackling183310163hackling
haggling14227273haggling
hailing113820693ha_iling
haling104229783ha__ling
handling132312713handling
happening1735593happening
harping134118383harp_ing
hasping134414903hasp_ing
hassling1236803hassling
hauling113714433ha_uling
hipping153915103hipp_ing
hirpling1467223hirpling
hopping154115273hopp_ing
impaling1338253impaling
jailing153415843ja_iling
jangling17249623jangling
japing165013573ja_p_ing
jauping17307193jaup_ing
kepping16268593kepp_ing
kipping163311873kipp_ing
knapping17314973knapp_ing
labeling11311643labeling
ladling92813393la_dling
lalling83519623la_lling
lamping123116003lamp_ing
lappering14258843lappering
lapsing103511163la_psing
lapwing13308263la_pwing
lipping123016073lipp_ing
lopping123815223lopp_ing
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
mangling122312623mangling
mantling112012613mantling
mappings15296413mapp_ings
marbling13179883marbling
marling103322763ma_rling
mauling103315683ma_uling
mopping143411473mopp_ing
nailing83419963na_iling
napalming1443173napalming
nipping123412873nipp_ing
paddling13218643paddling
paling93530133__paling
palling104024483pa_lling
palping124112873palp_ing
paneling111013623paneling
papering132213313papering
parling103823763pa_rling
paroling113316213paroling
peopling1338353peopling
pepping113511623pepp_ing
piling95025593__piling
pipping113414743pipp_ing
poling93526503__poling
popping113715413popp_ing
puling93621403__puling
pupping114412503pupp_ing
purpling1368543purpling
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
railing83325643ra_iling
ralphing1435413ralphing
rambling131810773rambling
ramping123316873ramp_ing
rankling132610113rankling
raping94829853ra_p_ing
rappelling1544363rappelling
rappini11347573rapp_ini
rasping104316253rasp_ing
rassling939013rassling
rattling92510873rattling
raveling123414373raveling
reapplying1843023reapplying
repping123314983repp_ing
rimpling13219663rimpling
ripping123315743ripp_ing
rumpling13178763rumpling
saddling11239593saddling
sailing83927373sa_iling
samplings1435553samplings
sandling102214413sandling
saplings11269803sa_plings
sipping123117433sipp_ing
slapping133510833slapp_ing
snapping13349653snapp_ing
sopping123917203sopp_ing
spalling113213463spalling
sparling112714533sparling
spiling102919703_spiling
stapling112813153stapling
stippling1475173stippling
stoppling1474963stoppling
supping123814533supp_ing
supplying1774043supplying
swapping16348673swapp_ing
tabling103216033ta_bling
tackling153211123tackling
tailing82923103ta_iling
tamping122815813tamp_ing
tangling101712543tangling
tapeline10310363tapeline
tapering112112503tapering
taping94222393ta_p_ing
tappings13267713tapp_ings
tattling9259473tattling
tipping122814973tipp_ing
topping123514623topp_ing
trampling1436973trampling
trapping132911393trapp_ing
tripling112712553tripling
tupping123411663tupp_ing
unpiling1139753unpiling
upfling1337093_upfling
uppiling1335853uppiling
upping114013703_upp_ing
vailing113817943va_iling
vamping152810233vamp_ing
vaporing1437653vaporing
wabbling16207743wabbling
waddling14237933waddling
waffling1845423waffling
waggling14197063waggling
wailing113620903wa_iling
waling104525303wa__ling
walling113520973wa_lling
wambling16198443wambling
wangling132310993wangling
warbling14198943warbling
warping133715183warp_ing
warsling12198593warsling
wattling12258783wattling
wauling112713113wa_uling
wawling143810963wa_wling
whapping19317113whapp_ing
wimpling16207483wimpling
wrapping16297623wrapp_ing
yauping13357243yaup_ing
yawling14369183ya_wling
yawping16357333yawp_ing
yipping152710683yipp_ing
zipping212910573zipp_ing

Search took 8 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.406440125.6
2DLD Change Limit1461623456.87321266.1
3Display Results3453450.1432412.6
 (SQL Overall)1786913457.42224075.9
 
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.