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

312 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
clough1253913(None) 
chough15699241chough
cloughs13517051cloughs
cough115819641c_ough
lough95118481_lough
plough12577561plough
slough10539231slough
bough115719312_bough
choughs16576622choughs
choush14549062choush
claught1335102claught
clog76123242clo_g_
cloggy1344872cloggy
clogs85519552clo_gs
cloth105817542clo_th
cloud86716422clou_d
clouds94612352clouds
cloudy12517802cloudy
clour76617282clou_r
clours85215092clours
clout75330462clou_t
clouts87017202clouts
colugo935862colugo
couch125320112c_ouch
coughs125514542c_oughs
couth106122492c_outh
crouch133910202crouch
dough105217382_dough
enough1045752enough
laugh94414372_laugh
loughs105014772_loughs
ploughs13526102ploughs
rough97819432_rough
slouch11438522slouch
sloughs11497562sloughs
sloughy14535802sloughy
sough95320462_sough
though139410772though
tough97321982_tough
trough108512022trough
abought1346143abought
almug8429303almug_
almugs9396423almugs
along65419493along_
aloud65018073alou_d
although1542593although
avouch1434833avouch
blog75723823blo_g_
blogs85319233blo_gs
blotch13197143blotch
blouse84714723blouse
blousy11459123blousy
blush105115313bl_ush
borough1344513borough
boughs125414373_boughs
bought125115633_bought
brought13308683brought
brugh115414293_brugh
capouch1644413capouch
caught124911683c_aught
chouse116017563chouse
chug105914113c_hug_
chugs115511943c_hugs
clach124617823cl_ach
clag75924573cl_ag_
clags85621123cl_ags
clang86019313clang_
clangs95113613clangs
clash106219033cl_ash
claucht1445583claucht
claughts1443383claughts
clause84311503clause
clench133910053clench
clergy1234993clergy
clinch133910353clinch
cling86424673cling_
clings95716213clings
clingy12659063clingy
cloaca1037263cloaca
cloak115214013clo_ak
cloaks124411263cloaks
cloche134312373cloche
clock134917983clo_ck
clocks144916233clocks
clod76124613clo__d
cloddy13405233cloddy
clods85320863clo_ds
clogged12528653clogged
clogger11438803clogger
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
closer84918203closer
closes85425593closes
closet85226603closet
closure9278483closure
clot66542423clo__t
clothe114712993clothe
cloths115512483cloths
clots75627643clo_ts
clotty11208263clotty
cloture9238453cloture
clouded11348833clouded
cloured103111543cloured
clouted104212163clouted
clouter93511693clouter
clove105619443clo_ve
cloven114211513cloven
clover114617123clover
cloves114918823cloves
clown105214733clo_wn
clowns114810113clowns
cloy96623833clo__y
cloyed125111563cloyed
cloys104916943clo_ys
cloze165517543clo_ze
clozes174915563clozes
club85819473cl_u_b
clubs95415103cl_ubs
cluck134914893cl_uck
clue65324533cl_u_e
clued84917683cl_ued
clues74623033cl_ues
clump115517453cl_ump
clung86013603cl_ung
clunk114215083cl_unk
clutch13367753clutch
coach125919453c_oach
cog69552903c_o_g_
cogs77340033c_o_gs
coign85013913c_oign
colog86619933colog_
cologs96517353cologs
colour85915093colou_r
colours95913443colours
colugos1035693colugos
column1038103column
colure8314163colure
conch124620073c_onch
conga85419873c_onga
conge85227593c_onge
congo85623133c_ongo
cooch124916833c_ooch
coolth1139513coolth
corgi8316083c_orgi
cosh96127623c_o_sh
coude85022633c_oude
cougar958783c_ougar
coughed143310903c_oughed
cougher133711733c_ougher
could86517713c_ould
count74932053c_ount
coup86729793c_ou_p
coupe96023483c_oupe
coups95522473c_oups
court75532773c_ourt
couths115715413c_ouths
crotch133410083crotch
croup95616783crou_p
croupe105114433croupe
croups104312553croups
croupy13458733croupy
crouse84619363crouse
croute84617273croute
crush106815993c_rush
curagh1236553curagh
doughs115912933_doughs
dought114915513_dought
doughy14499843_doughy
drought12258873drought
drouth104410103drouth
eclogue1044503eclogue
eloign7456983eloign
enoughs1144623enoughs
faugh125712963_faugh
flog85523893flo_g_
flogs95919963flo_gs
flong95815683flong_
flongs105010493flongs
flour84916453flou_r
flours94414053flours
floury12449573floury
flout86226203flou_t
flouts94315273flouts
flush115116073fl_ush
fought135112393_fought
furlough1542103furlough
glogg837353glo_gg
gloggs935033gloggs
glout65925813glou_t
glouts74414713glouts
glug66118013gl_ug_
glugs75214283gl_ugs
gouge78220063_gouge
grouch12318473grouch
haugh125114053_haugh
heugh125410923_heugh
hiccough1951343hiccough
kiaugh1442813kiaugh
klong105310403klong_
klongs11436603klongs
kluge104910453kl_uge
laigh95515923_laigh
laughs10489023_laughs
loach105116363_loach
loath84918603_loath
loch95527133_lo_ch
lodge76520083_lodge
log46252683_lo_g_
loge56837193_lo_ge
loggy105714193_loggy
logo57931763_lo_go
logs57343113_lo_gs
logy87025783_lo_gy
long56933343_long_
longe66626463_longe
longs65527063_longs
lotah85315853_lotah
loth76132133_lo_th
louche115212663_louche
loud55228043_lou_d
louie55023513_louie
louis57322323_louis
louma76213633_louma
lounge75211213_lounge
loungy10476833_loungy
loup66028433_lou_p
loupe75319513_loupe
loups75319623_loups
lour45430683_lou_r
lours55125293_lours
loury85716753_loury
louse56131013_louse
lousy84617083_lousy
lout45952143_lou_t
louts56330273_louts
lug46138063_l_ug_
luge55531643_l_uge
lugs55233523_l_ugs
lush75327693_l_ush
mouch124715803_mouch
mouth105420293_mouth
nought104713963_nought
ology94113113olo_gy
ouch95724633__ouch
ought95221533__ought
ouph95618373__ouph
ploughed15204303ploughed
plougher14214463plougher
plug74915993pl_ug_
plugs85213493pl_ugs
plush105614713pl_ush
pouch124617083_pouch
pugh106619233__pugh
rouge65423443_rouge
roughs105416213_roughs
roughy137010853_roughy
routh86423073_routh
saugh95318403_saugh
scouth115011153scouth
scrouge1036353scrouge
shaugh13287433shaugh
sheugh13295883sheugh
sleigh10258203sleigh
sleuth937233sleuth
slog56728273slo_g_
slogs64521843slo_gs
slosh84514483slo_sh
sloth85019453slo_th
slouchy15454843slouchy
sloughed13305583sloughed
slug55124643sl_ug_
slugs64618563sl_ugs
slush85316573sl_ush
soughs105115623_soughs
sought106315053_sought
south85223573_south
sugh86423443__sugh
teugh95511613_teugh
thought14639133thought
through141647513through
touch106519393_touch
toughs105414983_toughs
toughy135911073_toughy
troughs11698683troughs
ugh76520683___ugh
unrough11105233unrough
vouch134611903_vouch
vugh117115723__vugh
waugh125411683_waugh
wrought14276923wrought
yogh116616143_yo_gh
youth115315043_youth

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.1261418182.5
2DLD Change Limit1127163125.48320557.4
3Display Results3123120.0933354.8
 (SQL Overall)1786913125.70231338.3
 
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.