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

503 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
troche11311251(None) 
broche133612101broche
trochee122613881trochee
troches123715341troches
boche124216952_boche
brioche14275922brioche
caroche1469242caroche
cloche134312372cloche
creche13310762creche
crochet143616662crochet
orache114013592orache
rochet115423002_rochet
rotche114311982_rotche
rouche114714312_rouche
ruche104216762_ruche
soroche1237182soroche
strophe1239142strophe
tache106222372t_ache
tocher114014912t_ocher
tophe106718972t_ophe
torch107420932torch_
torched133511352torched
torches123715432torches
torchy14549532torchy
touche114916172touche
trace75829612trac_e
trachea12311672trachea
trachle12311852trachle
tranche123312222tranche
trice75127492tric_e
trocar848772trocar
trochal1288242trochal
trochar1257072trochar
trochees132510182trochees
trochil1258712trochil
trochlea1345192trochlea
trock114817602troc_k
trocked144312242trocked
trocks123614632trocks
trode65322852tro_de
troke94821052tro_ke
trompe105611262trompe
trone55131862tro_ne
trope75725802tro_pe
trophy1438282trophy
troth85622202troth_
trothed114010972trothed
troths95414152troths
troupe84812432troupe
trove85221922tro_ve
truce75118692truc_e
tusche1136782tusche
ache96829823__ache
apache134210773apache
arch98628443ar_ch_
arched125717323ar_ched
archer115016243ar_cher
arches114822043ar_ches
arose55832083aro_se
arouse65019983arouse
atrophy1546183atrophy
attache12106693attache
aurochs1245983aurochs
barouche1544173barouche
bocce114313113_bocce
boches134618523_boches
brace95629273brac_e
brach126123303brach_
braches144621223braches
brachet144020313brachet
brachs134415753brachs
brioches15227253brioches
broach133611113broach_
broached16309123broached
broacher15329263broacher
broaches153211623broaches
brocade1238533brocade
brochure1544353brochure
brock136017073broc_k
brocket154013383brocket
brocks145214153brocks
brogue94211033brogue
broke116019783bro_ke
brome94421973bro_me
bronchi14176313bronchi
broncho14206463broncho
bronze173610923bronze
brooch13368443brooch_
brooches15288193brooches
brose75227033bro_se
broth106521093broth_
brothel12318193brothel
brother123311333brother
broths115013923broths
brothy14519623brothy
browse115713853browse
cache125122483_cache
caroch13911763caroch_
caroches15710693caroches
cliche133712453cliche
cloches144113713cloches
clothe114712993clothe
cooch124916833cooch_
cooches143515833cooches
creches14313093creches
croc85723733croc__
crochets15359833crochets
croci95818133croc_i
crocine11314153crocine
crock135921993croc_k
crocked164014433crocked
crocket154615673crocket
crocks145118423crocks
crocs95722433croc_s
crocus104813173crocus
crone75231333cro_ne
crore74922873cro_re
crosse85216303crosse
crotch133410083crotch_
crotched16428593crotched
crotches153411303crotches
crotchet152711993crotchet
crouch133910203crouch_
crouched16359143crouched
crouches153711293crouches
croupe105114433croupe
crouse84619363crouse
croute84617273croute
croze164719453cro_ze
douche124613223douche
drachm1436493drachm
drogue8938333drogue
drone65324983dro_ne
drove95518063dro_ve
drowse105010553drowse
earache1239323earache
eche97520283__eche
epoch1248203epoch_
epochs1335813epochs
erode64520993ero_de
erose55727273ero_se
farouche1643053farouche
fiche134616743_fiche
fleche14299303fleche
force105324273forc_e
frock145314653froc_k
frocked17439333frocked
frocks154111213frocks
froe75329993fro__e
frore86218803fro_re
frosh115713403frosh_
froth115919283froth_
frothed14288783frothed
frother133110153frother
froths125411443froths
frothy15578373frothy
froze174515653fro_ze
gauche1238553gauche
grace85124543grac_e
grocer94212143grocer
groove10438873groove
grope84821613gro_pe
groschen1442973groschen
grosze16457733grosze
grouch12318473grouch_
grouched15356663grouched
grouches14328213grouches
grouchy16294243grouchy
grouse74315023grouse
grove95219333gro_ve
groyne1037213groyne
hooch135813703hooch_
hooches153812523hooches
hoochie1537803hoochie
irone55126363iro_ne
krone94018733kro_ne
loch95527133_loch_
lochs106715513_lochs
louche115212663louche
mache125925303_mache
manche133515103manche
miche126219243_miche
mocha1249923_mocha
mooch125313613mooch_
mooched153910533mooched
moocher143610673moocher
mooches143714453mooches
niche105016793_niche
ocher104516103__ocher
ochre103411593__ochre
orach105219233orach_
oraches124216473oraches
oracle84313293oracle
oroide7311703oroide
panoche1456383panoche
penoche1447043penoche
pooch124815303pooch_
pooched152810083pooched
pooches143214163pooches
porch125918623porch_
porches143815673porches
price93725413pric_e
probe94320813pro_be
proceed12310553proceed
prochein1547523prochein
procure1138573procure
prole74527793pro_le
prone75332623pro_ne
prophet14316033prophet
prose75835123pro_se
prove104823193pro_ve
psyche1674293psyche
quiche2057903quiche
race66746263_rac_e
rachet115028973_rachet
raphe104916423_raphe
rathe85821923_rathe
recce9514563_recce
rechew14310213_rechew
rice64942913_ric_e
rich97025543_rich_
richen113812513_richen
richer114015043_richer
riches115022083_riches
roach105717003_roach_
roached133211833_roached
roaches123616213_roaches
robe65335643_ro_be
roble75223023_roble
roc520243253_roc__
rochets124213473_rochets
rock105735183_roc_k
rocked135022323_rocked
rocker124319573_rocker
rocket125425283_rocket
rocks114626413_rocks
rocky144513853_rocky
rocs65533663_roc_s
rode55844303_ro_de
roe36861083_ro__e
rogue66417533_rogue
role45851823_ro_le
roose56127093_roose
rope65542913_ro_pe
roque144812133_roque
roscoe839763_roscoe
rose46148903_ro_se
roshi8310753_roshi
rotch105815933_rotch_
rotches123515703_rotches
rote46249023_ro_te
rotte54625933_rotte
rouches124217893_rouches
roue45941743_ro_ue
rouge65423443_rouge
rouse56634703_rouse
route55132073_route
rove75136983_ro_ve
ruched124314633_ruched
ruches114819583_ruches
seiche11811833seiche
socle7419573_socle
soothe94214853soothe
soroches1338803soroches
strobe84513813stro_be
strode75215973stro_de
stroke105116173stro_ke
strophes13310603strophes
strove95014793stro_ve
tace65342513t_ac_e
tach96132753t_ach_
taches114224173t_aches
tachs105820933t_achs
takahe1335793takahe
taroc75721643taroc__
tarocs84615663taroc_s
teach105221123teach_
teacher123714833teacher
teaches122718353teaches
tech95925443t_ech_
teched124014433t_eched
techie11511723t_echie
techs106915833t_echs
techy135612013t_echy
teethe94511313teethe
tench105620003tench_
tenches123515523tenches
terce75721843terc_e
tetched133010773tetched
tetchy1436003tetchy
teuch105214853teuch_
the67436053t___he
thecae11299653thecae
thole85620843tho_le
thorpe113610093thorpe
those85218143tho_se
thrice114311573thric_e
throe89321423thro__e
throne98517603thro_ne
throve128012393thro_ve
tithe85319703t_ithe
tochers123413093t_ochers
toe310166853t_o__e
togae67020113t_ogae
togue64816303t_ogue
toile54626493t_oile
toke86738493t_o_ke
tole46052903t_o_le
tome67543193t_o_me
tone46953743t_o_ne
tonne54921433t_onne
toonie63617993toonie
tooth88020183tooth_
toothed113310243toothed
tooths96013803tooths
toothy12529693toothy
tootle62613813tootle
tope65946383t_o_pe
topee76029953t_opee
toph96326873t_oph_
tophes115218423t_ophes
tophi105215303t_ophi
tophs105220053t_ophs
toque145113093t_oque
torah87125273torah_
torahs95115643torahs
torc66333353torc__
torchere1347683torchere
torchier1337463torchier
torchon1237363torchon
torcs75123763torc_s
tore47359323t_o_re
torose64317693torose
toroth95512963toroth_
torque15237673torque
torse55833333t_orse
torte55431703t_orte
tosh74826813t_osh_
toshes94520103t_oshes
tote46643673t_o_te
tother94117143t_other
touch106519393touch_
touched134914963touched
toucher124814353toucher
touches125118343touches
touchy145010503touchy
touse55430673t_ouse
towhee122613883t_owhee
towie85821873t_owie
traced94821583traced
tracer84820233tracer
traces85329933traces
tracheae1349113tracheae
tracheal1348253tracheal
tracheas13410273tracheas
tracheid1437583tracheid
trachled1438313trachled
trachles13311753trachles
trachyte1645943trachyte
track114823013trac_k
tracked143716133tracked
tracker133515173tracker
tracks124818843tracks
tract75635713trac_t
tracts85019073tracts
trade65026043tr_ade
trance84718763trance
tranches132915513tranches
trash86119763trash_
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trashy12509053trashy
trauchle1344963trauchle
trave85223033tr_ave
treacle939973treacle
treble8311663treble
tree47745813tr__ee
trench114211613trench_
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
triage72812893triage
tribe74420273tr_ibe
triced95518673triced
tricep103911073tricep
trices84826333trices
trichite1349333trichite
trichome1596953trichome
trick115420693tric_k
tricked144016163tricked
tricker134615523tricker
trickie132611033trickie
trickle133613443trickle
tricks125319013tricks
tricky154211473tricky
tricot8317753tricot
triene64316383triene
trifle94012883trifle
trike95320163tr_ike
trine54734603tr_ine
triode75311893triode
triose64715383triose
tripe75425383tr_ipe
triple84215923triple
triste63818643triste
trite54730033tr_ite
triune64210183triune
troak95213573tro_ak
troaked12438253troaked
troaks104410603troaks
trocars959043trocars
trochaic1546943trochaic
trochars1377853trochars
trochili1376943trochili
trochils1388583trochils
trochleae1444173trochleae
trochlear1443453trochlear
trochleas1444713trochleas
trochoid1468443trochoid
trod57627953tro__d
trodden934883trodden
troffer13125863troffer
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
trois57226093tro_is
troked114114583troked
trokes104019263trokes
troll54416533tro_ll
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trolls64613943trolls
trolly94012363trolly
trommel11315363trommel
tromp95815803tro_mp
tromped124210293tromped
trompes114111623trompes
tromps104911703tromps
trona54118953tro_na
tronas63816903tronas
trones65629283trones
troop76417533tro_op
trooped104010723trooped
trooper94210363trooper
troops85712783troops
trooz145016153tro_oz
trop66833303tro__p
tropes84824353tropes
trophic14311033trophic
trophied1437643trophied
trophies13413673trophies
tropic103014193tropic
tropin83316753tropin
tropine93116653tropine
trot46351313tro__t
trots56629943tro_ts
trotted83711283trotted
trotter73312253trotter
trotyl9236673trotyl
trouble957713trouble
trough108512023trough
troughs11698683troughs
trounce936823trounce
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trout57332573tro_ut
trouts66116633trouts
trouty95211793trouty
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trows88826183tro_ws
trowth1277883trowth
trowths1365023trowths
troy77429683tro__y
troys86418613tro_ys
truced95312053truced
truces84916333truces
truck116115463truc_k
trucked143910813trucked
trucker134010733trucker
truckle13358863truckle
trucks124711973trucks
trudge8318733trudge
true46725853tr__ue
truffe1276233truffe
truth85214153truth_
truths9449503truths
tryste9399583tryste
tusches1237903tusches
twice104711123twic_e
tythe115210453t_ythe
utricle937913utricle
writhe125310703writhe
wrote84717483wro_te
wroth116815883wroth_

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.376475242.0
2DLD Change Limit1127165035.22021593.1
3Display Results5035030.1533287.6
 (SQL Overall)1786915035.74931082.1
 
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.