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

247 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
troughs1169868(None) 
roughs105416211_roughs
toughs105414981t_oughs
trough108512021trough_
boroughs1443792boroughs
boughs125414372_boughs
brought13308682brought
brughs12509062br_ughs
choughs16576622choughs
cloughs13517052cloughs
coughs125514542_coughs
doughs115912932_doughs
drought12258872drought
droughts13245732droughts
drouths11436482drouths
enoughs1144622enoughs
loughs105014772_loughs
ploughs13526102ploughs
rouges76022382_rouges
rough97819432_rough_
roughy137010852_roughy
rouths95416822_rouths
sloughs11497562sloughs
soughs105115622_soughs
though139410772though_
thought14639132thought
thoughts15515602thoughts
through141647512through_
tough97321982t_ough_
toughy135911072t_oughy
trogs67022602tro_g_s
troths95414152tro_ths
troupes94112852troupes
trouts66116632trou_ts
trowths1365022trowths
trugs65516802tr_ug_s
truths9449502tr_uths
wrought14276922wrought
abought1346143abought
arouses74921293arouses
borough1344513borough_
bough115719313_bough_
bought125115633_bought
brogues10719823brogues
broths115013923bro_ths
brougham1642973brougham
broughams1742403broughams
brugh115414293br_ugh_
chough15699243chough_
clough12539133clough_
cough115819643_cough_
couths115715413_couths
crouch133910203crouch_
crouches153711293crouches
croupes114613103croupes
croups104312553crou_ps
croutes94815653croutes
dough105217383_dough_
dought114915513_dought
doughy14499843_doughy
draught12266963draught
draughts13284753draughts
drogues9398393drogues
drongos935493drongos
droughty16304473droughty
drouks1137123drou_ks
drouth104410103drouth_
drouthy14395173drouthy
drugs75214653dr_ug_s
enough1045753enough_
erugos7347343er_ugos
fought135112393_fought
fraught14266353fraught
fraughts15214243fraughts
frogs96220773fro_g_s
froths125411443fro_ths
frugs96114283fr_ug_s
furloughs1641773furloughs
gouges86318693_gouges
grogs76319413gro_g_s
grouch12318473grouch_
grouches14328213grouches
grouchy16294243grouchy
grounds9228313grounds
groups94210513grou_ps
grouses84616543grouses
grouts75015613grou_ts
growths1494423growths
haughs13408563_haughs
heughs13516903_heughs
kiaughs1542283kiaughs
laughs10489023_laughs
lough95118483_lough_
mouths115214533_mouths
nought104713963_nought
noughts11478083_noughts
ought95221533__ought
oughts104710183__oughts
ouphs104311273__ouphs
plough12577563plough_
progs86624153pro_g_s
prongs94314483prong_s
rogues74617673_rogues
rouche114714313_rouche
rouches124217893_rouches
rouens64814443_rouens
roues56039353_rou_es
rouge65423443_roug_e
rouged86717323_rouged
roughed124210943_roughed
roughen11338833_roughen
roughens12286893_roughens
rougher113511033_rougher
roughers12329183_roughers
roughest1238773_roughest
roughies1298323_roughies
roughish1545213_roughish
roughly14507293_roughly
rounds73615623_rounds
roups75118903_rou_ps
rouses65436283_rouses
rousts617016723_rousts
routes66129313_routes
routh86423073_routh_
routs57133413_rou_ts
rowths12458173_rowths
rugs56033683_r_ug_s
ruths85714643_r_uths
saughs104812053_saughs
scouths12527893scouths
scrouges1136683scrouges
shaughs14245283shaughs
sheughs14264533sheughs
slough10539233slough_
sloughy14535803sloughy
sough95320463_sough_
sought106315053_sought
souths95216603_souths
strouds837803strou_ds
sughs95313323__sughs
taught104312223t_aught
teugh95511613t_eugh_
thighs1346633t_highs
thongs104611193thong_s
thorough15684123thorough_
thous86017263thou__s
throngs11508163throng_s
throughly1952433throughly
thugs95611993t_hug_s
togas67823003t_o_gas
togs57242433t_o_g_s
togues76014243t_ogues
tongas74315523t_ongas
tongs65928463t_ong_s
tooths96013803t_ooths
tophs105220053t_o_phs
torahs95115643t_orahs
torous64319033torou__s
torulas759853torulas
torus54329763toru__s
touch106519393t_ouch_
touche114916173t_ouche
touches125118343t_ouches
touchy145010503t_ouchy
toughed123511693t_oughed
toughen11329203t_oughen
toughens12286723t_oughens
tougher114210983t_ougher
toughest1238303t_oughest
toughie1187593t_oughie
toughies1278243t_oughies
toughish1545283t_oughish
toughly14487433t_oughly
tours55325893t_ou_rs
touses64229673t_ouses
touts54830393t_ou_ts
tragus749233tr_agus
traumas938593traumas
triages82613793triages
trigos74214173tr_igos
trigs65423063tr_ig_s
triumphs1542513triumphs
triunes74311383triunes
troaks104410603tro_aks
trocars959043trocars
troche113112513tro_che
troches123715343troches
trocks123614633tro_cks
trog57628213tro_g__
trogon73611753tro_gon
trogons83410723trogons
troikas1135033troikas
troilus736413troilus
trois57226093tro__is
trokes104019263tro_kes
trolls64613943tro_lls
trompes114111623trompes
tromps104911703tro_mps
tronas63816903tro_nas
trones65629283tro_nes
troops85712783tro_ops
tropes84824353tro_pes
trophy1438283tro_phy
tropics113610653tropics
tropins93116313tropins
troth85622203tro_th_
trots56629943tro__ts
trotyls10236033trotyls
trouble957713trouble
troubles1057203troubles
trounce936823trounce
trounces1037063trounces
troupe84812433trou_pe
trouped103910983trouped
trouper93811433trouper
troupers10359443troupers
trouser73812473trouser
trousers83910633trousers
trout57332573trou__t
trouty95211793trou_ty
trovers103713323trovers
troves94719113tro_ves
trowels10358363trowels
trows88826183tro__ws
trowth1277883trowth_
troys86418613tro__ys
truces84916333tr_uces
trucks124711973tr_ucks
trudges9339993trudges
trues54925323tr_u_es
trug55720043tr_ug__
trulls64110283tr_ulls
trumps104611883tr_umps
trunks10429753tr_unks
truss54916923tr_u_ss
trusts64714433tr_usts
truth85214153tr_uth_
tryouts1035313tryou_ts
tsouris735153tsouris
tugs56231673t__ug_s
ughs85410973___ughs
unrough11105233unrough_
vrouws12494743vrou_ws
vughs12678743__vughs
wrongs10338933wrong_s
yoghs125410593_yo_ghs
youths124510043_youths

Search took 8 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.436409841.7
2DLD Change Limit1340272477.29618369.9
3Display Results2472470.0803087.5
 (SQL Overall)1786912477.81222873.9
 
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.