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

513 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
terrets7291358(None) 
ferrets103111391ferrets
tercets93512441tercets
terret63425621terret_
territs72714501territs
turrets73010671turrets
barrets94917112barrets
befrets1237612befrets
berets85822532be_rets
cermets1139712cermets
egrets72712242_egrets
ferrels10248622ferrels
ferret93021172ferret_
ferrety13287012ferrety
garrets84413622garrets
regrets83212922regrets
secrets9311772secrets
sterlets8169272sterlets
targets84314222targets
tarres64723042tarre_s
tearers75218232tearers
telnets738372telnets
tenets65518952te_nets
tenrecs936032tenrecs
tercels94110362tercels
terces83921412terce_s
tercet83624912tercet_
terete6319332te_rete
termers95414502termers
ternes65422902terne_s
terras63516972terr_as
terreen7257572terreen
terreens8246532terreens
terrene72411032terrene
terrenes82212602terrenes
terriers84210822terriers
terries73425632terries
territ63421382territ_
terrors73112212terrors
tersest71713992tersest
torrents838142torrents
trets55928022t__rets
trevets10499982trevets
turret63121852turret_
versets103913102versets
vervets13419752vervets
aerates74627503aerates
aeries64737783aerie_s
aeriest73924053aeriest
afreets1037023afreets
aigrets82810543aigrets
armets84918353_armets
arrest63722633_arrest
arrests73312693_arrests
barbets114915853barbets
barrels94514363barrels
barrens94414323barrens
barres84427553barre_s
barret84930493barret_
bearers94619593bearers
beckets15399823beckets
beets76131443be__ets
befret11315963befret_
begets96215523be_gets
bennets94712163bennets
berates94126883berates
beret74946363be_ret_
bermes106023003berme_s
berretta1044803berretta
berrettas1143853berrettas
berries94423553berries
besets85718803be_sets
brevets12519413brevets
burets84321273_burets
burnets93813263burnets
burrers93814493burrers
carets85330773_carets
carnets93918403carnets
carpets113915333carpets
carrels95117303carrels
carrots9714623carrots
cerates95428253cerates
ceres75540013ce_re_s
cereus85215523ce_reus
cerites94823433cerites
cermet10321153cermet_
certes84623083certe_s
chevrets16255323chevrets
clarets94111103clarets
cornets94820573cornets
corrects1259573corrects
corsets94819803corsets
corvets124715023corvets
cruets85314953_cruets
curets84922343_curets
currents1038373currents
curvets12399913curvets
dearest83618673dearest
decrees102513123decrees
deets65330243de__ets
degrees92810723degrees
depress10239873depress
derates84028893derates
derats74625063de_rats
derries83124623derries
derris73615273derr_is
deserts82513053deserts
deterrents11126473deterrents
deterrers10116593deterrers
ebbets10376843_ebbets
eeriest73620673eeriest
egress73310433_egress
egret63327313_egret_
emmets10349153_emmets
erects84116183_erects
ergots74512373_ergots
ernes55224813_erne_s
errants7410643_errants
errata639013_errata
erratas736863_erratas
erred65915673_erre_d
errors63311313_errors
errs45622533_err__s
erses55826803_erse_s
eructs83610793_eructs
erupts8348903_erupts
everts94514893_everts
exerts133712293_exerts
eyres84921773_eyre_s
fearers104815273fearers
feres86038183fe_re_s
ferments13311473ferments
ferrate103014043ferrate
ferrates113013423ferrates
ferrel92810203ferre_l
ferreous1146043ferreous
ferreted1236333ferreted
ferreter1136543ferreter
ferreters1246253ferreters
ferries103521083ferries
ferrite103312753ferrite
ferrites112312833ferrites
ferrous1049803ferrous
ferrums1265983ferrums
florets1039853florets
forgets113813793forgets
freres94716173frere_s
frets85523403__frets
gargets94614573gargets
garnets84115413garnets
garret74426563garret_
genets75716663ge_nets
genres75515623genre_s
gerents82612923gerents
germens1078633germens
gorgets94711783gorgets
greets75117423_greets
gurnets84010793gurnets
hearers104319783hearers
hearts96218943hear_ts
heiress1036813heiress
helmets12309073helmets
herders113914123herders
heres86245903he_re_s
hereto9313693he_reto
heriots10312063heriots
hermits12312143hermits
heroes94923833heroe_s
herpes115517323herpe_s
herries104025083herries
hornets104113553hornets
imarets9138643imarets
interprets1249333interprets
iterates81317823iterates
jeerers14328923jeerers
jennets14517633jennets
jereeds15326393jereeds
jerkers18287083jerkers
jerreed1535213jerreed
jerreeds1653273jerreeds
jerrids15277743jerrids
jerries143817513jerries
jerseys1733243jerseys
keets95123483ke__ets
keiretsu1241293keiretsu
kermes124616143kerme_s
kermess13396223kermess
kernels11417953kernels
kernes104717533kerne_s
kerrias11289513kerrias
kerries113317913kerries
kerseys1433993kerseys
keysets1434343keysets
labrets939373labrets
leets54927123le__ets
leverets11297603leverets
markets133314033markets
marrers93414313marrers
meets74224613me__ets
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
meres75143573me_re_s
merest84725113me_rest
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merits8320873me_rits
merles85322763merle_s
merlots92710123merlots
merriest10311483merriest
metres85121563metre_s
murres85019043murre_s
murreys12367323murreys
nearest73415843nearest
nereis6315343ne_reis
nerts55924983ne_r_ts
nerves94216193nerve_s
overbets132510683overbets
overlets112312363overlets
oversets113114173oversets
overwets14219953overwets
pargets105215193pargets
parrels94713493parrels
parrots9312743parrots
peeress939503peeress
pellets94014783pellets
pelmets11309693pelmets
percents122713373percents
percepts14247643percepts
peres76246643pe_re_s
perfects15107353perfects
permits11314003permits
perpents122312043perpents
perries93226603perries
perrons93115483perrons
perses85428063perse_s
pertest9317043pertest
perverts1337533perverts
petrels9279373petrels
pierrots1044963pierrots
presets94216423presets
rearers74323563rearers
rearrest8311603rearrest
rearrests945313rearrests
redress82511873redress
reerects10319923reerects
reflets103513153reflets
reglets83512983reglets
regreets9287853regreets
regress82711453regress
regret73723533regret_
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
repress92712683repress
rerents73319423rerents
resets65427613re_sets
retreats8311423retreats
rets45352563___rets
reverts104715053reverts
revets94022183re_vets
rewets94617213re_wets
searest73322023searest
secret8325063secret_
secrete9311073secrete
secretes10410473secretes
seeress7311573seeress
sennets73712583sennets
septets998953septets
seres55448893se_re_s
serest64831613se_rest
sergers83815633sergers
serges74225973serge_s
series64540973serie_s
serpents102410373serpents
serrate73017543serrate
serrates82617023serrates
serries73925353serries
servers103214833servers
serves94423653serve_s
sestets7911473sestets
sextets1497143sextets
sherbets1335213sherbets
sirrees73410573sirrees
skirrets12244013skirrets
sorbets93012513sorbets
sorrels7310723sorrels
starets73515923starets
starlets81610083starlets
steerers82511353steerers
stereos74314973ste_reos
steres63929533ste_re_s
sterlet71318473sterlet_
sternest8314433sternest
stirrers8266943stirrers
streets73312623streets
surreys10489443surreys
tabarets10287243tabarets
tablets94714383tablets
taborets10278073taborets
tackets134914363tackets
tanrecs934823tanrecs
tappets113610013tappets
tares57456563t_are_s
targes74524603targe_s
target75028913target_
tarots66422993t_arots
tarre55825633tarre__
tarred74720283tarre_d
tarriers83411713tarriers
tarries73324263tarries
tarriest83215003tarriest
tartest72517533tartest
tartlets8289663tartlets
tarts57242023t_ar_ts
tassets75012773tassets
teapots939053teapots
teared75722153teare_d
tearer64822903teare_r
teargas837013teargas
teariest82417263teariest
tearless848713tearless
tears55436463tear__s
teasels74311313teasels
teasers75317243teasers
teases65426273tease_s
teats55636813te__ats
teazels16406893teazels
tedders94010233tedders
teels55726373te__els
teemers95012903teemers
teems76019783te__ems
teeners74415453teeners
teens56227483te__ens
teepees939263teepees
tees45353583te__e_s
teeters74018303teeters
teeth87315853te__eth
teles54536003te_le_s
telfers10299083telfers
tellers73717613tellers
telnet6518833telnet_
tempehs14325153tempehs
tempers113513013tempers
tempest1139223tempest
tempests1234443tempests
templets12226143templets
tempts10439453te_mpts
tenants7311013tenants
tenders83719723tenders
tenet55542213te_net_
tenners74014923tenners
tenrec837513tenre_c
tenses64722553tense_s
tensest72713313tensest
tenters73921113tenters
tents56434213te__nts
tenues63816443tenue_s
tenures7412013tenure_s
tepees84215243te_pees
terais64023513te_rais
terbias9310743terbias
terce75721843terce__
tercel83612993terce_l
tercelets1144813tercelets
teredo7310783te_redo
teredos839183teredos
tergite8311003tergite
tergites9310543tergites
termed94816703terme_d
termer85717253terme_r
termite9313893termite
termites10313693termites
termless1036233termless
termors94712773termors
terms75523473te_r_ms
ternate7415483ternate
terne56426153terne__
terns55226873te_r_ns
terpene92310863terpene
terpenes102111573terpenes
terra54419673terr__a
terrace93311843terrace
terraces102712253terraces
terrae62915213terr_ae
terrain7410853terrain
terrains8410323terrains
terrane72814233terrane
terranes82514433terranes
terrases82111483terrases
terrella844703terrella
terrellas944293terrellas
terrier73414963terrier
terrify1336353terrify
terrine72517573terrine
terrines82117553terrines
terror63811733terr_or
terry84721873terr__y
terse55026823terse__
tersely1038113tersely
terser67317823terse_r
testees74215913testees
testers74124543testers
testes65125823teste_s
tests56530193te__sts
tethers103815313tethers
tetrads82910193tetrads
tetras63017623tetr_as
tetris62816293tetr_is
tetryls1034643tetryls
tets45847463t___ets
tetters74320473tetters
texts125515043te__xts
theorems1344693theorems
theres96525473there_s
thereto1038993thereto
thermels13607763thermels
thermes126214613therme_s
thermits1338513thermits
thirsts1036243thirsts
threats104311683threats
threeps12687043threeps
threes97117323t_hrees
thrifts1335523thrifts
throats104612193throats
throes97518673throe_s
thrusts10226523thrusts
tickets134113683tickets
tiercels10344753tiercels
tierces93710453tierce_s
tigress836093tigress
tippets11339373tippets
tires55437493t_ire_s
titres64718933titre_s
toilets74112913toilets
tonlets73212503tonlets
toquets16367863toquets
toreros7311343toreros
tores55352673t_ore_s
tories65435883torie_s
torments10310453torments
torrefy1353353torrefy
torrent7313413torrent
torrs53923563torr__s
torses64727953torse_s
tortes64826053torte_s
torts56138123t_or_ts
tourers73512743tourers
tracts85019073t_racts
traits65121983t_raits
treats64821703t_reats
treens65317873t_reens
trees55835763t__rees
treks96016853t__reks
tres46542903t__re_s
tress55423163t__ress
tret46653533t__ret_
trevet94818913trevet_
trews86118893t__rews
treys85018213t__reys
triens65417543t_riens
triers64321523t_riers
tries55742813t_rie_s
trijets14308263trijets
trivets103911583trivets
trots56629943t__rots
trouts66116633t_routs
trues54925323t_rue_s
truest64816193t_ruest
trusts64714433t_rusts
trysts9448793t_rysts
tsores65113663tsore_s
tuckets134810333tuckets
tuffets13266523tuffets
turbeth1274713turbeth
turbeths1373353turbeths
turbits969233turbits
turbots988023turbots
tureens7289873tureens
turkeys1434523turkeys
turners73912893turners
turpeth1284813turpeth
turpeths1373153turpeths
turreted935373turreted
turves94212693turve_s
tweets94210103t_weets
tyrants1037453tyrants
tyres84725233t_yre_s
varlets10411573varlets
velvets13326693velvets
vergers114412633vergers
verges104320183verge_s
veriest103719133veriest
verists103613673verists
verites103822263verites
vermes115019143verme_s
versers103813523versers
verses94223763verse_s
verset94327323verset_
verstes104014283verstes
versts93914733ve_rsts
verts85724733ve_r_ts
verves124617883verve_s
vervet124619063vervet_
warrens103810893warrens
waterjets1944463waterjets
wearers104615903wearers
weets85427723we__ets
wergelts1253413wergelts
worrits10258683worrits
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.406440125.6
2DLD Change Limit1340275136.93619323.4
3Display Results5135130.1862758.1
 (SQL Overall)1786915137.52823736.8
 
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.