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

209 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
sectary123827(None) 
nectary1246221nectary
hectare1238462hectare
insectary1444202insectary
lactary1237842lactary
nectar838852nectar_
nectars938462nectars
peccary1636282peccary
rectory123512722rectory
scary105222592s_c_ary
secpar1037922secpar_
secpars1138412secpars
secretary1444192secretary
sector83415922sector_
sectors93116432sectors
senary93716072se_nary
sentry92912052sent_ry
actuary1245613_actuary
becharm1636843becharm
beggary14316153beggary
bestiary1344813bestiary
betray111511443be_tray
beweary1536223beweary
cedary12419603ce_dary
centare93113703centare
centaury1343953centaury
century1237193century
chary135023133__chary
clary105719613__clary
datary10310243_datary
deary95826843de__ary
decare93919153dec_are
decay114718483dec_a_y
decenary1446273decenary
deciare10710663deciare
declare10411223declare
decry115514353dec__ry
decury1277963dec_ury
denary105316863de_nary
dietary1158663dietary
eatery95316353_eatery
echard1249223_echard
ecstasy1252603_ecstasy
electuary1443273electuary
entry82414263_ent_ry
escar74011993esc_ar_
escarp10449003esc_arp
escars83913133esc_ars
eschar1136523eschar_
eschars1237173eschars
estray95713333_estray
estuary1034683estuary
eutaxy1643303_eutaxy
factory15108343factory
feodary1444713feodary
feudary1444273feudary
gentry103410443gent_ry
hectares1338853hectares
hector113312653hector_
hectors123513263hectors
hektare1435503hektare
leary85927383le__ary
lechery15257643lechery
lectern937033lectern
lector83514983lector_
lectors93415763lectors
lecture9149513lecture
leotard846193leotard
mortary12369043mortary
notary92310713_notary
pectase112410363pectase
pectate112214693pectate
pedlary13277543pedlary
peltry11288653pelt_ry
pessary1246873pessary
petard95013803pe_tard
recarry1245063recarry
rechart12314323rechart
recta74220263recta__
rectal84418133recta_l
rectally1339713rectally
rectify1536453rectify
rector84019743rector_
rectors93520513rectors
restart7320033restart
retard75018933re_tard
retiary1038333retiary
retry84718083re_t_ry
rotary92411303_rotary
salary9515213s_alary
salutary1145113salutary
sanctuary1442183sanctuary
sanitary1146753sanitary
satara6315533s_atara
satay84718463s_ata_y
scaly104718723s_c_aly
scar66434203s_c_ar_
scare75334463s_c_are
scarey115016983s_c_arey
scarf105427143s_c_arf
scarp95724103s_c_arp
scarry116311183s_carry
scars75433533s_c_ars
scart76139773s_c_art
scatty115310653s_catty
scenery1236553scenery
scry96017763s_c__ry
scurry11419583s_curry
sealery104011053sealery
seamark1336723seamark
seamy105921273se__amy
sear47353843se__ar_
sears54744913se__ars
seater64534153seater_
seaters74028933seaters
seaward1148173seaward
seaware1049623seaware
seaway12309993seawa_y
secant84023293sec_ant
secern81010223sec_ern
secondary1543193secondary
secrecy1444743secrecy
secretory1444593secretory
sect67443623sect___
sectarian1147533sectarian
sectaries11312233sectaries
sectile9311973sectile
section92515663section
sectoral10109543sectoral
sectored1138063sectored
sects75622893sect__s
secular92211533secular_
secularly1445223secularly
seculars10219393seculars
secure8513533sec_ure
sedentary1344463sedentary
seggar8357813seggar_
seggars9377783seggars
seitan62613233seita_n
seitans73312303seitans
semidry1345203semidry
seminary1398093seminary
sensory10329083sensory
septa75518083septa__
septage1078403septage
septal84513383septa_l
septaria1047413septaria
septate9511873septate
septenary1443733septenary
serry84824123se__rry
seta45637313se_ta__
setae56026223se_ta_e
setal56430903se_ta_l
setter64023723setter_
setters73822063setters
sewar85421093se_war_
sewars94018623se_wars
sextain14257093sextain
sextan13389643sexta_n
sextans14349263sextans
sextant142911963sextant
sextarii1543183sextarii
sitar54820543s_itar_
sitars65417593s_itars
smeary114110803s_meary
smeltery13274963smeltery
solitary1146503solitary
spectate12248833spectate
specter113111733specter_
specters122811063specters
spectra11275833spect_ra
spectral12246193spectral
spectre11297773spect_re
spermary1545043spermary
stagy96618893s__tagy
star48037763s__tar_
stare54440263s__tare
stark95425623s__tark
starry94911673s__tarry
stars55836573s__tars
start55642313s__tart
statuary1144033statuary
stay78333723s__ta_y
story86723033s__tory
stray88525573s__tray
succory1444643succory
sudary1038703s_udary
sugary1039013s_ugary
sultry938463sult_ry
summary14297353summary
sweltry1333413swelt_ry
teary85124053te__ary
tecta74215523tecta__
tectal83713253tecta_l
ternary1038343ternary
tertiary1145433tertiary
testacy1235963testacy
tetany959843te_tany
textuary1842673textuary
unchary1537263unchary
unitary1038613unitary
vector113212063vector_
vectors123212593vectors
vestiary1444313vestiary
vestry1238623vest_ry
victory15326983victory
votary12248333_votary
weary115620613we__ary
zedoary2043213zedoary

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.1561145455.1
2DLD Change Limit1340272097.56317721.4
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.79522923.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.