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

315 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
dazzles163641(None) 
dazzle1536851dazzle_
dazzled1735031dazzled
dazzler1634711dazzler
dazzlers1733231dazzlers
azoles154614612_azoles
bedazzles2042062bedazzles
dabbles124514772dabbles
daddles104213802daddles
daggles103611912daggles
dales66439742da__les
dalles74222062da_lles
dandles94218532dandles
dangles93618422dangles
dapples1238992dapples
darkles124011932darkles
dartles84014132dartles
dawdles12379162dawdles
dazes155024142da_z_es
diazoles1836322diazoles
dizzies16279752dizzies
drizzles17295292drizzles
fizzles18339062fizzles
frazzles19284812frazzles
guzzles16328042guzzles
jazzes21347882jazz_es
mizzles17329492mizzles
muzzles17299682muzzles
nozzles15276302nozzles
nuzzles15298122nuzzles
pizzles17329272pizzles
puzzles17318972puzzles
razzes144910062razz_es
sizzles15349632sizzles
zizzles14307092zizzles
abeles84719393_abeles
ables75935543_a_bles
addles84216603_addles
adzes155913803_adz_es
aisles64721143_aisles
ales47067103_a__les
ambles105121853_ambles
amoles84122193_amoles
aneles64626293_aneles
angles74426703_angles
ankles104818383_ankles
anoles64827423_anoles
apples104315763_apples
argles75218483_argles
arles56735743_a_rles
axles125219473_a_xles
azalea1537003_azalea
azaleas1636993_azaleas
azides165113803_azides
azines155517073_azines
azole145118033_azole_
azotes154312223_azotes
azures15510183_azures
babbles104416323babbles
baffles153710683baffles
baizes174315053baiz_es
bales76250083ba__les
bangles103617413bangles
battles94517683battles
baubles113611863baubles
bedazzle1942143bedazzle_
bedazzled2142083bedazzled
bizzes163910843bizz_es
buzzes165011173buzz_es
cables104527553ca_bles
cackles153717203cackles
cajoles163712103cajoles
candles104422343candles
cantles94721413cantles
carles85435083ca_rles
castles94917733castles
caudles103912813caudles
caules85927253ca_ules
cozzes164510893cozz_es
dabble114515193dabble_
dabbled133712073dabbled
dabbler124012153dabbler
dabblers13379363dabblers
daces85030683da__ces
dacites101114593dacites
daddies103414943daddies
daddle94214283daddle_
daddled113810743daddled
dadoes85616533da_does
daggle93711903daggle_
daggled11329463daggled
dagoes85714603da_goes
dahls95012283da_hl_s
dailies84219263dailies
dairies84217733dairies
daises74318983da_ises
daisies84217093daisies
dale55643983da__le_
dallies84023193dallies
dals57145123da__l_s
damages11511273damages
dames85435853da__mes
damozels20133163damozels
damsels10126703damsels
dances95120653da_nces
dandies94121443dandies
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandlers103912053dandlers
dangle84119303dangle_
dangled104013153dangled
dangler96912813dangler
danglers103610593danglers
daphnes13327683daphnes
dapple1138853dapple_
dappled1336393dappled
darbies104216983darbies
dares66146703da__res
darioles9710693darioles
darkies124015753darkies
darkle113813943darkle_
darkled13378713darkled
darnels83710433darnels
dartle73714833dartle_
dartled9409853dartled
dashes106124983da_shes
dassies84418663dassies
dateless9259963dateless
dates65639153da__tes
datives11310073datives
daubes94913703da_ubes
dauties83315763dauties
davies105020513da_vies
dawdle11399503dawdle_
dawdled13376723dawdled
dawdler12356793dawdler
dawdlers13375673dawdlers
dawties113312703dawties
dayflies1534463dayflies
daze147327233da_z_e_
dazed165919363da_z_ed
dazzling1834363dazzling
deciles104417713deciles
deckles143312803deckles
defiles114016843defiles
deles65139253d__eles
dholes104914793d_holes
diazines1838703diazines
diazole1736793diazole_
dibbles124013333dibbles
diddles103915073diddles
dimples122813213dimples
dindles93817243dindles
dingles93818323dingles
dipoles101013753dipoles
ditzes163212423ditz_es
dizzied17236133dizzied
dizzier16317543dizzier
dizziest17266723dizziest
doles67843753d__oles
dongles93212873dongles
donzels1735393donzels
doodles93614163doodles
doozies173812723doozies
dottles83912283dottles
doubles103113353doubles
dozes155226303d_oz_es
drabbles13308523drabbles
draggles1145963draggles
drizzle16285913drizzle_
drizzled18284573drizzled
duffles14308913duffles
eagles73819163ea_gles
fables114921673fa_bles
failles102914123failles
farles96025783fa_rles
fazes175527213fa_z_es
fezzes174910403fezz_es
fizzes174512553fizz_es
fizzle17369713fizzle_
fizzled19357273fizzled
foozles19329543foozles
frazzle18305223frazzle_
frazzled20303993frazzled
frizzles19297283frizzles
fuzzes175412253fuzz_es
gabbles124415413gabbles
gables94222333ga_bles
gaggles103512593gaggles
gales65442483ga__les
gambles124016203gambles
garbles104016923garbles
gargles94214893gargles
gauzes164710633gauz_es
gazelles18266563gazelles
gazes155425913ga_z_es
grizzles17286193grizzles
guzzle15297913guzzle_
guzzled17326263guzzled
guzzler16286563guzzler
guzzlers17274863guzzlers
hackles162917063hackles
haggles123312483haggles
hales85449843ha__les
handles114020653handles
hantles104117513hantles
haoles94919803ha_oles
hassles103411693hassles
hazels185710083hazel_s
hazes174928323ha_z_es
hazzans18215783hazzans
jacales16310323jacales
jangles154015683jangles
jazzbos2442033jazzbos
jazzed22416293jazz_ed
jazzer21376503jazz_er
jazzers22324763jazzers
jazzier2233883jazzier
jazziest2333813jazziest
jazzmen2442503jazzmen
kales95730983ka__les
kayles134712003ka_yles
ladles74619543la_dles
lazes145129573la_z_es
lazies154418783la_zies
lazulis1634903lazulis
lezzes14387833lezz_es
lezzies1536203lezzies
mackles154415753mackles
macles107023223ma_cles
macules114015133macules
mailes84329113ma_iles
maizes175115733maiz_es
males75049793ma__les
mangles104021463mangles
mantles94820703mantles
maples104819423ma_ples
marbles114516653marbles
mazes165632173ma_z_es
mizzle16279993mizzle_
mizzled18327633mizzled
muzzle16319393muzzle_
muzzled18267753muzzled
muzzler17257943muzzler
muzzlers18245203muzzlers
nozzle14236633nozzle_
nuzzle14298083nuzzle_
nuzzled16276393nuzzled
nuzzler15296493nuzzler
nuzzlers16244753nuzzlers
outdazzles1951713outdazzles
paddles113515633paddles
padles95221113pa_dles
pales75753803pa__les
papules112411573papules
parles86334393pa_rles
paroles95025883paroles
pazazzes1752343pazazzes
pizzle16279493pizzle_
pozoles1839063pozoles
puzzle16318603puzzle_
puzzled18286653puzzled
puzzler17276963puzzler
puzzlers18295143puzzlers
rabbles113517973rabbles
raddles93615703raddles
raffles133611843raffles
raggles93813283raggles
rales54947493ra__les
rambles113118313rambles
rankles113114543rankles
rassles73513923rassles
rattles73217303rattles
razees154314763ra_zees
razes145032703ra_z_es
razzed15478283razz_ed
sables85026693sa_bles
saddles95415743saddles
sales56055593sa__les
samples112815453samples
sizzle14309613sizzle_
sizzled16367883sizzled
sizzler15266863sizzler
sizzlers16274753sizzlers
sozzled16265183sozzled
spatzles1935303spatzles
spazzes1735263spazz_es
swizzles1953783swizzles
tables84524883ta_bles
tackles133816523tackles
tailles72516463tailles
tales55451373ta__les
tamales93216143tamales
tangles83920043tangles
tattles73616283tattles
tazzas1436273tazz_as
tazze1339573tazz_e_
teazles16308913teazles
tizzies15287893tizzies
touzles16359223touzles
vales85434263va__les
wabbles144013993wabbles
waddles124314843waddles
waffles16329983waffles
waggles123812003waggles
wales86142833wa__les
wambles143714023wambles
wangles113416933wangles
warbles123215563warbles
warsles103413643warsles
wattles103814073wattles
wizzes175110773wizz_es
zizzle13247313zizzle_
zizzled15315853zizzled

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273158.97014941.7
3Display Results3153150.1102863.6
 (SQL Overall)1786913159.23619347.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.