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

174 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
dazzlers173323(None) 
dazzler1634711dazzler_
dazzles1636411dazzle_s
dabblers13379362dabblers
dandlers103912052dandlers
danglers103610592danglers
dawdlers13375672dawdlers
dazzle1536852dazzle__
dazzled1735032dazzle_d
guzzlers17274862guzzlers
jazzers22324762jazz_ers
muzzlers18245202muzzlers
nuzzlers16244752nuzzlers
puzzlers18295142puzzlers
sizzlers16274752sizzlers
amblers115213563_amblers
anglers84014823_anglers
antlers74014743_antlers
ashlers10319583_ashlers
azaleas1636993_azaleas
azoles154614613_azole_s
babblers113510353babblers
bafflers16356593bafflers
bailers94221353ba_ilers
balers85626933ba__lers
ballers94421013ba_llers
battlers104110973battlers
bawlers124412733ba_wlers
bedazzles2042063bedazzle_s
buzzers17347173buzz_ers
cablers114416713ca_blers
cacklers163710703cacklers
cajolers17267133cajolers
callers94221963ca_llers
candlers114214103candlers
carolers103314173carolers
cavilers1348113cavilers
dabbers123813213da_bbers
dabbler124012153dabbler_
dabbles124514773dabble_s
dabsters1137053dabsters
dackers143417043da_ckers
daddles104213803daddle_s
daggers103714913da_ggers
daggles103611913daggle_s
daikers124010313da_ikers
dales66439743da__le_s
dalles74222063da_lle_s
dalliers93610613dalliers
damagers1237063damagers
dammers123214273da_mmers
damners104112113da_mners
dampers123915693da_mpers
dancers103413093da_ncers
danders93921183da_nders
dandler94414273dandler_
dandles94218533dandle_s
dangers94818213da_ngers
dangler96912813dangler_
dangles93618423dangle_s
dapples1238993dapple_s
darers75921873da__rers
darkles124011933darkle_s
darners83815773da_rners
darters84017603da_rters
dartles84014133dartle_s
dashers115016863da_shers
dateless9259963dateless
daters74827373da__ters
daubers104610423da_ubers
daunders10278473daunders
daunters9329853daunters
dawdler12356793dawdler_
dawdles12379163dawdle_s
dazes155024143da_z_e_s
dazzling1834363dazzling
dealers84118613d_ealers
defilers12439473defilers
dialers83614303d_ialers
diallers957773diallers
diazoles1836323diazole_s
dibblers13377583dibblers
diddlers11359153diddlers
dizzier16317543dizzier_
dizzies16279753dizzie_s
doodlers10338843doodlers
doozers17419293dooz_ers
doublers11288503doublers
dozers164815423d_oz_ers
drawlers12307313drawlers
drillers9429723drillers
drizzles17295293drizzle_s
duelers83412053d_uelers
duellers9268223duellers
dwellers12356083dwellers
fablers124812613fa_blers
fallers103917993fa_llers
fizzers18357003fizz_ers
fizzles18339063fizzle_s
foozlers20346073foozlers
frazzles19284813frazzle_s
frizzlers20293673frizzlers
gabblers134110083gabblers
gamblers13369733gamblers
gaolers83511563ga_olers
garblers113810283garblers
garglers10418263garglers
gazers164516303ga_z_ers
grizzlers18253233grizzlers
guzzler16286563guzzler_
guzzles16328043guzzle_s
hacklers173710303hacklers
hagglers13326623hagglers
hailers104017263ha_ilers
halers94926913ha__lers
handlers124014143handlers
haulers104012443ha_ulers
hazers184615953ha_z_ers
jailers144114043ja_ilers
janglers16319373janglers
jazzer21376503jazz_er_
jazzes21347883jazz_e_s
jazzier2233883jazzier_
labelers10249413labelers
ladlers84613573la_dlers
landlers94312833landlers
mailers94420333ma_ilers
mamzers20409163mamz_ers
manglers113311903manglers
marblers12319233marblers
maulers94213303ma_ulers
mazers173917093ma_z_ers
mizzles17329493mizzle_s
muzzler17257943muzzler_
muzzles17299683muzzle_s
nailers73215893na_ilers
nozzles15276303nozzle_s
nuzzler15296493nuzzler_
nuzzles15298123nuzzle_s
paddlers12329153paddlers
panzers184012013panz_ers
patzers184210573patz_ers
pizzles17329273pizzle_s
puzzler17276963puzzler_
puzzles17318973puzzle_s
rabblers123810853rabblers
rafflers14317363rafflers
railers74420663ra_ilers
ramblers124010373ramblers
rattlers83510293rattlers
ravelers113310863ravelers
razers154919613ra_z_ers
razzes144910073razz_e_s
rozzers1535633rozz_ers
saddlers10289753saddlers
sailers73822323sa_ilers
samplers12299403samplers
sizzler15266863sizzler_
sizzles15349633sizzle_s
swizzlers2052193swizzlers
tacklers143010773tacklers
tailers73720183ta_ilers
talers64628143ta__lers
tanglers92911973tanglers
tattlers8369693tattlers
wabblers15398993wabblers
waddlers13298333waddlers
wafflers17306323wafflers
wailers103916803wa_ilers
walers94824463wa__lers
wanglers123310033wanglers
warblers13319103warblers
warslers11328073warslers
zizzles14307093zizzle_s

Search took 7 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.453394461.4
2DLD Change Limit1461621746.36022981.4
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.87625987.6
 
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.