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

470 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
tercets9351244(None) 
tercels94110361tercels
terces83921411terce_s
tercet83624911tercet_
terrets72913581terrets
berets85822532ber_ets
cermets1139712cermets
erects84116182_erects
ferrets103111392ferrets
mercers114412772mercers
merces105720742merce_s
percents122713372percents
percepts14247642percepts
secrets9311772secrets
sterlets8169272sterlets
targets84314222targets
telnets738372telnets
tenets65518952te_nets
terce75721842terce__
tercel83612992terce_l
tercelets1144812tercelets
terete6319332ter_ete
termers95414502termers
ternes65422902terne_s
terret63425622terret_
territs72714502territs
tersest71713992tersest
tiercels10344752tiercels
tierces93710452tierce_s
trets55928022t_r_ets
trevets10499982trevets
turrets73010672turrets
versets103913102versets
vervets13419752vervets
aerates74627503aerates
aeries64737783aerie_s
aeriest73924053aeriest
afreets1037023afreets
amercers1256133amercers
amerces1149853amerce_s
armets84918353_armets
avocets1235453avocets
barbets114915853barbets
barrets94917113barrets
bearcats1267023bearcats
beckets15399823beckets
beets76131443be__ets
befrets1237613befrets
begets96215523be_gets
bennets94712163bennets
berates94126883berates
berceuse1243433berceuse
beret74946363ber_et_
bermes106023003berme_s
besets85718803be_sets
brevets12519413brevets
burets84321273bur_ets
burnets93813263burnets
carcels114516063carcels
carets85330773car_ets
carnets93918403carnets
carpets113915333carpets
cerates95428253cerates
cercis104614493cerc_is
cercus105013153cerc_us
ceres75540013cer_e_s
cereus85215523cer_eus
cerites94823433cerites
cermet10321153cermet_
certes84623083certe_s
circlets1235663circlets
coercers1237653coercers
coerces11311943coerce_s
coerects1258543coerects
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
cruets85314953_cruets
curets84922343cur_ets
curvets12399913curvets
deceits102810883de_ceits
decrees102513123decrees
deets65330243de__ets
defects134511523defects
deicers103612733deicers
deices94119373deice_s
dejects17389223dejects
derates84028893derates
derats74625063der_ats
descents112511203descents
detects104011093detects
deuces94015513deuce_s
directs102710263directs
dulcets1046283dulcets
ebbets10376843_ebbets
eeriest73620673eeriest
egrets72712243_egrets
ejects15409953_ejects
elects83315003_elects
emcees1037813_emcees
emmets10349153_emmets
erect74129333_erect_
ergots74512373_ergots
ernes55224813_erne_s
erses55826803_erse_s
eructs83610793_eructs
erupts8348903_erupts
escots84211743_escots
excels1536663_excels
excepts1885203_excepts
excess1546053_excess
facets116316653_facets
farcers124713443farcers
farces115223323farce_s
faucets12578443faucets
feces105625363fe_ce_s
fencers123810623fencers
fences114617113fence_s
feres86038183fer_e_s
ferments13311473ferments
ferrels10248623ferrels
ferret93021173ferret_
ferrety13287013ferrety
fiercest13216143fiercest
forceps14466983forceps
forcers124215713forcers
forces114422133force_s
forgets113813793forgets
frets85523403_fr_ets
gargets94614573gargets
garnets84115413garnets
garrets84413623garrets
genets75716663ge_nets
gerents82612923gerents
germens1078633germens
gorgets94711783gorgets
greets75117423_greets
gurnets84010793gurnets
helmets12309073helmets
hepcats1436473hepcats
herders113914123herders
heres86245903her_e_s
hereto9313693her_eto
heriots10312063heriots
hermits12312143hermits
heroes94923833heroe_s
herpes115517323herpe_s
hornets104113553hornets
intercepts1448643intercepts
intercuts1148793intercuts
iterates81317823iterates
jennets14517633jennets
jereeds15326393jereeds
jerkers18287083jerkers
jerseys1733243jerseys
keets95123483ke__ets
kermes124616143kerme_s
kermess13396223kermess
kernels11417953kernels
kernes104717533kerne_s
kerseys1433993kerseys
keysets1434343keysets
lancets93411163lancets
leets54927123le__ets
marcels113212373marcels
markets133314033markets
meets74224613me__ets
mercer105214203merce_r
mercery14397623mercery
merches144013763merches
mercies113817563mercies
mercs96020453merc__s
merdes94518603merde_s
meres75143573mer_e_s
merest84725113mer_est
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merits8320873mer_its
merles85322763merle_s
merlots92710123merlots
nereis6315343ner_eis
nerts55924983ner__ts
nerves94216193nerve_s
overbets132510683overbets
overcuts1337513overcuts
overlets112312363overlets
oversets113114173oversets
overwets14219953overwets
parcels113712663parcels
pargets105215193pargets
peaces106324083peace_s
pellets94014783pellets
pelmets11309693pelmets
pencels113610063pencels
percent113520603percent
percept133112523percept
perchers153611523perchers
perches143717953perches
percuss1137163percuss
peres76246643per_e_s
perfects15107353perfects
permits11314003permits
perpents122312043perpents
perses85428063perse_s
pertest9317043pertest
perverts1337533perverts
piercers12316723piercers
pierces113411193pierce_s
placets113911223placets
precents123015043precents
precepts14268893precepts
precess11310863precess
precuts111710473precuts
presets94216423presets
reacts83616603reac_ts
recces10614913recce_s
recepts113010273re_cepts
recess8314263re_cess
recits83621363re_cits
recuts83817373re_cuts
reerects10319923reerects
refects124012743refects
reflets103513153reflets
reglets83512983reglets
regreets9287853regreets
regrets83212923regrets
rejects163910693rejects
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
rerents73319423rerents
resects94115593resects
resets65427613re_sets
rets45352563__r_ets
revets94022183re_vets
rewets94617213re_wets
secret8325063secret_
secrete9311073secrete
secretes10410473secretes
sects75622893se_c_ts
selects91912143selects
sennets73712583sennets
septets998953septets
seres55448893ser_e_s
serest64831613ser_est
sergers83815633sergers
serges74225973serge_s
series64540973serie_s
serpents102410373serpents
servers103214833servers
serves94423653serve_s
sestets7911473sestets
sextets1497143sextets
sherbets1335213sherbets
sorbets93012513sorbets
starets73515923star_ets
starlets81610083starlets
stereos74314973ster_eos
steres63929533ster_e_s
sterlet71318473sterlet_
sternest8314433sternest
streets73312623streets
tablets94714383tablets
taces76237803t_ace_s
tacet75840023t_acet_
tackets134914363tackets
tacts76524123t_ac_ts
tappets113610013tappets
tares57456563tar_e_s
targes74524603targe_s
target75028913target_
tarots66422993tar_ots
tarres64723043tarre_s
tartest72517533tartest
tartlets8289663tartlets
tarts57242023tar__ts
tassets75012773tassets
teacarts10116073teacarts
teachers133212393teachers
teaches122718353teaches
teacups1133963teacups
teapots939053teapots
tearers75218233tearers
teariest82417263teariest
tearless848713tearless
teasels74311313teasels
teasers75317243teasers
teases65426273tease_s
teats55636813te__ats
teazels16406893teazels
techs106915833te_c_hs
tecta74215523te_c_ta
tedders94010233tedders
teels55726373te__els
teemers95012903teemers
teems76019783te__ems
teeners74415453teeners
teens56227483te__ens
teepees939263teepees
tees45353583te__e_s
teeters74018303teeters
teeth87315853te__eth
telcos8710683telc_os
teles54536003te_le_s
telfers10299083telfers
tellers73717613tellers
telnet6518833telnet_
tempehs14325153tempehs
tempers113513013tempers
tempest1139223tempest
tempests1234443tempests
templets12226143templets
tempts10439453te_mpts
tenaces92814513tenace_s
tenants7311013tenants
tenches123515523tenches
tenders83719723tenders
tenet55542213te_net_
tenners74014923tenners
tenrecs936033tenrecs
tenses64722553tense_s
tensest72713313tensest
tenters73921113tenters
tents56434213te__nts
tenues63816443tenue_s
tepees84215243te_pees
terais64023513ter_ais
terbias9310743terbias
tercelet1049883tercelet
teredo7310783ter_edo
teredos839183teredos
tergite8311003tergite
tergites9310543tergites
termed94816703terme_d
termer85717253terme_r
termite9313893termite
termites10313693termites
termless1036233termless
termors94712773termors
terms75523473ter__ms
ternate7415483ternate
terne56426153terne__
terns55226873ter__ns
terpene92310863terpene
terpenes102111573terpenes
terraces102712253terrace_s
terras63516973ter_ras
terreen7257573terreen
terreens8246533terreens
terrene72411033terrene
terrenes82212603terrenes
terriers84210823terriers
terries73425633terries
territ63421383territ_
terrors73112213terrors
terse55026823terse__
tersely1038113tersely
terser67317823terse_r
testees74215913testees
testers74124543testers
testes65125823teste_s
tests56530193te__sts
tethers103815313tethers
tets45847463t___ets
tetters74320473tetters
texts125515043te__xts
theres96525473ther_e_s
thereto1038993ther_eto
thermels13607763thermels
thermes126214613therme_s
thermits1338513thermits
thickets17287083thickets
threats104311683threats
threeps12687043threeps
threes97117323thr_ees
thrifts1335523thrifts
throats104612193throats
throes97518673throe_s
thrusts10226523thrusts
tickets134113683tickets
tierce8339843tierce__
tierced10347053tierce_d
tiercel9316213tierce_l
tincts84510803tinc_ts
tipcats1137103tipcats
tippets11339373tippets
tires55437493tir_e_s
toilets74112913toilets
tomcats11127773tomcats
tonlets73212503tonlets
toquets16367863toquets
torches123715443torches
torcs75123763torc__s
tores55352673tor_e_s
tories65435883torie_s
torments10310453torments
torrents838143torrents
torses64727953torse_s
tortes64826053torte_s
torts56138123tor__ts
tracers94917843tracers
traces85329933trace_s
tracts85019073t_racts
traits65121983t_raits
treats64821703t_reats
trecento1066213trecento
trecentos1155883trecentos
treens65317873t_reens
trees55835763t_r_ees
treks96016853t_r_eks
tres46542903t_r_e_s
tress55423163t_r_ess
tret46653533t_r_et_
trevet94818913trevet_
trews86118893t_r_ews
treys85018213t_r_eys
triceps11267343triceps
trices84826333trice_s
tricots9311563tricots
triens65417543t_riens
triers64321523t_riers
tries55742813t_rie_s
trijets14308263trijets
trivets103911583trivets
trots56629943t_r_ots
trouts66116633t_routs
truces84916333truce_s
trues54925323t_rue_s
truest64816193t_ruest
trusts64714433t_rusts
trysts9448793t_rysts
tuckets134810333tuckets
tuffets13266523tuffets
turbeth1274713turbeth
turbeths1373353turbeths
turbits969233turbits
turbots988023turbots
tureens7289873tureens
turkeys1434523turkeys
turners73912893turners
turpeth1284813turpeth
turpeths1373153turpeths
turret63121853turret_
turves94212693turve_s
tweets94210103t_weets
tyrants1037453tyrants
tyres84725233tyr_e_s
varlets10411573varlets
velvets13326693velvets
vergers114412633vergers
verges104320183verge_s
veriest103719133veriest
verists103613673verists
verites103822263verites
vermes115019143verme_s
versers103813523versers
verses94223763verse_s
verset94327323verset_
verstes104014283verstes
versts93914733ver_sts
verts85724733ver__ts
verves124617883verve_s
vervet124619063vervet_
waterjets1944463waterjets
wechts1446253we_chts
weets85427723we__ets
wergelts1253413wergelts
worsets105512843worsets
zeroes154314343zeroe_s

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.393454684.5
2DLD Change Limit1340274706.86019537.5
3Display Results4704700.1702764.7
 (SQL Overall)1786914707.42324072.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.