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

361 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
slough1053923(None) 
clough12539131clough
lough95118481_lough
plough12577561plough
slouch11438521slouch
sloughs11497561sloughs
sloughy14535801sloughy
sough95320461s_ough
bough115719312_bough
chough15699242chough
cloughs13517052cloughs
cough115819642_cough
dough105217382_dough
enough1045752enough
laugh94414372_laugh
loughs105014772_loughs
ploughs13526102ploughs
rough97819432_rough
saugh95318402s_augh
scouth115011152scouth
shaugh13287432shaugh
sheugh13295882sheugh
sleigh10258202sleigh
sleuth937232sleuth
slog56728272slo_g_
slogs64521842slo_gs
slosh84514482slo_sh
sloth85019442slo_th
slouchy15454842slouchy
sloughed13305582sloughed
slug55124642sl_ug_
slugs64618562sl_ugs
slush85316572sl_ush
soughs105115622s_oughs
sought106315052s_ought
south85223572s_outh
sugh86423442s__ugh
though139410762though
tough97321982_tough
trough108512022trough
abought1346143abought
almug8429303almug_
almugs9396423almugs
along65419493along_
aloud65018063alou_d
although1542593although
aslosh966233aslo_sh
avouch1434833avouch
blog75723823blo_g_
blogs85319233blo_gs
blotch13197143blotch
blouse84714723blouse
blousy11459123blousy
blush105115313bl_ush
borough1344513borough
boughs125414373_boughs
bought125115633_bought
brought13308683brought
brugh115414293_brugh
choughs16576623choughs
choush14549063choush
claught1335103claught
clog76123243clo_g_
cloggy1344873cloggy
clogs85519553clo_gs
cloth105817543clo_th
cloud86716423clou_d
clouds94612353clouds
cloudy12517803cloudy
clour76617283clou_r
clours85215083clours
clout75330463clou_t
clouts87017203clouts
colugo935863colugo
couch125320113_couch
coughs125514543_coughs
couth106122483_couth
crouch133910203crouch
doughs115912933_doughs
dought114915513_dought
doughy14499843_doughy
drought12258873drought
drouth104410103drouth
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
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
sangh95517453s_angh
sauch104918773s_auch
saughs104812053s_aughs
saughy13507463s_aughy
scooch13228123scooch
scorch13198093scorch
scotch13207513scotch
scour75315533scou_r
scourge1035653scourge
scours84913583scours
scouse84113633scouse
scout75031453scou_t
scouths12527893scouths
scouts84817943scouts
scrouge1036353scrouge
selcouth1344093selcouth
shaughs14245283shaughs
sheuch14267043sheuch
sheughs14264533sheughs
shog86025133sho_g_
shogi95013993sho_gi
shogs95319703sho_gs
shogun1045703shogun
should1038023should
shout85433163shou_t
shouts94017713shouts
shrug94512513shrug_
shrugs10469163shrugs
shush113812543s_hush
sigh85625893s__igh
skeigh14265903skeigh
skosh12407263sko_sh
slag55934353sl_ag_
slaggy11438793slaggy
slags66525903sl_ags
slang66324023slang_
slangs75615343slangs
slangy105411393slangy
slash84719683sl_ash
slatch114510533slatch
sledge85011283sledge
sleighs11245673sleighs
sleight11279023sleight
sleuths1034743sleuths
slight103416003sl_ight
sling66028803sling_
slings74618013slings
slob66029423slo__b
slobby1334803slobby
slobs74419873slo_bs
sloe45534953slo__e
sloes54728873slo_es
slogan7539223slogan
slogged104910463slogged
slogger94310483slogger
sloid64619693slo_id
sloids73712693sloids
slojd13378843slo_jd
slojds14345473slojds
sloop76118913slo_op
sloops85513623sloops
slop66533873slo__p
slope75823563slo_pe
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
sloppy1395303sloppy
slops75026013slo_ps
sloshy12366623sloshy
slot46049823slo__t
sloths94911883sloths
slots54830523slo_ts
slouched14206743slouched
sloucher13206813sloucher
slouches13208073slouches
sloughier1343673sloughier
sloughing14244753sloughing
sloven9389633sloven
slow77729493slo__w
slowed104617073slowed
slower94016153slower
slowish1337633slowish
slowly1237153slowly
slows85323463slo_ws
sloyd9409683slo_yd
sloyds10346293sloyds
slub65428033sl_u_b
slubs74719533sl_ubs
sludge84811943sludge
sludgy11366253sludgy
slue45332193sl_u_e
slued64220513sl_ued
slues54527173sl_ues
sluff114016813sl_uff
slum65430513sl_u_m
slump94816633sl_ump
slums74623433sl_ums
slung65117833sl_ung
slunk95016303sl_unk
slur45525153sl_u_r
slurb74116323sl_urb
slurp74014983sl_urp
slurs54123373sl_urs
slushy12417223sl_ushy
slut45040593sl_u_t
sluts54523983sl_uts
smog76317413smo_g_
smoggy1354283smoggy
smogs85112163smo_gs
smooch13266803smooch
smoosh11236733smoosh
smooth11259193smooth
smug75815263s_mug_
smush104410583s_mush
snog55623633sno_g_
snogs66017493sno_gs
snout54530633snou_t
snouts64915863snouts
snouty9419953snouty
snug55218693s_nug_
snugs64913023s_nugs
soggy105413903s_oggy
solum74717603solu_m
solums85211333solums
solus54726983solu_s
solute64016663solute
song55133673s_ong_
songs67725553s_ongs
sooth85924053s_ooth
soph97024203s_o_ph
sorgho10348713s_orgho
sorgo64719723s_orgo
soth75932513s_o_th
sou37853693s_ou__
soughed123811623s_oughed
souk86127173s_ou_k
souks94820523s_ouks
soul46435713s_ou_l
souls55127363s_ouls
sound64420023s_ound
soup66232913s_ou_p
soups75322943s_oups
soupy106115403s_oupy
sour45935893s_ou_r
sours55230503s_ours
sous46947213s_ou_s
souse56530773s_ouse
souths95216603s_ouths
splodge1134103splodge
splosh1186543splo_sh
splotch1442843splotch
sponge939663sponge
spongy1236743spongy
spouse84112513spouse
spout75029633spou_t
spouts85115113spouts
sprug85313893sprug_
sprugs94010173sprugs
squush1833993squush
stodge8369043stodge
stodgy11415733stodgy
stogy95414083sto_gy
stooge73811663stooge
stound7399903stound
stoup75517073stou_p
stoups85313273stoups
stour54916743stou_r
stoure64814943stoure
stours65015623stours
stoury9529943stoury
stout57434053stou_t
stouts65019003stouts
such96424813s__uch
sughs95313323s__ughs
swoosh12195213swoosh
swoun84811493swou_n
swound10377633swound
swouns9358243swouns
teugh95511613_teugh
thought14639133thought
through141647513through
touch106519393_touch
toughs105414983_toughs
toughy135911073_toughy
troughs11698673troughs
ugh76520683___ugh
unrough11105233unrough
vouch134611903_vouch
vugh117115723__vugh
waugh125411683_waugh
wrought14276923wrought
yogh116616143_yo_gh
youth115315043_youth

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 Filter1786911127160.263679433.5
2DLD Change Limit1127163616.48617378.4
3Display Results3613610.1532359.5
 (SQL Overall)1786913616.90225889.7
 
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.