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

241 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
trochee12261388(None) 
troche113112511troch_e
trochees132510181trochees
troches123715341troches
broche133612102broch_e
crochet143616662crochet
rochet115423002_rochet
tocher114014912t_ocher
torched133511352torched
torchere1347682torchere
torches123715432torches
towhee122613882t_owhee
trachea12311672trachea
tracheae1349112tracheae
trachle12311852trachle
trochal1288242trochal
trochar1257072trochar
trochil1258712trochil
trochlea1345192trochlea
trochleae1444172trochleae
trocked144312242trocked
trothed114010972trothed
arched125717323ar_ched
archer115016243ar_cher
arches114822043ar_ches
boche124216953_boch_e
boches134618523_boches
bouchee143313543bouchee
braches144621223braches
brachet144020313brachet
brioche14275923brioch_e
brioches15227253brioches
broached16309123broached
broacher15329263broacher
broaches153211623broaches
brocade1238533brocade
brochette1645223brochette
brochure1544353brochure
brocket154013383brocket
brooches15288193brooches
brothel12318193brothel
brother123311333brother
caroche1469243caroch_e
caroches15710693caroches
cloche134312373cloch_e
cloches144113713cloches
cooches143515833cooches
creche13310763crech_e
creches14313093creches
crocheted1745313crocheted
crocheter1645563crocheter
crochets15359833crochets
crocine11314153crocine
crocked164014433crocked
crocket154615673crocket
crotched16428593crotched
crotches153411303crotches
crotchet152711993crotchet
crouched16359143crouched
crouches153711293crouches
fitchee152710783fitchee
frocked17439333frocked
frothed14288783frothed
frother133110153frother
grocer94212143groc_er
groschen1442973groschen
grouched15356663grouched
grouches14328213grouches
hooches153812523hooches
hoochie1537803hoochie
kimchee1845603kimchee
lichee114017973_lichee
lychee143710893_lychee
mooched153910533mooched
moocher143610673moocher
mooches143714453mooches
ocher104516103__ocher
ochre103411593__ochre
orache114013593orach_e
oraches124216473oraches
pooched152810083pooched
pooches143214163pooches
porches143815673porches
prithee1239933prithee
proceed12310553proceed
prochein1547523prochein
procure1138573procure
prophet14316033prophet
prythee1545383prythee
rachet115028973_rachet
rechew14310213_rechew
richen113812513_richen
richer114015043_richer
riches115022083_riches
roached133211833_roached
roaches123616213_roaches
rochets124213473_rochets
rocked135022323_rocked
rocker124319573_rocker
rocket125425283_rocket
rotche114311983_rotch_e
rotches123515703_rotches
rouche114714313_rouch_e
rouches124217893_rouches
ruche104216763_ruch_e
ruched124314633_ruched
ruches114819583_ruches
rushee93818773_rushee
soroche1237183soroch_e
soroches1338803soroches
strophe1239143stroph_e
strophes13310603strophes
tache106222373t_ach_e
taches114224173t_aches
teacher123714833teacher
teaches122718353teaches
teched124014433t_eched
techie11511723t_echie
tenches123515523tenches
tetched133010773tetched
thee78039063t___hee
tochered1437913t_ochered
tochers123413093t_ochers
toffee123311013t_offee
toothed113310243toothed
topee76029953t_o_pee
tophe106718973t_oph_e
tophes115218423t_ophes
torch107420933torch__
torcheres1446863torcheres
torchier1337463torchier
torchiere1443573torchiere
torchon1237363torchon
torchy14549533torch_y
toshes94520103t_oshes
tother94117143t_other
touche114916173touch_e
touched134914963touched
toucher124814353toucher
touches125118343touches
toupee8316133t_oupee
towhees13277793t_owhees
townee92815213t_ownee
trace75829613trac__e
traced94821583trac_ed
tracer84820233trac_er
traces85329933trac_es
tracheal1348253tracheal
tracheas13410273tracheas
tracheate1448233tracheate
tracheid1437583tracheid
tracheole1445573tracheole
trachled1438313trachled
trachles13311753trachles
trachyte1645943trachyte
tracked143716133tracked
tracker133515173tracker
trainee72817793trainee
tranche123312223tranch_e
tranches132915513tranches
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trauchle1344963trauchle
tree47745813tr___ee
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
trice75127493tric__e
triced95518673tric_ed
tricep103911073tric_ep
trices84826333tric_es
trichite1349333trichite
trichome1596953trichome
tricked144016163tricked
tricker134615523tricker
trickie132611033trickie
trickle133613443trickle
troaked12438253troaked
trocar848773troc_ar
trocars959043trocars
trochaic1546943trochaic
trochars1377853trochars
trochili1376943trochili
trochils1388583trochils
trochlear1443453trochlear
trochleas1444713trochleas
trochoid1468443trochoid
trock114817603troc__k
trocks123614633troc_ks
trodden934883trodden
trode65322853tro__de
troffer13125863troffer
troke94821053tro__ke
troked114114583tro_ked
trokes104019263tro_kes
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trommel11315363trommel
trompe105611263tro_mpe
tromped124210293tromped
trompes114111623trompes
trone55131863tro__ne
trones65629283tro_nes
trooped104010723trooped
trooper94210363trooper
trope75725803tro__pe
tropes84824353tro_pes
trophic14311033trophic
trophied1437643trophied
trophies13413673trophies
trophy1438283troph_y
tropine93116653tropine
troth85622203troth__
troths95414153troth_s
trotted83711283trotted
trotter73312253trotter
trouble957713trouble
trounce936823trounce
troupe84812433tro_upe
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trouvere1144073trouvere
trove85221923tro__ve
trover95014663tro_ver
troves94719113tro_ves
trowed104714653tro_wed
trowel94211463tro_wel
truce75118693truc__e
truced95312053truc_ed
truces84916333truc_es
trucked143910813trucked
trucker134010733trucker
truckle13358863truckle
trustee73514443trustee
tusche1136783tusch_e
tusches1237903tusches
vouchee153411263vouchee

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272415.87322820.9
3Display Results2412410.0962510.4
 (SQL Overall)1786912416.37528030.0
 
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.