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

529 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
secrets931177(None) 
secret8325061secret_
secrete9311071secrete
secretes10410471secretes
beckets15399822beckets
befrets1237612befrets
berets85822522be_rets
decrees102513122decrees
egrets72712242_egrets
ferrets103111392ferrets
regrets83212922regrets
sachets123914102sachets
screes85023962s_crees
screws115513882s_crews
searest73322022searest
secants93413892secants
secerns987732secerns
secrecy1444742secrecy
secreted1138632secreted
secreter1038502secreter
secretest1147032secretest
secretin10108342secretin
secretins11108462secretins
secretly1345182secretly
secretor1045672secretor
secretors1145832secretors
sects75622892sec__ts
securers1057152securers
secures9613162secure_s
securest1058582securest
seeress7311572seeress
sennets73712582sennets
septets998952septets
seres55448892se_re_s
serest64831612se_rest
sestets7911472sestets
sextets1497142sextets
sockets134012982sockets
starets73515922starets
sucres84218892sucre_s
tercets93512442tercets
terrets72913582terrets
accrete1137843accrete
accretes1238113accretes
acres76327763_acre_s
aigrets82810533aigrets
ancress978613ancress
barrets94917103barrets
bearers94619593bearers
becarpets1542913becarpets
becket144619883becket_
becrust1137983becrust
becrusts1244843becrusts
beets76131443be__ets
befret11315963befret_
begets96215523be_gets
bennets94712163bennets
beret74946363be_ret_
besets85718803be_sets
buckets153811693buckets
burets84321263_burets
cachets145014263cachets
carets85330773_carets
ceres75540013ce_re_s
cereus85215523ce_reus
cermets1139713cermets
certes84623083ce_rtes
chevrets16255323chevrets
clarets94111103clarets
creds85418773__creds
cress75022833__cress
crest74632693__crest
crests85218703__crests
crews105917493__crews
crits75527573__crits
cruets85314953__cruets
curets84922343_curets
dearest83618673dearest
decants103514443decants
decares102818533decare_s
deceits102810883deceits
decerns10119053decerns
deckels14367363deckels
deckers144413833deckers
decocts1237833decocts
decrease1136563decrease
decree93117783decre_e
decreed112710253decreed
decreer10269123decreer
decreers11277623decreers
decretal1146353decretal
decretals1245093decretals
decriers11299733decriers
decries103319803decries
decrypts1642943decrypts
deets65330243de__ets
degrees92810723degrees
depress10239873depress
derats74625063de_rats
deserts82513053deserts
dockets144412243dockets
ebbets10376833_ebbets
ecartes94212563_ecartes
eches106322163_eche_s
eclats8313033_eclats
ecrus75113863_ecr_us
egress73310433_egress
egret63327313_egret_
electrets1146543electrets
emmets10349153_emmets
erects84116183_e_rects
escheats1346253escheats
eschews1534553eschews
escorts9418403escorts
escots84211743esc_ots
escrows1235803escrows
esprits938393esprits
estreats839423estreats
everts94514893_everts
excreta1674623excreta
excrete1667163excrete
excretes1787573excretes
exerts133712293_exerts
eyres84921773_eyre_s
facets116316653fac_ets
fearers104815273fearers
feces105625363fec_e_s
feres86038183fe_re_s
ferrels10248623ferrels
ferret93021173ferret_
ferrety13287013ferrety
florets1039853florets
frets85523403__frets
garrets84413623garrets
genets75716663ge_nets
genres75515623genre_s
gerents82612923ge_rents
hearers104319783hearers
hearts96218943hear_ts
heiress1036813heiress
helmets12309073helmets
heres86245903he_re_s
hereto9313693he_reto
imarets9138643imarets
jackets205011373jackets
jeerers14328923jeerers
jennets14517633jennets
keets95123483ke__ets
keiretsu1241293keiretsu
keysets1434343keysets
labrets939363labrets
lechers123313963lechers
leches115421313leche_s
leets54927123le__ets
leverets11297603leverets
lockets134612203lockets
lucres84513303lucre_s
meets74224613me__ets
mercers114412773mercers
merces105720743merce_s
meres75143573me_re_s
merest84725113me_rest
merits8320873me_rits
metres85121563metre_s
nacres85614453nacre_s
nearest73415843nearest
neckers134210463neckers
nereis6315343ne_reis
nerts55924983ne_r_ts
nonsecrets1285293nonsecrets
octets839403_octets
packets155114773packets
peckers153312673peckers
pectens11189203pectens
peeress939503peeress
pellets94014783pellets
pelmets11309693pelmets
percents122713373percents
percepts14247643percepts
peres76246643pe_re_s
petrels9279373petrels
pickets154314183pickets
pockets154612253pockets
rachets124516833rachets
rackets134916873rackets
rearers74323563rearers
recants93217093recants
recarpets1344383recarpets
recasts93413533recasts
recces10614913recce_s
recepts113010263recepts
recess8314263rec_ess
recheats1339193recheats
rechews1537293rechews
recites93524583recites
recits83621353rec_its
recoats92616643recoats
recrate92621663recrate
recrates102420373recrates
recreants1146623recreants
recreate10313603recreate
recreates11313363recreates
recross989833recross
recruits1036563recruits
recuts83817373rec_uts
redress82511873redress
reerects10319923reerects
reflets103513153reflets
reglets83512983reglets
regreets9287853regreets
regress82711453regress
regret73723533regret_
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
repress92712683repress
rerents73319423re_rents
resets65427613re_sets
retreats8311413retreats
rets45352563___rets
reverts104715043reverts
revets94022173re_vets
rewets94617213re_wets
rickets134915093rickets
rochets124213473rochets
rockets134615363rockets
sabres85520863sabre_s
sacbuts1166473sacbuts
sachems14348903sachems
sachet114725773sachet_
sackers133820223sackers
sacrals93311793sacrals
sacred94917103sacre_d
sacrist9315423sacrist
sacrists1039563sacrists
sacrums11388043sacrums
sallets73719653sallets
samlets93813553samlets
sarees65329943s_arees
saurels749303saurels
scants85219723s_cants
scarers94618503scarers
scares85033003scare_s
scarlets10178573scarlets
scarts85321493s_carts
scats75930603s_c_ats
scatts85914663s_catts
scenes84520353scene_s
scents85317023s_cents
scoots85315943s_coots
scorers94115313scorers
scores84725923score_s
scots74025913s_c_ots
scouts84817943s_couts
scrags95713803s_crags
scrams105216623s_crams
scraps106017243s_craps
screak125311053s_creak
screaks13469353s_creaks
scream104814243s_cream
screams114810613s_creams
scree720031703s_cre_e
screed95718923s_creed
screeds106210283s_creeds
screen85216013s_creen
screens95212173s_creens
screw109318533s_cre_w
screwy14659453s_crewy
scries85226823s_cries
scrims104615933s_crims
scrips105316033s_crips
scripts11509373s_cripts
scrods94111603s_crods
scrota8310193s_crota
scrubs104210313s_crubs
scrums104614253s_crums
scutes85219193s_cutes
scuts74522523s_c_uts
seabeds10417223seabeds
seacrafts1443703seacrafts
sealers74323553sealers
seamers94719433seamers
seared75232843seare_d
searer65432023seare_r
sears54744913sear__s
seaters74028943seaters
seats54844343se__ats
secant84023293secant_
seccos1039923sec_cos
secede93311993sec_ede
seceders11277963seceders
secedes103711983secedes
secern81010223sec_ern
seconds1038283seconds
secpars1138413secpars
secrecies1346913secrecies
secretary1444193secretary
secreting1279823secreting
secretion11118293secretion
secretions12117843secretions
secretive1446933secretive
secretory1444593secretory
secs65033893sec___s
sect67443623sec__t_
sectors93116443sectors
secure8513533secure__
secured1059723secure_d
securely1345073securely
securer958253secure_r
security1346693security
sedates83418033sedates
seders74420283se_ders
sedges83817803sedge_s
seeders83017113seeders
seeds64330063se__eds
seekers113712333seekers
seeks94724643se__eks
seels55632823se__els
seemers93814333seemers
seems75525023se__ems
seeps74828753se__eps
seers55136383se__ers
sees45361053se__e_s
segments1138903segments
segues7412073segue_s
seiches12513813seiche_s
seidels838393seidels
seiners74219273seiners
seines65029903seine_s
seisers73816393seisers
seises64026713seise_s
seizers164112503seizers
seizes154317533seize_s
selects91912143selects
sellers73721313sellers
selles64426983selle_s
selves94119613selve_s
semens84616963se_mens
semes75731583se_me_s
senates73322583senates
senders83022353senders
sennet64224143sennet_
sennits73811283sennits
senores73218113senore_s
senseis73310643senseis
senses63923943sense_s
sepses84515883sepse_s
septet8921133septet_
septs75420603se__pts
sequels1665703sequels
sequents1756993sequents
seracs84418573se_racs
serais64326133se_rais
sere46153473se_re__
sered65737293se_re_d
serein63318463se_rein
sereins73716113se_reins
serene63522353se_rene
serenes73222903se_renes
serer55935503se_re_r
serfs84922013se_r_fs
sergers83815633sergers
serges74225963se_rges
series64540973se_ries
serifs94017053se_rifs
serins64029673se_rins
serous65023563se_rous
serows96016393se_rows
serpents102410373serpents
serrate73017543serrate
serrates82617023serrates
serries73925353serries
sers45746653se_r__s
serums83916303se_rums
servers103214833servers
serves94423653se_rves
servos93812723se_rvos
sestet6826203sestet_
setouts74110333setouts
sets45549503s___ets
setscrews1441443setscrews
settees73513633settees
setters73822063setters
setts55124323se__tts
sevens93813663se_vens
severest11310323severest
severs94121123se_vers
sewers94719713se_wers
sexes126126223se_xe_s
sexiest142112223sexiest
sexists14267673sexists
sexless1467243sexless
sexpots1636293sexpots
sextet13916873sextet_
sexts125118383se__xts
sharers104720623sharers
shares95236413share_s
shearers113911323shearers
sheerest11310083sheerest
sheets93918503s_heets
sherbets1335213sherbets
shires95225573shire_s
shirts94918343shir_ts
shores94830413shore_s
shorts95321743shor_ts
shreds105613053s_hreds
shrews129313913s_hrews
sices75637273sic_e_s
sickees134514213sickees
sickens134411483sickens
sickest131813793sickest
sieverts1145713sieverts
signets83311503signets
sippets113310183sippets
sirees64624583s_irees
sirens65318153s_irens
sires55945373s_ire_s
sirrees73410573sirrees
skeets104513253s_keets
skirrets12244013skirrets
skirts104111503skir_ts
skorts104211303skor_ts
sleets64318873s_leets
smarts86218003smar_ts
smearers10308623smearers
snarers74216663snarers
snares65329033snare_s
sneerers8309803sneerers
snorers74313803snorers
snores64324323snore_s
snorts64116503snor_ts
soarers74118093soarers
soccers1138393soccers
society1236083society
socket123923523socket_
socles8418453socle_s
soirees72411643soirees
solerets839693solerets
sonnets74211993sonnets
sorbets93012513sorbets
sorels63921163s_orels
sores55454283s_ore_s
sorest65028003s_orest
sorrels7310723sorrels
sorts54536663s_or_ts
sourest7515713sourest
soviets1087293soviets
sparers94519613sparers
spares84834553spare_s
sparest94616423sparest
spearers103711143spearers
species11314133specie_s
specters122811063specters
spectres12268683spectre_s
spinets94714813spinets
spireas94412513spireas
spirems11499563spirems
spires84628113spire_s
spirits94112623spirits
spirts85317133spir_ts
spores84726613spore_s
sports84619183spor_ts
sprats85819933s_prats
sprees85620643s_prees
sprits85122533s_prits
spurts84814973spur_ts
starers74522313starers
stares66038753stare_s
starlets81610083starlets
starts65423123star_ts
steerers82511353steerers
stereos74314973stereos
steres63929533stere_s
sterlets8169273sterlets
stets55423913s__tets
storers75018683storers
stores65533663store_s
storeys10559653storeys
streets73312613streets
streps86218063s_treps
stress66616673s_tress
strews96817093s_trews
struts65616803s_truts
sturts63915143stur_ts
stylets10369213stylets
sublets92616703sublets
subnets92512083subnets
subrents10310293subrents
subsets92813103subsets
success1146403success
suckers133717623suckers
sucre75019103sucre__
suets55126103s__uets
sunkets113511283sunkets
sunsets72911573sunsets
surest65026763s_urest
surety93515013s_urety
surreys10489443surreys
swearers11328583swearers
sweets94214433s_weets
swivets13436963swivets
sycees11409653syc_ees
syces106416463syc_e_s
syndets1136113syndets
syrens94911993s_yrens
tackets134914363tackets
tearers75218233tearers
telnets738373telnets
tenets65518953te_nets
tenrecs936033tenrecs
tercels94110363tercels
terces83921413terce_s
tercet83624913tercet_
terete6319333te_rete
terret63425623terret_
territs72714503territs
tickets134113683tickets
trets55928023__trets
tuckets134810333tuckets
turrets73010673turrets
velvets13326693velvets
versets103913103versets
versts93914733ve_rsts
verts85724733ve_r_ts
vervets13419753vervets
wearers104615903wearers
wechts1446253wec_hts
weets85427723we__ets
wickets164010943wickets

Search took 9 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 Limit1340275297.81317154.4
3Display Results5295290.1862844.1
 (SQL Overall)1786915298.40521260.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.