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

399 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
tercels9411036(None) 
tercel83612991tercel_
terces83921411terce_s
tercets93512441tercets
tiercels10344731tiercels
carcels114516062carcels
excels1536662_excels
ferrels10248622ferrels
kernels11417952kernels
marcels113212372marcels
mercers114412772mercers
merces105720742merce_s
parcels113712662parcels
pencels113610052pencels
teasels74311312teasels
teazels16406892teazels
teels55726372te__els
terce75721842terce__
tercelet1049882tercelet
tercelets1144812tercelets
tercet83624912terce_t
termers95414502termers
ternes65422902terne_s
terrets72913582terrets
tersely1038112tersely
thermels13607762thermels
tiercel9316202tiercel_
tierces93710452tierce_s
aerials74017553aerials
aeries64737783aerie_s
aerogels945593aerogels
amercers1256133amercers
amerces1149853amerce_s
ariels65119373_ariels
artels66216233_artels
barbels114514433barbels
barrels94514363barrels
bedels94015273be_dels
berceuse1243433berceuse
berets85822523ber_ets
bermes106023003berme_s
beryls11107883ber_yls
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bezels173712283be_zels
bordels103911973bordels
cancels114113313cancels
carcel105018673carcel_
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
cels65534973___cels
cercal10314123cercal_
cercis104614493cerc_is
cercus105013153cerc_us
cereals9313173cereals
ceres75540013cer_e_s
cereus85215523cer_eus
cermets1139713cermets
certes84623083certe_s
cervelas1344673cervelas
circles1139903circles
coercers1237653coercers
coerces11311943coerce_s
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
creels84416943_creels
crenels93711013crenels
crewels12438493crewels
darnels83710433darnels
decals93717713de_cals
deckels14367363deckels
decrees102513123decrees
defuels11296983defuels
deicers103612733deicers
deices94119373deice_s
derails84216393derails
deuces94015513deuce_s
devels104313903de_vels
dorsels84412583dorsels
easels65914553_easels
eels46536743_e__els
emcees1037813_emcees
erects84116183_erects
ernes55224813_erne_s
erses55826803_erse_s
ervils948773_ervils
eternals8238953eternals
excel1437743_excel_
excess1546053_excess
expels1547173_expels
farcers124713443farcers
farces115223323farce_s
fardels11389893fardels
farfels13348213farfels
feces105625363fe_ce_s
feels85223043fe__els
fencers123810623fencers
fences114617113fence_s
fennels10387903fennels
ferals94216643fer_als
feres86038183fer_e_s
ferrel92810203ferrel_
ferrets103111393ferrets
ferules103112723ferules
fiercely1643313fiercely
forceps14466983forceps
forcers124215713forcers
forces114422133force_s
gerbils1037303gerbils
germens1078633germens
gruels73910153_gruels
heels85625533he__els
herbals122710613herbals
hercules1337633hercules
herders113914123herders
heres86245903her_e_s
herls85226433her__ls
heroes94923823heroe_s
herpes115517323herpe_s
herself1337623herself
hirsels10128353hirsels
intercell1148163intercell
jebels15418913je_bels
jereeds15326393jereeds
jerkers18287083jerkers
jerseys1733243jerseys
jewels16508613je_wels
jurels133710583jur_els
keels94622413ke__els
kennels11387193kennels
kermes124616133kerme_s
kermess13396223kermess
kernel104010593kernel_
kernes104717533kerne_s
kerseys1433993kerseys
kevels134410713ke_vels
levels94113283le_vels
marcel103714853marcel_
marvels123810093marvels
materiels1147833materiels
mercer105214203merce_r
mercery14397623mercery
merches144013763merches
mercies113817563mercies
mercs96020453merc__s
merdes94518603merde_s
merely111312593mer_ely
meres75143573mer_e_s
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merles85322763merle_s
merls77423903mer__ls
mescals112911573mescals
mezcals20246543mezcals
morels84820023mor_els
morsels94112663morsels
nereis6315343ner_eis
nerols6914883ner_ols
nerves94216193nerve_s
newels93710823ne_wels
opercele1244593opercele
operceles1344613operceles
oriels64914623_oriels
parcel103915473parcel_
parrels94713493parrels
peaces106324083peace_s
pedicels1336253pedicels
peels75226423pe__els
pencel103812913pencel_
pencils113011773pencils
percale11314093percale
percales12313803percales
percent113520603percent
percents122713373percents
percept133112523percept
percepts14247643percepts
perchers153611523perchers
perches143717953perches
percuss1137163percuss
peres76246643per_e_s
perils84121853per_ils
perses85428063perse_s
petrels9279373petrels
piercers12316723piercers
pierces113411193pierce_s
precess11310863precess
rebels84518133re_bels
recces10614913recce_s
recess8314263re_cess
reels55333263__reels
refeels10379693refeels
refels94618053re_fels
refuels10399523refuels
reheels10298253reheels
repels84318763re_pels
rerolls739943rerolls
revels94220573re_vels
riels55121333__riels
secrets9311773secrets
seels55632823se__els
seidels838393seidels
sequels1665713sequels
serails73318363serails
seres55448893ser_e_s
sergers83815633sergers
serges74225973serge_s
serials73919753serials
series64540973serie_s
servals103410753servals
servers103214833servers
serves94423653serve_s
sorels63921163sor_els
sorrels7310723sorrels
steels64117983ste__els
stencils1046403stencils
stereos74314973ster_eos
steres63929533ster_e_s
sterlets8169273sterlets
sterols7313443ster_ols
streels73811343streels
taces76237803t_ace_s
taels56822073t__aels
tares57456563tar_e_s
targes74524593targe_s
targets84314223targets
tarres64723043tarre_s
tarsals72512603tarsals
tassels74510853tassels
teachers133212393teachers
teaches122718353teaches
teacups1133963teacups
teals56234133te__als
tearers75218233tearers
tearless848713tearless
teasel63914983teasel_
teasers75317243teasers
teases65426273tease_s
teazel15368543teazel_
teazles16308923teazles
techs106915833te_c_hs
tedders94010233tedders
teel46335803te__el_
teemers95012903teemers
teems76019783te__ems
teeners74415453teeners
teens56227483te__ens
teepees939263teepees
tees45353583te__e_s
teeters74018303teeters
telcos8710683telc_os
teles54536003te_le_s
telfers10299073telfers
tellers73717603tellers
tells55828943te__lls
telnets738373telnets
tels46841693t___els
tempehs14325153tempehs
tempers113513013tempers
temples112610893temples
tenaces92814513tenace_s
tenails73713923tenails
tenches123515523tenches
tenders83719723tenders
tenets65518953te_nets
tenners74014923tenners
tenrecs936033tenrecs
tensely1037363tensely
tenses64722553tense_s
tenters73921103tenters
tenues63816443tenue_s
tepals85415043te_pals
tepees84215243te_pees
terais64023513ter_ais
terbias9310743terbias
teredo7310783ter_edo
teredos839183teredos
terete6319333ter_ete
tergal72912833tergal_
termed94816703terme_d
termer85717253terme_r
termless1036233termless
termly1138433ter_mly
termors94712773termors
terms75523473ter__ms
terne56426153terne__
terns55226873ter__ns
terpene92310863terpene
terpenes102111573terpenes
terraces102712253terrace_s
terras63516973ter_ras
terreen7257573terreen
terreens8246533terreens
terrella844703terrella
terrellas944293terrellas
terrene72411033terrene
terrenes82212603terrenes
terret63425623terre_t
terriers84210823terriers
terries73425633terries
territs72714503territs
terrors73112213terrors
terse55026823terse__
terser67317823terse_r
tersest71713993tersest
tertials8510073tertials
testees74215913testees
testers74124543testers
testes65125823teste_s
tethers103815313tethers
tetryls1034643tetryls
tetters74320473tetters
theres96525473ther_e_s
thermals13518533thermals
thermel12569893thermel_
thermes126214613therme_s
thralls10299043thralls
threeps12687043threeps
threes97117323thr_ees
thrills10398783thrills
throes97518673throe_s
ticals83214713t_icals
tierce8339843tierce__
tierced10347053tierce_d
tincals93610643tincals
tinsels738373tinsels
tires55437493tir_e_s
tirls54519803tir__ls
torches123715443torches
torcs75123763torc__s
tores55352673tor_e_s
tories65435883torie_s
torses64727953torse_s
tortes64826053torte_s
towels94314643t_owels
tracers94917843tracers
traces85329933trace_s
trails64622513t_rails
tramels93812493tramels
travels104711293travels
trawls94412393t_rawls
treacles1039703treacles
trebles9311443trebles
treens65317873t_reens
trees55835763t_r_ees
treks96016853t_r_eks
tres46542903t_r_e_s
tress55423163t_r_ess
tressels8367653tressels
trets55928023t_r_ets
trevets10499973trevets
trews86118893t_r_ews
treys85018213t_r_eys
trials64319883t_rials
triceps11267343triceps
trices84826333trice_s
triens65417543t_riens
triers64321523t_riers
tries55742813t_rie_s
trills64319853t_rills
triols66117803t_riols
trolls64613943t_rolls
trowels10358363trowels
truces84916333truce_s
trues54925323t_rue_s
trulls64110283t_rulls
tubercles1344153tubercles
tunnels7328723tunnels
tureens7289873tureens
turkeys1434523turkeys
turners73912893turners
turrets73010673turrets
turtles72914343turtles
turves94212693turve_s
tyres84725233tyr_e_s
unreels7258313unreels
verbals121910743verbals
vergers114412633vergers
verges104320183verge_s
vermeils1374813vermeils
vermes115019143verme_s
versers103813523versers
verses94223763verse_s
versets103913103versets
verves124617883verve_s
vervets13419753vervets
vessels1035933vessels
weasels10468503weasels
wedels103811033we_dels
wergeld1233183wergeld
wergelds1342293wergelds
wergelt1138583wergelt
wergelts1253413wergelts
wurzels1934083wurzels
zeroes154314343zeroe_s

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 Limit1340273996.19021652.2
3Display Results3993990.1402850.0
 (SQL Overall)1786913996.73626527.8
 
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.