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

377 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
cloudy1251780(None) 
cloddy13405231cloddy
cloud86716421cloud_
clouds94612351clouds
aloud65018072aloud_
bloody124710172bloody
blousy11459122blousy
clod76124612clo_d_
clods85320862clo_ds
cloggy1344872cloggy
clotty11208262clotty
clouded11348832clouded
cloudily1444282cloudily
clough12539132clough
clour76617282clou_r
clours85215092clours
clout75330462clou_t
clouts87017202clouts
cloy96623832clo__y
coude85022632c_oude
croupy13458732croupy
crowdy15467172crowdy
floury12449572floury
loud55228042_loud_
loudly1037782_loudly
loury85716752_loury
lousy84617082_lousy
ploidy1237482ploidy
uncloudy1443012uncloudy
agouty10366913agouty
allude73910903allude
almondy13144483almondy
almud84012183almud_
almude9399933almude
almuds9378773almuds
becloud1246293becloud_
beclouds1345373beclouds
blocky17388353blocky
blond85618373blond_
blonde94813293blonde
blonds95213343blonds
blood85319523blood_
bloods94614843bloods
blooey115110793blooey
bloomy134510113bloomy
blotty11178343blotty
blouse84714723blouse
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
bluey104817053bl_uey
body107425673_bo_dy
boody115420403_boody
bousy104917843_bousy
broody124510083broody
caddy125414023c_addy
calory11312843calo_ry
candy115119823c_andy
chokey184811713chokey
choky175711223cho_ky
choosy14459103choosy
choppy18376293choppy
chord115917263chord_
chords125214633chords
chough15699243chough
chouse116017563chouse
choush14549063choush
clad76225823cl_ad_
clade85821013cl_ade
clads85722733cl_ads
clammy15356333clammy
clanky15469073clanky
clary105719613cl_ary
classy11379043classy
clause84311503clause
clay95927413cl__ay
clayey14407663clayey
clergy1234993clergy
cliffy17435243cliffy
clingy12659063clingy
cliquey21295693cliquey
cliquy20324713cliquy
cloaca1037263cloaca
cloak115214013clo_ak
cloaks124411263cloaks
cloche134312373cloche
clock134917983clo_ck
clocks144916233clocks
clog76123243clo__g
clogs85519553clo_gs
clomb115714703clo_mb
clomp115615703clo_mp
clomps125212233clomps
clon66232483clo__n
clonal8310913clonal
clone75728163clo_ne
cloned94518803cloned
cloner84418093cloner
clones84526563clones
clonic104914673clonic
clonk114417443clo_nk
clonks125013473clonks
clons75228133clo_ns
clonus85212413clonus
cloot76127053clo_ot
cloots85113693cloots
clop86929893clo__p
clops95924853clo_ps
cloque17288743cloque
cloques18268563cloques
close76425223clo_se
closed95317963closed
closely1237053closely
closer84918203closer
closes85425593closes
closet85226603closet
closure9278483closure
clot66542423clo__t
cloth105817543clo_th
clothe114712993clothe
cloths115512483cloths
clots75627643clo_ts
cloture9238453cloture
cloudier1135053cloudier
clouding12269493clouding
cloudlet1145503cloudlet
cloughs13517053cloughs
cloured103111543cloured
clouted104212163clouted
clouter93511693clouter
clove105619443clo_ve
cloven114211513cloven
clover114617123clover
clovery15407403clovery
cloves114918823cloves
clowder13367943clowder
clown105214733clo_wn
clowns114810113clowns
cloyed125111563cloyed
cloys104916943clo_ys
cloze165517543clo_ze
clozes174915563clozes
club85819473cl_u_b
clubby1534683clubby
clubs95415103cl_ubs
cluck134914893cl_uck
clue65324533cl_u_e
clued84917683cl_ued
clues74623033cl_ues
clump115517453cl_ump
clumpy15409573clumpy
clumsy13326193clumsy
clung86013603cl_ung
clunk114215083cl_unk
clunky15447893clunky
coaly105521593c_oaly
cobby145516413c_obby
cocky164215933c_ocky
cod69660123c_o_d_
coda77029343c_o_da
code77347733c_o_de
cods76848103c_o_ds
coed77140543c_oed_
coeds85920163c_oeds
coky137526823c_o_ky
colby124415063c_olby
cold77338773c_old_
coldly12459953coldly
colds85726973c_olds
coled85540763coled_
collude10337993collude
colly104926773c_olly
colony115417273colony
colour85915093colou_r
colours95913443colours
colugo935863colugo
column1038103column
colure8314163colure
coly96940533c_o_ly
comedy14378233comedy
comfy153710213c_omfy
commy144712643c_ommy
condo85322593c_ondo
coney105932883c_oney
conky145818743c_onky
cony96537833c_o_ny
cooed84534343cooed_
cooey105828223c_ooey
cookey155414333cookey
cooky145321363c_ooky
coolly114811393coolly
cooly105525423c_ooly
copay126516313c_opay
copy116229803c_o_py
corby125018533c_orby
cord76740923c_ord_
cords86030623c_ords
corky145221153c_orky
corny106023273c_orny
corody12149703corody
cory96941513c_o_ry
cosey106226713c_osey
cosy97232703c_o_sy
couch125320113c_ouch
cough115819643c_ough
could86517713c_ould
count74932053c_ount
county114313323c_ounty
coup86729793c_ou_p
coupe96023483c_oupe
coups95522473c_oups
court75532773c_ourt
couth106122493c_outh
covey136121783c_ovey
cowry135512483c_owry
cowy126427363c_o_wy
coy810557553c_o__y
coyly135614893c_oyly
cozey196718543c_ozey
cozy185823803c_o_zy
croaky15528483croaky
crony105918673cro_ny
crouch133910203crouch
croup95616783crou_p
croupe105114433croupe
croups104312553croups
crouse84619363crouse
croute84617273croute
crowd115815623crowd_
crowds124910763crowds
crud75219613c_rud_
cruddy1334193cruddy
crude86018573c_rude
cruds85815853c_ruds
cud67937453c__ud_
cuddy125111973c_uddy
cuds76730473c__uds
curdy115916523c_urdy
doody105517913_doody
dowdy136112543_dowdy
elude64517623el_ude
fleury12417353fleury
floaty124210943floaty
flocky18468423flocky
flood95215603flood_
floods104511653floods
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
flouncy1543673flouncy
flour84916453flou_r
flours94414053flours
flout86226203flou_t
flouts94315273flouts
fluky154512293fl_uky
fluty114415643fl_uty
frouzy21395283frouzy
gaudy106611463_gaudy
glady105413943gl_ady
globby1434683globby
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293glo_ry
glossy10549003glossy
glout65925813glou_t
glouts74414713glouts
gluey95715263gl_uey
goody105620393_goody
gouty95217363_gouty
grody103412063gro_dy
grouty104710983grouty
hoody124919723_hoody
howdy155711413_howdy
illude7327503illude
kludgy15294223kl_udgy
lady86527153_l_ady
lardy96119273_lardy
laud56527723_laud_
lauds65618483_lauds
leady95618603_leady
leud57223423_leud_
leuds66214813_leuds
lindy96918313_lindy
load56730603_load_
loads65323373_loads
loamy105913343_loamy
lobby125113923_lobby
lode56240113_lo_de
lofty115813303_lofty
loggy105714193_loggy
logy87025783_lo_gy
loid55531493_loid_
loids66220703_loids
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
loppy125911663_loppy
lord55032083_lord_
lordly1038753_lordly
lords64923503_lords
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
louden73711793_louden
louder74414603_louder
lough95118483_lough
louie55023513_louie
louis57322323_louis
louma76213633_louma
loungy10476833_loungy
loup66028433_lou_p
loupe75319513_loupe
loups75319623_loups
lour45430683_lou_r
lours55125293_lours
louse56131013_louse
lout45952143_lou_t
louts56330273_louts
lowly114113333_lowly
lude55331643_l_ude
luny77324133_l_uny
melody1237203melo_dy
moldy115014653_moldy
moody115017493_moody
mouldy12437413_mouldy
mousy106716943_mousy
noddy105411203_noddy
oldy85316843__oldy
ology94113113olo_gy
oud47439073__oud_
ouds56430103__ouds
plod76723273plo_d_
plods85719293plo_ds
plotty11208853plotty
plough12577563plough
ploy96123603plo__y
plumy124213233pl_umy
pouty107018813_pouty
proud84615483proud_
proudly1336333proudly
roupy106112713_roupy
rowdy125711533_rowdy
shoddy1434543shoddy
slobby1334803slobby
sloid64619713sloid_
sloids73712693sloids
slojd13378843slojd_
slojds14345473slojds
sloppy1395303sloppy
sloshy12366623sloshy
slouch11438523slouch
slouchy15454843slouchy
slough10539233slough
sloughy14535803sloughy
slowly1237153slowly
sloyd9409683sloyd_
sloyds10346293sloyds
sludgy11366253sl_udgy
snouty9419953snouty
soddy104210703_soddy
soupy106115403_soupy
stoury9529943stoury
study94411793_study
toady96814343_toady
toddy106812423_toddy
tody86327213_to_dy
trouty95211793trouty
uncloud1046433uncloud_
unclouds1144883unclouds
woody125116883_woody
wordy126916163_wordy
zloty17399793zlo_ty

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127163775.29621283.2
3Display Results3773770.1063556.6
 (SQL Overall)1786913775.79530835.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.