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

231 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
though13941078(None) 
chough15699251chough
thought14639141thought
through141647521through
tough97321991t_ough
trough108512031trough
although1542602although
bough115719312_bough
choughs16576632choughs
choush14549062choush
clough12539132clough
cough115819642_cough
dough105217382_dough
enough1045762enough
haugh125114052_haugh
heugh125410922_heugh
lough95118482_lough
plough12577562plough
rough97819442_rough
shaugh13287432shaugh
sheugh13295882sheugh
slough10539232slough
sough95320462_sough
teugh95511612t_eugh
thigh12410122th_igh
thong95014182thong_
thongs104611192thongs
thorough15684132thorough
thou76722212thou__
thoued10429002thoued
thoughts15515612thoughts
thous86017262thou_s
thrush12257482thrush
thug86415482th_ug_
thugs95611992th_ugs
touch106519392t_ouch
toughs105414992t_oughs
toughy135911082t_oughy
troughs11698692troughs
abought1346153abought
avouch1434833avouch
bethought1853443bethought
borough1344523borough
boughs125414373_boughs
bought125115643_bought
brought13308693brought
brugh115414293_brugh
chouse116017563chouse
chug105914113ch_ug_
chugs115511943ch_ugs
cloughs13517053cloughs
couch125320113_couch
coughs125514543_coughs
couth106122493_couth
crouch133910203crouch
doughs115912933_doughs
dought114915523_dought
doughy14499843_doughy
drought12258883drought
drouth104410103drouth
enoughs1144633enoughs
faugh125712963_faugh
fought135112403_fought
ghoul959053ghou_l
ghouls1036043ghouls
gouge78220063_gouge
grouch12318473grouch
haughs13408563_haughs
heigh124812543_heigh
heuch135312333_heuch
heughs13516903_heughs
high116619923_h_igh
hoagy124710473_hoagy
hog78049063_ho_g_
hogg96617533_ho_gg
hoggs107212463_hoggs
hogs87139663_ho_gs
hong85833953_hong_
hongi96715873_hongi
hongs95126203_hongs
hooch135813703_hooch
horah117922053_horah
hotch136214733_hotch
houdah1335173_houdah
hound95016483_hound
hour75827313_hou_r
houri85915253_houri
hours85422393_hours
house89131423_house
hug76037363_h_ug_
huge86321653_h_uge
hugs86129753_h_ugs
huh96432013_h_u_h
hunh106323733_h_unh
hush105224113_h_ush
khoum1476643khou_m
khoums1594013khoums
kiaugh1442813kiaugh
laugh94414373_laugh
loughs105014773_loughs
methought1853943methought
mouch124715803_mouch
mouth105420293_mouth
nought104713973_nought
ouch95724633__ouch
ought95221543__ought
ouph95618373__ouph
ploughs13526103ploughs
pouch124617083_pouch
pugh106619233__pugh
rethought1653813rethought
rouge65423443_rouge
roughs105416223_roughs
roughy137010863_roughy
routh86423073_routh
saugh95318403_saugh
scouth115011153scouth
shaughs14245283shaughs
sheuch14267043sheuch
sheughs14264533sheughs
shog86025143sho_g_
shogi95014013sho_gi
shogs95319713sho_gs
shogun1045713shogun
should1038033should
shout85433173shou_t
shouts94017723shouts
shrug94512513shrug_
shrugs10469163shrugs
shush113812543sh_ush
slouch11438523slouch
sloughs11497563sloughs
sloughy14535803sloughy
soughs105115623_soughs
sought106315063_sought
south85223573_south
sugh86423443__sugh
taught104312233t_aught
teuch105214853t_euch
thatch1435613thatch
thegn95810903th_egn
theurgy1442733theurgy
thighs1346633th_ighs
thing96622983thing_
things104914303things
tho67433963tho___
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholoi9339233tholoi
tholos94213003tholos
thonged12376843thonged
thorax1638253thorax
thoria93012893thoria
thoric114314043thoric
thorn85318703tho_rn
thorns95314103thorns
thorny12509843thorny
thoro86217873tho_ro
thoron94713903thoron
thorp104414263tho_rp
thorpe113610093thorpe
thorps113610893thorps
those85218143tho_se
thouing11258603thouing
thrash12258363thrash
thresh12276863thresh
throng10539973throng_
throngs11508163throngs
throughly1952433throughly
thru76818943thru__
thrum104713633thru_m
thrums11429123thrums
thrust91911893thrust
thud85613913th_u_d
thuds95110133th_uds
thuja1535213th_uja
thumb124511283th_umb
thump126211573th_ump
thunk124911853th_unk
thurl84912683th_url
thus76721473th_u_s
thuya1135583th_uya
tog410255043t_o_g_
toga57027413t_o_ga
togs57242433t_o_gs
togue64816303t_ogue
tong56434353t_ong_
tonga65619693t_onga
tongs65928463t_ongs
tooth88020183t_ooth
toph96326873t_o_ph
torah87125273t_orah
torch107420933t_orch
tosh74826813t_o_sh
touche114916173t_ouche
touchy145010503t_ouchy
toughed123511693t_oughed
toughen11329203t_oughen
tougher114210983t_ougher
toughie1187593t_oughie
toughly14487433t_oughly
tour45530383t_ou_r
tours55325893t_ours
touse55430673t_ouse
tout46753823t_ou_t
touts54830393t_outs
trog57628213tro_g_
trogs67022603tro_gs
troth85622203tro_th
troupe84812433troupe
trout57332573trou_t
trouts66116633trouts
trouty95211793trouty
trowth1277883trowth
trug55720043t_rug_
trugs65516803t_rugs
truth85214153t_ruth
tug45937403t__ug_
tugs56231673t__ugs
tush74523903t__ush
ugh76520683___ugh
unrough11105243unrough
unthought1652863unthought
vouch134611903_vouch
vugh117115723__vugh
waugh125411683_waugh
whoosh15244353whoosh
wrought14276933wrought
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.376475242.0
2DLD Change Limit1127162315.54620323.8
3Display Results2312310.0633666.7
 (SQL Overall)1786912315.98529856.5
 
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.