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

350 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
secerns98773(None) 
decerns10119051decerns
secern81010221secern_
decern91310952decern_
lecterns1035942lecterns
lucerns935752lucerns
scorns85713022s_corns
secedes103711982secedes
secerned1136102secerned
secrets9311772secrets
secures9613162secures
seders74420282seder_s
seers55136382se_er_s
semens84616962seme_ns
sereins73716112sereins
sevens93813662seve_ns
severs94121122sever_s
sewers94719712sewer_s
sterns64616762s_terns
acorns85013013_acorns
beckons15279143beckons
beers75628393be_er_s
bemeans1148733bemeans
bicorns11338763bicorns
carns75937563__carns
caserns94711223caserns
caverns124510253caverns
ceders93817673ceder_s
ceres75540013__ceres
ceros74726073__ceros
ciceros1158583ciceros
concerns122710833concerns
corns76034763__corns
curns74924273__curns
decares102818533decares
deceits102810883deceits
decent94023703dece_nt
decerned1237263decerned
deckers144413833decker_s
decors94017773decor_s
decrees102513123decrees
deers64930523de_er_s
defers105116943defer_s
degerms1135623degerms
dehorns11428363dehorns
deicers103612733deicer_s
demeans1039713demeans
deperms1236603deperms
deserts82513053deserts
deters74724683deter_s
deveins1138803deveins
dicers94720743dicer_s
discerns1138163discerns
earns55927563_e_arns
ecesis84611203_ecesis
ecrus75113863_ec_rus
egers65120373_eger_s
erns45428223___erns
escarps11397373escarps
escars83913133escar_s
escorts9418403escorts
eskers105312223esker_s
esters64627733ester_s
eterne6311723_eterne
evens84817103_eve_ns
everts94514893_everts
ewers86018823_ewer_s
exerts133712293_exerts
externs1438233externs
eyers86521333_eyer_s
facers115519443facer_s
feces105625363fece__s
fencers123810623fencer_s
ferns85220083__ferns
fevers125414893fever_s
governs1136103governs
heders104119763heder_s
herns84825583__herns
heteros10312683heteros
hewers123715273hewer_s
hexers165612753hexer_s
interns73116773interns
jeers124818133je_er_s
keens95721183ke_e_ns
kerns94719563__kerns
lacers85225253lacer_s
learns65513743le_arns
lebens8310093lebe_ns
lechers123313963lecher_s
lectern937033lectern_
lectins92515003lectins
leers54828983le_er_s
legers74518313leger_s
lepers84817323leper_s
levers94621323lever_s
lucern846103lucern_
lucerne945753lucerne
lucernes1046363lucernes
macers105321273macer_s
mercers114412773mercer_s
meters85625833meter_s
moderns1037963moderns
neckers134210463necker_s
oceans81211003_oceans
orceins937743orceins
pacers105124543pacer_s
pecans101515833pec_ans
pechans14810503pechans
peckers153312673pecker_s
pectens11189203pectens
pectins112315233pectins
peens76428193pe_e_ns
peers75130273pe_er_s
pereons92815003pereons
peters86624593peter_s
piecers114112253piecer_s
querns15307943_querns
racers84725433racer_s
recedes102816063recedes
recent83630853rece_nt
recepts113010263recepts
recess8314263rece_ss
reckons13269653reckons
recleans1037513recleans
recoins94019243recoins
recons84922993rec_ons
records105213923records
recorks134813023recorks
recurs83315803recur_s
reearns749103reearns
refers93921083refer_s
relearns836303relearns
reperks13298093reperks
returns79712593returns
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
reverts104715043reverts
rezeros1647453rezeros
ricers84120993ricer_s
sabers85224733saber_s
sackers133820223sacker_s
sakers104125433saker_s
salterns8388903salterns
sateens73710753sateens
saucers93712133saucer_s
savers93825923saver_s
sawers94620163sawer_s
sayers94221593sayer_s
scans74625103s_c_ans
scares85033003s_cares
scarfs114714683s_carfs
scarps104718603s_carps
scars75433533s_car_s
scarts85321493s_carts
scena74815783s_ce_na
scenas84114703s_cenas
scend85516293s_ce_nd
scends95213003s_cends
scene77220573s_ce_ne
scenes84520353s_cenes
scent75831623s_ce_nt
scents85317023s_cents
scions82612243s_cions
scleras948223scleras
scores84725923s_cores
scorn75817443s_corn_
screens95212173screens
screes85023963s_crees
screws115513883s_crews
scurfs113210813s_curfs
sealers74323553sealer_s
seamers94719433seamer_s
sears54744913se_ar_s
seasons72614233seasons
seaters74028943seater_s
seawans10379943seawans
secant84023293sec_ant
secants93413893secants
seccos1039923sec_cos
secede93311993sece_de
seceded11319203seceded
seceder10329573seceder
seceders11277963seceders
seceding12288563seceding
secerning1246203secerning
second9411153sec_ond
seconds1038283seconds
secpars1138413secpars
secrecy1444743secrecy
secret8325063sec_ret
secrete9311073secrete
secretes10410473secretes
secretins11108463secretins
secs65033893sec___s
sections102714703sections
sectors93116443sectors
sects75622893sec__ts
secund937103sec_und
secure8513533secur_e
secured1059723secured
securer958253securer
securers1057153securers
securest1058583securest
securing11310413securing
sedans74816093se_dans
seder64826753seder__
sederunt945983sederunt
sederunts1043063sederunts
seducers1145383seducer_s
seeders83017113seeder_s
seeds64330063se_e_ds
seeing74222143se_eing
seeings84411293se_eings
seekers113712333seeker_s
seeks94724643se_e_ks
seels55632823se_e_ls
seemers93814333seemer_s
seems75525023se_e_ms
seen46943123se_e_n_
seeps74828753se_e_ps
seer45547043se_er__
seeress7311573se_eress
sees45361053se_e__s
seiners74219273seiner_s
seisers73816393seiser_s
seisins73614393seisins
seitans73312303seitans
seizers164112503seizer_s
seizins164010133seizins
sejeant1489723sejeant
selects91912143selects
sellers73721313seller_s
selsyns1092943selsyns
sememes11109203sememes
semen75724103seme_n_
semes75731583seme__s
senders83022353sender_s
senecas939013senecas
senegas837253senegas
senoras72714953senoras
senores73218113senores
senors63620783senor_s
sequins1637863sequins
serein63318463serein_
serene63522353sere_ne
serenes73222903serenes
serer55935503serer__
seres55448893s__eres
serfs84922013s__erfs
sergers83815633serger_s
serins64029673se_rins
sermons9311783sermons
sers45746653s__er_s
servers103214833server_s
setons64620173se_tons
setters73822063setter_s
seven84118313seve_n_
sever85426053sever__
several1039533several
severals1137593severals
severe94016083sever_e
severed113513863severed
severer103511563severer
severest11310323severest
severing122013853severing
sewans95215903se_wans
sewars94018623sewar_s
sewer84426213sewer__
sewered112911243sewered
sewering122411093sewering
sexes126126223sexe__s
sextans14349263sextans
sextons143710413sextons
shairns10276783shairns
sharns95516983s_harns
shebeans1344703shebeans
shebeens1343333shebeens
sheens95116993s_heens
sheers94322403sheer_s
sherds105614723s_herds
shewers134312043shewer_s
shiers94921753shier_s
shoers94518333shoer_s
shyers124712203shyer_s
sices75637273sice__s
sickens134411483sickens
siemens938413sieme_ns
sieverts1145713sieverts
sirens65318153sire_ns
sivers95324153siver_s
sizers155215813sizer_s
skeans104512913s_keans
skeens103912913s_keens
skeins103911903s_keins
skewers14498373skewer_s
skiers104713703skier_s
slicers94114923slicer_s
smerks12449713s_merks
sneers64016173sneer_s
sobers85218863sober_s
soccers1138393soccer_s
sorns55028423s__orns
sowens93613153sowe_ns
sowers94923443sower_s
spacers113813873spacer_s
speans85417143s_peans
specters122811063specter_s
spectres12268683spectres
speers85019953speer_s
spencers12269193spencer_s
sperms102512603s_perms
spewers124210653spewer_s
spheres123114353spheres
spicers113815553spicer_s
spiers84421743spier_s
spleens937103spleens
spurns84811383s_purns
steers63820983steer_s
steins64818343s_teins
steres63929533s_teres
stern55319123s_tern_
sterna63712763s_terna
suberins10315093suberins
subers85722643suber_s
suborns939493suborns
suckers133717623sucker_s
sucres84218893suc_res
suers55128483s_uer_s
supers84622403super_s
swevens1334613sweve_ns
sycees11409653syce_es
syces106416463syce__s
syrens94911993syre_ns
taverns10317803taverns
teens56227483te_e_ns
telerans859473telerans
terns55226873__terns
ulcers839383ulcer_s
veers84521363ve_er_s
veterans1148853veterans
vexers165210403vexer_s
webers11310943weber_s
wedelns11325243wedelns
weens85224053we_e_ns
westerns11328963westerns
wiverns13366963wiverns
wyverns16363013wyverns
yearns9509543ye_arns
zechins21137123zechins

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.1561145455.1
2DLD Change Limit1340273506.37321030.4
3Display Results3503500.1262777.8
 (SQL Overall)1786913506.65526850.6
 
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.