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

403 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
selects9191214(None) 
elects83315001_elects
select82621171select_
defects134511522defects
deflects14336732deflects
dejects17389222dejects
delicts104012252delicts
deselects1244492deselects
detects104011092detects
ejects15409952_ejects
elect74327032_elect_
erects84116182_erects
neglects1144382neglects
prelects1299722prelects
reelects103110882reelects
refects124012742refects
reflects13288872reflects
rejects163910692rejects
relents74018502relents
relets64025672rele_ts
relicts94414592relicts
relucts9369672relucts
resects94115592resects
reselects1156412reselects
sects75622892s__ects
selected1159782selected
selectee10910492selectee
selectees1147012selectees
selectly1346562selectly
selector1048622selector
selectors1148972selectors
senecas939012senecas
silents73514492silents
sklents11348162sklents
sleets64318872s_leets
splents93912132splents
advects13276013advects
affects1535393affects
aglets73915683agle_ts
alecs76620733_alec_s
alerts64418223_alerts
analects1047703analects
aspects1146743aspects
basilects1342973basilects
bedecks1635793bedecks
beets76131443be_e_ts
beflecks1943753beflecks
begets96215523bege_ts
behests1235953behests
beleaps1138053beleaps
belts75931163bel__ts
berets85822523bere_ts
besets85718803bese_ts
bisects1137133bisects
bleats85518613_bleats
blets75324943_ble_ts
celebs1037883cele_bs
celesta947643celesta
celestas1057083celestas
celeste949653celeste
celestes10310013celestes
celts75325783cel__ts
cements112714223cements
cleats84919313_cleats
clefts114610163_clefts
coerects1258543coerects
collects12279783collects
culets85518513cule_ts
deceits102810883deceits
decocts1237833decocts
deducts1166593deducts
deets65330243de_e_ts
defeats113511233defeats
defect124816173defect_
deflect13399973deflect_
deject164512843deject_
dejecta17376363dejecta
deleads9379703deleads
deles65139253dele__s
delete73620703dele_te
deletes83117933deletes
delfts10439673del_fts
delict94320333delict_
delists84414173delists
delts65731793del__ts
dements103016623dements
depicts12358463depicts
deselect1147523deselect_
deserts82513053deserts
detect94217403detect_
detents83615153detents
detests83711743detests
devests114410473devests
dialects11126003dialects
directs102710263directs
dulcets1046283dulcets
edicts94911703_edicts
educts9439893_educts
effects1535283effects
egests74411253_egests
eject145016043_eject_
ejecta15337393_ejecta
elected102812613_elected
electee92513243_electee
electees10238723_electees
elector93313263_elector
electors103013853_electors
electro92810033_electro
electros102811743_electros
elegits8149343_elegits
elemis8312383_elemis
elicits9311233_elicits
elints65816423_elints
eluents738703_eluents
enacts84012973_enacts
epacts105010393_epacts
erect74129333_erect_
eructs83610793_eructs
events94814073_events
everts94514893_everts
evicts11368553_evicts
exacts15359613_exacts
execs14539723_exec_s
exerts133712293_exerts
expects1866883expects
exsects1655573exsects
eyelets1057523eyele_ts
felts85324543fel__ts
filets94718953file_ts
flecks154310803_flecks
fleeces12399643fleeces
fleets96915063_fleets
geests75912163ge_ests
gelants82611443gelants
gelees74116263gele_es
gelts65924613gel__ts
genets75716663gene_ts
gerents82612923gerents
gleets75315053_gleets
helices12313723helices
hellcats1346323hellcats
helmets12309073helmets
helots95217703hel_ots
infects12279713infects
inflects1336193inflects
injects16257453injects
inlets63915573inle_ts
insects93710843insects
islets64513083isle_ts
keets95123483ke_e_ts
keleps12478813kele_ps
kelts95222633kel__ts
leets54927123__leets
lefts86517813__lefts
lets47147943__le_ts
meets74224613me_e_ts
melees83618083mele_es
melenas999203melenas
melts74930103mel__ts
molests93311563molests
mulcts10298713mul_cts
neglect1047363neglect_
objects18123693objects
omelets938333omele_ts
owlets93110393owle_ts
palets85122313pale_ts
peles75738083pele__s
pellets94014783pellets
pelmets11309693pelmets
pelts76128813pel__ts
perfects15107353perfects
pleats85218593_pleats
polecats1248833polecats
praelects1354353praelects
preelects1356083preelects
prefects1598133prefects
prelect111013833prelect_
preselects1464363preselects
reacts83616603re_acts
rebecks15288013rebecks
rebecs103913673rebec_s
recepts113010263recepts
redacts10510943redacts
reejects17336083reejects
reelect911515633reelect_
reerects10319923reerects
reests64618893re_ests
refect114319333refect_
reflect123913713reflect_
reflets103513153refle_ts
regents83416543regents
reglets83512983regle_ts
reheats104513523reheats
reject154116283reject_
relaces93420883relaces
relends84013253relends
relent64431853relent_
relet54749823rele_t_
releves103914973releves
relics84517903relic_s
relict83623903relict_
relists73817053relists
relocks134411293relocks
reluct83916113reluct_
remeets93712413remeets
remelts93511493remelts
renests74014213renests
repeats94316053repeats
repents93717623repents
rerents73319423rerents
reseats74319583reseats
resect84424703resect_
reselect1059943reselect_
resents74221223resents
resets65427613rese_ts
respects1247703respects
retests73813853retests
reverts104715043reverts
revests104413733revests
revets94022173reve_ts
rewets94617213rewe_ts
saleps85014903sale_ps
sales56055593sale__s
salients839563salients
sallets73719653sallets
salts55431883sal__ts
samechs14285353samechs
samlets93813553samle_ts
scents85317023s_cents
scleras948223scleras
scoleces1237083scoleces
sealants82610743sealants
sealers74323553seale_rs
sealifts1135473sealifts
seances93015343seances
seats54844343s__eats
secants93413893secants
seccos1039923se_ccos
secedes103711983secedes
secerns987733secerns
secrets9311773secrets
secs65033893s__ec_s
sect67443623s__ect_
seders74420283sede_rs
seduces1069283seduces
seeds64330063se_e_ds
seeks94724643se_e_ks
seels55632823se_e_ls
seems75525023se_e_ms
seeps74828753se_e_ps
seers55136383se_e_rs
sees45361053se_e__s
segments1138903segments
selahs9313213sel_ahs
selecting12310533selecting
selection11311273selection
selections12310873selections
selective1449523selective
selectman1343553selectman
selectmen1344613selectmen
selectness1245453selectness
selenate81712533selenate
selenates91611363selenates
selenic9410663selenic
selenite81713113selenite
selenites91312093selenites
selenous848973selenous
selfs85220243sel__fs
selkies113513353selkies
sellers73721323sellers
selles64426983sel_les
sellouts837493sellouts
sells55134433sel__ls
sels46345983sel___s
selsyns1092943selsyns
selvas93812913sel_vas
selves94119613sel_ves
sememes11109203sememes
semens84616973seme_ns
semes75731583seme__s
seneca839793senec_a
senecio947203senecio
senecios1046303senecios
senegas837253senegas
sennets73712583sennets
sennits73811283sennits
septets998953septets
septs75420603s__epts
sequents1756993sequents
seracs84418573serac_s
sereins73716123sereins
serenes73222903serenes
seres55448893sere__s
serest64831613serest_
serpents102410373serpents
sestets7911473sestets
setouts74110333setouts
sets45549503s__e_ts
setts55124323s__etts
sevens93813663seve_ns
seventh1336773seventh
sevenths1444793sevenths
seventy1338033seventy
severs94121123seve_rs
sewers94719723sewe_rs
sexes126126223sexe__s
sexists14267673sexists
sexless1467243sexle_ss
sexpots1636293sexpots
sextets1497143sextets
sexts125118383s__exts
sheets93918503s_heets
shlepps14394833shlepps
shleps114710333shle_ps
shlocks16317183shlocks
sieverts1145713sieverts
silences10310073silences
silent64125843silent_
silenus7369693silenus
silexes1438653silexes
silicas9310603silicas
silts55330823sil__ts
skeets104513253s_keets
sklent103614353sklent_
slacks124416533s_lacks
slants64819083s_lants
slats55436903s_l_ats
sleds64418853s_le_ds
sleeks104512463s_leeks
sleeps83913323s_leeps
sleet55639133s_leet_
sleety94112653s_leety
sleeves103311343sleeves
slept75728103s_lept_
sleuth937233s_leuth
sleuths1034743s_leuths
slews86220353s_le_ws
slices84022853s_lices
slicks124816113s_licks
slits56128853s_l_its
slots54830533s_l_ots
sluts54523983s_l_uts
smelts85412773s_melts
snecks124410033s_necks
solaces93116133solaces
solecise1089073solecise
solecism12107593solecism
solecist10910783solecist
solecists1187073solecists
solerets839693solerets
soles55547923sole__s
soleus64615613sole_us
solicits10311023solicits
solvents1136763solvents
specks144312703s_pecks
specs96916673s_pec_s
spelts84614643s_pelts
splats84817303spl_ats
spleens937103spleens
splent84720193splent_
splices113914383splices
splints94511743splints
splits85416413spl_its
steles63725663stele__s
stents65019453s_tents
sterlets8169273sterle_ts
stets55423913s_te_ts
streets73312613streets
stylets10369213style_ts
subjects19226533subjects
sublets92616703suble_ts
subsects12267903subsects
suets55126103s_ue_ts
sulcus8410493sul_cus
suspects1254863suspects
sweats94814613s_weats
sweets94214433s_weets
talents7312013talents
telcos8710683tel_cos
telecast1048303telecast
telecasts1145543telecasts
telecom1146813telecom
telecoms1246473telecoms
teledus835093teledus
telegas837443telegas
teleost7410523teleost
teleosts846423teleosts
teles54536003tele__s
teleses7313123teleses
telesis7310793telesis
telexes1438353telexes
telnets738373telnets
tenets65518953tene_ts
tercets93512443tercets
useless7188423usele_ss
valets93715623vale_ts
veldts10417753vel_dts
velvets13326693velvets
weets85427723we_e_ts
welts85225193wel__ts
xebecs17355363xebec_s
zebecks24274193zebecks
zebecs19316183zebec_s

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.420425454.8
2DLD Change Limit1340274037.51617832.2
3Display Results4034030.1562583.3
 (SQL Overall)1786914038.09222082.4
 
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.