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

253 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
dazzler163471(None) 
dazzle1536851dazzle_
dazzled1735031dazzled
dazzlers1733231dazzlers
dazzles1636411dazzles
dabbler124012152dabbler
dandler94414272dandler
dangler96912812dangler
dawdler12356792dawdler
dizzier16317542dizzier
guzzler16286562guzzler
jazzer21376502jazz_er
jazzier2233882jazzier
muzzler17257942muzzler
nuzzler15296492nuzzler
puzzler17276962puzzler
sizzler15266862sizzler
abler75624313_a_bler
ambler104916453_ambler
ampler104313303_ampler
angler74017863_angler
antler64615553_antler
ashler9459973_ashler
azalea1537003_azalea
azole145118033_azole_
azoles154614613_azoles
babbler104012823babbler
baffler15418113baffler
bailer85425253ba_iler
baler75635273ba__ler
baller83825203ba_ller
battler94113383battler
bawler114315053ba_wler
bedazzle1942143bedazzle_
bedazzled2142083bedazzled
bedazzles2042063bedazzles
buzzer16379113buzz_er
cabler104519173ca_bler
cackler153812573cackler
cajoler16398393cajoler
caller85125483ca_ller
candler103516593candler
caroler93816753caroler
caviler1249063caviler
dabber114816963da_bber
dabble114515193dabble_
dabbled133712073dabbled
dabblers13379363dabblers
dabbles124514773dabbles
dabster1036703dabster
dacker134920753da_cker
daddle94214283daddle_
daddled113810743daddled
daddles104213803daddles
daffier1457833daffier
dafter104813343da_fter
dagger95017303da_gger
daggle93711903daggle_
daggled11329463daggled
daggles103611913daggles
daiker115113033da_iker
dale55643983da__le_
dales66439743da__les
dalles74222063da_lles
dallier84215373dallier
damager1157973damager
dammer114317933da_mmer
damner95213433da_mner
damper114117753da_mper
dancer94817613da_ncer
dander811222993da_nder
dandier93714573dandier
dandle84218093dandle_
dandled103313543dandled
dandlers103912053dandlers
dandles94218533dandles
danger83722823da_nger
dangle84119303dangle_
dangled104013153dangled
danglers103610593danglers
dangles93618423dangles
danglier1056753danglier
danker114319663da_nker
dapper114016633da_pper
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
darer65230793da__rer
darker114718693da_rker
darkle113813943darkle_
darkled13378723darkled
darkles124011933darkles
darklier1335013darklier
darner74017303da_rner
darter75320363da_rter
dartle73714833dartle_
dartled9409853dartled
dartles84014133dartles
dasher104318983da_sher
dashier114311183dashier
dater65332313da__ter
dauber94112013da_uber
daubier1037103daubier
daunder9348893daunder
daunter83811753daunter
dawdle11399503dawdle_
dawdled13376723dawdled
dawdlers13375673dawdlers
dawdles12379163dawdles
daze147327233da_z_e_
dazed165919363da_z_ed
dazes155024143da_z_es
dazzling1834363dazzling
dealer74122143d_ealer
defiler113911883defiler
dialer74315433d_ialer
dialler848813dialler
diazole1736793diazole_
diazoles1836323diazoles
dibbler124510283dibbler
diddler103511513diddler
ditzier17307963ditzier
dizzied17236133dizzied
dizzies16279753dizzies
doodler93310153doodler
doozer163910463dooz_er
doubler103110083doubler
dozer158419273d_oz_er
dozier163611633d_ozier
drawler11338593drawler
driller84311883driller
drizzle16285913drizzle_
drizzled18284573drizzled
drizzles17295293drizzles
drizzlier18122303drizzlier
droller84110283droller
dueler74213683d_ueler
dueller8329833dueller
duller74017703d_uller
dweller11297273dweller
fabler116115813fa_bler
faller94621233fa_ller
fizzer17369383fizz_er
fizzier18326713fizzier
fizzle17369713fizzle_
fizzled19357273fizzled
fizzles18339063fizzles
foozler19397593foozler
frazzle18305223frazzle_
frazzled20303993frazzled
frazzles19284813frazzles
frizzler19345843frizzler
fuzzier18256523fuzzier
gabbler124013303gabbler
gambler123612683gambler
gaoler73913573ga_oler
garbler104012563garbler
gargler93710263gargler
gauzier1735633gauzier
gazer155720073ga_z_er
grizzler17335033grizzler
guzzle15297913guzzle_
guzzled17326263guzzled
guzzlers17274863guzzlers
guzzles16328043guzzles
hackler163512353hackler
haggler12328933haggler
hailer94720343ha_iler
haler85033523ha__ler
handler113516163handler
hauler95015123ha_uler
hazer174820233ha_z_er
hazier184712403ha_zier
jailer134316683ja_iler
jangler153811833jangler
jazzed22416293jazz_ed
jazzers22324763jazz_ers
jazzes21347883jazz_es
jazzmen2442503jazzmen
labeler92310183labeler
ladler74314933la_dler
landler84113203landler
lazier154214613la_zier
mailer84724183ma_iler
mamzer19459833mamz_er
mangler103215643mangler
marbler113511673marbler
mauler84416713ma_uler
mazer165722423ma_z_er
mazier175013063ma_zier
mizzle16279993mizzle_
mizzled18327633mizzled
mizzles17329493mizzles
muzzier17326553muzzier
muzzle16319393muzzle_
muzzled18267753muzzled
muzzlers18245203muzzlers
muzzles17299683muzzles
nailer64119363na_iler
nozzle14236633nozzle_
nozzles15276303nozzles
nuzzle14298083nuzzle_
nuzzled16276393nuzzled
nuzzlers16244753nuzzlers
nuzzles15298123nuzzles
paddler113711553paddler
paler75436933pa__ler
panzer174213233panz_er
patzer173111643patz_er
pizzle16279493pizzle_
pizzles17329273pizzles
puzzle16318603puzzle_
puzzled18286653puzzled
puzzlers18295143puzzlers
puzzles17318973puzzles
rabbler113514093rabbler
raffler13339223raffler
railer64524933ra_iler
rambler113313263rambler
rattler74012743rattler
raveler104212463raveler
razer144824273ra_z_er
razzed15478283razz_ed
razzes144910073razz_es
rozzer1437353rozz_er
saddler93811963saddler
sailer63526103sa_iler
sampler113212013sampler
sizzle14309613sizzle_
sizzled16367883sizzled
sizzlers16274753sizzlers
sizzles15349633sizzles
snazzier1642483snazzier
sozzled16265183sozzled
swizzler1963223swizzler
tackler134013323tackler
tailer63823733ta_iler
taler56034863ta__ler
taller63721963ta_ller
tangler83515073tangler
tattler73112213tattler
tazze1339573tazz_e_
wabbler143511923wabbler
waddler124010793waddler
waffler16377783waffler
wailer93720323wa_iler
waler84229263wa__ler
wangler113312653wangler
warbler123211463warbler
warsler10289893warsler
zizzle13247313zizzle_
zizzled15315853zizzled
zizzles14307093zizzles

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272536.82619634.8
3Display Results2532530.0803162.5
 (SQL Overall)1786912537.06225303.2
 
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.