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

464 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
secants9341389(None) 
decants103514441decants
recants93217091recants
scants85219721s_cants
secant84023291secant_
bezants1877342bezants
cants77036942__cants
cosecants1346532cosecants
decanes103118912decanes
decant93524222decant_
descants112910142descants
exsecants1893402exsecants
gelants82611442gelants
incants92012802incants
levants1037722levants
pecans101515832pecan_s
pedants10310112pedants
recanes93222262recanes
recant83228682recant_
recasts93413532recasts
savants1038652savants
scans74625102s_can_s
scant79735072s_cant_
scanty114014662s_canty
scarts85321492s_carts
scats75930602s_ca_ts
scatts85914662s_catts
scents85317022s_cents
sealants82610742sealants
seats54844342se_a_ts
seawants11337972seawants
secantly1345982secantly
seconds1038282seconds
secrets9311772secrets
sects75622892sec__ts
sedans74816092sedan_s
sejant133114482sejant_
servants1137992servants
sewans95215902sewan_s
sextants15287382sextants
slants64819082s_lants
sonants7511232sonants
tenants7311012tenants
accents113511233accents
alants67722023_alants
ants47243473___ants
ascents93812553ascents
ashcans1235183ashcan_s
beanos85516513be_anos
beans75734693be_an_s
beasts84519723be_asts
beats76042243be_a_ts
beauts86015283be_auts
becalms1335743becalms
becaps123811403beca_ps
beckets15399823beckets
bents76033693be__nts
bepaints1235113bepaints
bezant17814543bezant_
bezzants1843643bezzants
brants85723053_brants
byzants2153223byzants
canes75350373__canes
cans65050843__can_s
canst74932213__canst
cant66362023__cant_
canto74931013__canto
cantos84826973__cantos
cantus85117763__cantus
canty105226803__canty
carts78946293__carts
casts77237793__casts
cats66356343__ca_ts
cements112714223cements
cents74730333__cents
cetanes9315133cetanes
chants115020393_chants
cosecant12410683cosecant_
cunts76125123__cunts
deans66131393de_an_s
decadents1346393decadents
decades113615503decades
decafs124010883deca_fs
decals93717713deca_ls
decamps1435643decamps
decanal1038113decanal
decane93818873decan_e
decanted122310493decanted
decanter112510793decanter
decanters12229223decanters
decares102818533decares
decays124612913deca_ys
deceits102810883deceits
decent94023703decent_
decocts1237833decocts
dedans85915073dedan_s
defangs1235363defangs
defats105114553defa_ts
demands114311413demands
demasts1089223demasts
dements103016623dements
dents65031803de__nts
depaints1136643depaints
departs104310683departs
derats74625063dera_ts
desalts839573desalts
desands94810163desands
descant104315583descant_
descents112511203descents
detents83615153detents
deviants1236733deviants
dewans105215143dewan_s
dicasts1078703dicasts
discants112912023discants
docents102810803docents
dopants1038433dopants
ducats95011763duca_ts
easts57530323_e_asts
eats47054873_e_a_ts
ecarte84313503_ecarte
ecartes94212563_ecartes
eclats8313033_eclats
elands74914773_elands
elans55527753_elan_s
elints65816423_elints
eluants737583eluants
enacts84012973_enacts
enchants1347823enchants
epacts105010393_epacts
errants7410623errants
escapes113811673escapes
escarps11397373escarps
escars83913133esca_rs
escorts9418403escorts
escots84211743esc_ots
etchants1346023etchants
events94814073_events
exacts15359613_exacts
exalts13328313_exalts
exsecant1794753exsecant_
feasts95116093fe_asts
feats86432753fe_a_ts
feints94813873fe_ints
gelant72821673gelant_
gellants9308283gellants
gents65729613ge__nts
gerents82612923gerents
giants74713503_giants
grants73722473_grants
hants86335403__hants
hearts96218943he_arts
heats85838403he_a_ts
hents87330743he__nts
hepcats1436473hepca_ts
hexanes17319463hexanes
incant82418503incant_
incents92414533incents
infants102210773infants
jacanas1638263jacanas
jeans126022113je_an_s
jurants14379213jurants
leans55536253le_an_s
leant56737783le_ant_
leasts64616413le_asts
lemans85316393leman_s
levant9314493levant_
means75831223me_an_s
meant76537203me_ant_
meats75034053me_a_ts
mediants11299493mediants
medicants1466783medicants
merchants1646203merchants
mutants938583mutants
neats55931903ne_a_ts
oceans81211003ocean_s
octants9128733octants
operants1039483operants
oxcarts1634313oxcarts
pants76536923__pants
peans75437643pe_an_s
peanuts936993pe_anuts
peasants1038263peasants
peats76140193pe_a_ts
pecan91919033pecan__
peccant13311733peccant_
pechans14810503pechan_s
pedant9319493pedant_
pekans121710553pekan_s
penangs10268373penangs
penchants1646193penchants
pendants1139093pendants
pennants1037063pennants
percents122713363percents
picante11310523picante
plants84921803_plants
precasts1239453precasts
precents123015033precents
quants153614143_quants
rants55935343__rants
reactants1146623reactants
reacts83616603re_acts
rebaits9312573rebaits
recalls92613613recalls
recane83022873recan_e
recaned102817203recaned
recanted112513513recanted
recanter101913153recanter
recanters112310483recanters
recaps103615733reca_ps
recast83422773recast_
recent83630853recent_
recepts113010263recepts
recharts1337663recharts
recits83621353rec_its
recoats92616643recoats
recons84922993recon_s
recounts1038773recounts
recreants1146623recreants
recusants1145103recusants
recuts83817373rec_uts
redacts10510943redacts
redans75421023redan_s
regents83416543regents
regrants9310013regrants
rehangs1137563rehangs
relands85214883relands
relents74018503relents
remands104914883remands
remans84823003reman_s
remints95117293remints
remnants1036843remnants
rents55935183re__nts
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replants102811243replants
rerents73319423rerents
resents74221223resents
retints74717013retints
sacbuts1166473sacbuts
sachets123914103sachets
saints65122423s_aints
salts55431883s__alts
sands65228583s__ands
sanes55649073s__anes
sans45153353s__an_s
santo56227283s__anto
santos64421833s__antos
sarans64224433saran_s
satangs8479713satangs
savant9416043savant_
scabs94818643s_ca_bs
scads85419953s_ca_ds
scags85520973s_ca_gs
scalds94813693s_calds
scales84529313s_cales
scalls84218203s_calls
scalps104315233s_calps
scamps125014173s_camps
scams94423973s_ca_ms
scan65530453s_can__
scanted104114393s_canted
scanter94215183s_canter
scantest101710183s_cantest
scanties103215413s_canties
scantly12419553s_cantly
scapes105122263s_capes
scares85033003s_cares
scarfs114714683s_carfs
scarps104718603s_carps
scars75433533s_ca_rs
scart76139773s_cart_
scat65848373s_ca_t_
scatt76030093s_ca_tt
scatty115310653s_catty
scaups105411933s_caups
scaurs85512043s_caurs
scenas84114703s_cenas
scends95213003s_cends
scenes84520353s_cenes
scent75831623s_cent_
scones84521303s_cones
scoots85315933s_coots
scots74025903s_c_ots
scouts84817943s_couts
scuts74522523s_c_uts
seacoasts1144193seacoasts
seacrafts1443703seacrafts
sealant73118303sealant_
seals54839693se_a_ls
seams75731663se_a_ms
seance83716683se_ance
seances93015343se_ances
sears54744913se_a_rs
seas45755273se_a__s
seat47575563se_a_t_
seawans10379943seawan_s
seawant103613413seawant_
secalose1046953secalose
seccos1039923sec_cos
secedes103711983secedes
secerns987733secerns
seconal9310073seconal
seconals1047053seconals
second9411153secon_d
seconde1037413seconde
secondes1138133secondes
secondi1044933secondi
secondo1044933secondo
secpars1138413secpars
secret8325063secret_
secrete9311073secrete
secretes10410473secretes
secs65033893sec___s
sect67443623sec__t_
sectors93116433sectors
secund937103secun_d
secures9613163secures
sedan65620423sedan__
sedate73019803seda_te
sedates83418033sedates
seeings84411293seeings
segments1138903segments
segnos73610443se_gnos
seicento1045043seicento
seicentos1144553seicentos
seines65029903se_ines
seitans73312303seitan_s
sejeant1489723sejeant_
selahs9313213sela_hs
selects91912143selects
semantic1249553semantic
semantics1346823semantics
semens84616963semen_s
senate63725143sena_te
senates73322583senates
sends65528243se__nds
sennas64214233se_nnas
sennets73712583sennets
sennits73811283sennits
sent46963013se__nt_
sente56432873se__nte
senti56226693se__nti
sepals85217373sepa_ls
septets998953septets
septs75420603se__pts
sequents1756993sequents
seracs84418573sera_cs
serails73318363serails
serais64326133sera_is
serapes95218103serapes
seraphs12408093seraphs
serenes73222903serenes
sergeants10115593sergeants
serines74229543serines
serins64029673serin_s
serjeants1673963serjeants
serpents102410373serpents
serranos857843serranos
servant10313623servant_
sesames9310743sesames
sestets7911473sestets
setenants945973setenants
setons64620173seton_s
setouts74110333setouts
sets45549503se___ts
setts55124323se__tts
sevens93813663seven_s
seventh1336773seventh
sevenths1444793sevenths
seventy1338033seventy
sewages1139753sewages
sewan85921293sewan__
sewars94018623sewa_rs
sewings11369173sewings
sexists14267673sexists
sexpots1636293sexpots
sextans14349263sextan_s
sextant142911963sextant_
sextets1497143sextets
sexts125118383se__xts
shafts125411433s_hafts
shanks135315583s_hanks
shanti94014073s_hanti
shantis103313083s_hantis
shanty124715113s_hanty
shebangs1443593shebangs
shoats94117073shoa_ts
shunts95712013s_hunts
silanes72517163silanes
silents73514493silents
skanks94710833s_kanks
skats94621533s_ka_ts
skeanes113610713skeanes
skeans104512913skean_s
sklents11348163sklents
slangs75615343s_langs
slant55238703s_lant_
slanty95114843s_lanty
slats55436903s_la_ts
smalts85214893s_malts
smarts86218003s_marts
socages101012053socages
socas74026183soca__s
sockets134012983sockets
solands84412343solands
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonant6621953sonant_
sowans94215893sowan_s
spaits85017473s_paits
spanks124514123s_panks
spans74528733s_pan_s
spats75031383s_pa_ts
speans85417143spean_s
spirants1088283spirants
splats84817303spla_ts
splents93912133splents
splints94511743splints
sprangs104610053sprangs
sprats85819933spra_ts
sprints94113773sprints
squats153712963squa_ts
squints16339033squints
stands75118053s_tands
stanes64933403s_tanes
stangs75018163s_tangs
stanks104917703s_tanks
starts65423123s_tarts
stats55933363s_ta_ts
stents65019453s_tents
stints65119763s_tints
stoats65117483stoa_ts
straits74916323straits
strands83711953strands
strunts7429543strunts
stunts65615253s_tunts
suints64617783s_uints
swanks134811563s_wanks
swans84625013s_wan_s
swats85726863s_wa_ts
sweats94814613swea_ts
teacarts10116073teacarts
teats55636813te_a_ts
technos1236183technos
tenant6322473tenant_
tents56434213te__nts
tetanus737933tetanus
truants738153truants
tyrants1037453tyrants
upcasts11185643upcasts
vacant11415133vacant_
vegans103910853vegan_s
vents86125933ve__nts
versants1137783versants
vesicants1444753vesicants
wants87932213__wants
weans85326743we_an_s
webcasts1543313webcasts
wechts1446253wec_hts
yeans86624883ye_an_s
yeasts96413053ye_asts
zenanas16286233zenanas

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.1601116818.8
2DLD Change Limit1340274647.37318178.1
3Display Results4644640.1562974.4
 (SQL Overall)1786914647.68923239.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.