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

222 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
dazzling183436(None) 
bedazzling2241932bedazzling
dabbling14227972dabbling
daddling12258232daddling
daggling12237062daggling
dandling112511732dandling
dangling112611232dangling
dappling1436842dappling
darkling1437482darkling
darling93418362da_rling
dartling1039562dartling
dawdling14236372dawdling
dazing175516512da_z_ing
dazzlingly2351982dazzlingly
dizzying2133022dizzying
drizzling1943022drizzling
fizzling20264992fizzling
frazzling2143152frazzling
guzzling18225062guzzling
jazzing2333882jazz_ing
mizzling19255442mizzling
muzzling19245732muzzling
nuzzling17224772nuzzling
puzzling19225392puzzling
razzing1636322razz_ing
sizzling17225782sizzling
zizzling16233922zizzling
addling10229833_addling
adzing174110013_adz_ing
ailing74331013_a_iling
ambling121411793_ambling
aneling82719503_aneling
angling92816043_angling
ankling122912063_ankling
argling92812733_argling
babbling12228693babbling
baffling1756053baffling
bailing103723523ba_iling
baling94829693ba__ling
balling104424763ba_lling
bantling112612003bantling
battling113110493battling
bawling133813863ba_wling
buzzing18186543buzz_ing
cabling124017553ca_bling
cackling172610943cackling
cageling12310843cageling
cajoling18318423cajoling
calling103826773ca_lling
canaling112016413canaling
candling122313873candling
carling103727063ca_rling
caroling113317003caroling
castling11311233castling
catling104819793ca_tling
caviling14310113caviling
dabbing133511233da_bbing
dabblings15193883dabblings
dadoing1038523da_doing
daffing15369733da_ffing
dairying1336353dairying
dallying13368493dallying
damaging1337383damaging
damming133812743da_mming
damning114211633da_mning
damping133414003da_mping
dancing113611563da_ncing
danging103716093da_nging
dapping133714793da_pping
daring84928683da__ring
darking134217343da_rking
darklings1533983darklings
darlings103710383da_rlings
darning93817333da_rning
darting94020663da_rting
dashing125917893da_shing
dateline9810353dateline
dating85326483da__ting
daubing11358623da_ubing
daunting103310403daunting
dauting93814763da_uting
davening13258873davening
dawing114819823da__wing
dawning124111013da_wning
dawting123610673da_wting
daylong1233973da_ylong
dazzle1536853dazzl__e
dazzled1735033dazzl_ed
dazzler1634713dazzl_er
dazzlers1733233dazzlers
dazzles1636413dazzl_es
dealing94323233d_ealing
defiling132812463defiling
develing133212733develing
deviling1311812853deviling
dialing94318173d_ialing
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
dimpling14199023dimpling
dindling112411163dindling
dirling93316073d_irling
dizening19177143dizening
doling84923133d__oling
dolling93817373d_olling
doodling11218403doodling
doubling1238153doubling
doweling13279763doweling
dozening19236183dozening
dozing174214193d_oz_ing
drabbling1544553drabbling
draggling1354613draggling
drawling13318673drawling
drilling103311983drilling
drolling103510763drolling
drooling102610423drooling
duckling16247703duckling
dueling93614543d_ueling
duelling103410733duelling
dulling93418273d_ulling
dumpling14217893dumpling
dwelling13368413dwelling
eagling91113603ea_gling
eanling81416673ea_nling
fabling133413623fa_bling
failing113521333fa_iling
falling113621583fa_lling
fatling113815683fa_tling
fazing194418643fa_z_ing
fizzing19276403fizz_ing
foozling21275723foozling
frizzling2153113frizzling
fuzzing19336183fuzz_ing
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
galling93921963ga_lling
gambling14218963gambling
gangling112411403gangling
gaoling93314653ga_oling
garbling12249453garbling
gargling11239203gargling
gaveling133410163gaveling
gazing174717173ga_z_ing
grizzling1942843grizzling
hackling183310163hackling
haggling14227273haggling
hailing113820693ha_iling
haling104229783ha__ling
handling132312713handling
hassling1236803hassling
hauling113714433ha_uling
hazing194218553ha_z_ing
huzzaing2042433huzzaing
jailing153415843ja_iling
jangling17249623jangling
jazzlike2742683jazzlike
labeling11311643labeling
ladling92813393la_dling
lalling83519623la_lling
lazing164821473la_z_ing
lazying2046673la_zying
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
mangling122312623mangling
mantling112012613mantling
marbling13179883marbling
marling103322763ma_rling
mauling103315683ma_uling
mazing184418973ma_z_ing
nailing83419963na_iling
outdazzling2141733outdazzling
paddling13218643paddling
paling93530133pa__ling
palling104024483pa_lling
paneling111013623paneling
parling103823763pa_rling
paroling113316213paroling
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
railing83325643ra_iling
rambling131810773rambling
rankling132610113rankling
rassling939013rassling
rattling92510873rattling
raveling123414373raveling
razeeing1834363razeeing
razing164524543ra_z_ing
razoring1836443razoring
saddling11239593saddling
sailing83927373sa_iling
sampling13510643sampling
sandling102214413sandling
sapling103217863sa_pling
swizzling2142493swizzling
tabling103216033ta_bling
tackling153211123tackling
tailing82923103ta_iling
tangling101712543tangling
tattling9259473tattling
teazeling1934543teazeling
teazling1856573teazling
touzling1835503touzling
vailing113817943va_iling
wabbling16207743wabbling
waddling14237933waddling
waffling1845423waffling
waggling14197063waggling
wailing113620903wa_iling
waling104525303wa__ling
walling113520973wa_lling
wambling16198443wambling
wangling132310993wangling
warbling14198943warbling
warsling12198593warsling
wattling12258783wattling
wauling112713113wa_uling
wawling143810963wa_wling
yawling14369183ya_wling

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.420425454.8
2DLD Change Limit1461622227.45319611.2
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.95322468.4
 
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.