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

300 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
sections10271470(None) 
lections102413841lections
section92515661section_
suctions103012901suctions
actions94218512_actions
auctions104012142auctions
bisections14136732bisections
dictions111812672dictions
ejections18249962ejections
elections112414972elections
erections112515212erections
evections142510692evections
exsections1947632exsections
factions133013062factions
fictions132410742fictions
flections14239212flections
lectins92515002lecti_ns
lection92614862lection_
mentions10312892mentions
pactions122613502pactions
pectins112315232pecti_ns
reactions11711712reactions
resections121513032resections
ructions102811682ructions
sanctions1138872sanctions
scions82612242s_c_ions
secretions12117842secretions
sectional1149412sectional
sectionals1247262sectionals
sectioned1246522sectioned
sectors93116442sect_ors
sedations10311252sedations
seditions1039012seditions
seductions1366872seductions
selections12310872selections
sessions839722sessions
setons64620172se_t_ons
sextons143710412sext_ons
stations82415222stations
stictions1148352stictions
suction93713042suction_
tactions102912422tactions
unctions1039732unctions
abjections2145673abjections
acetins9313173aceti_ns
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
advections1645553advections
aerations9317903aerations
affections1845893affections
alations82518893alations
amotions1069843amotions
assertions1046583assertions
auction93412933auction_
bastions10411693bastions
beckons15279143bec_kons
benthons1337973benthons
betons84919553be_t_ons
bijections21134933bijections
bilections14136503bilections
bisection13136983bisection_
bolections14137293bolections
captions123813223captions
caseations1258303caseations
cations94524143_cations
cautions103313183cautions
cessions1039853cessions
cions75222853__c_ions
coactions1349743coactions
coitions10312853coitions
creations112614543creations
decagons1235893decagons
deceptions1547863deceptions
decisions1248383decisions
decoctions1547143decoctions
decurions1246023decurions
deductions1467133deductions
defections161510203defections
dejections20168353dejections
delations102616593delations
deletions102610933deletions
demotions1258443demotions
dentins83419223denti_ns
depictions1546893depictions
desertions1139883desertions
detections131410043detections
devotions1356593devotions
diction102313053diction_
directions1379633directions
dissections14198263dissections
editions9310403editions
eductions1268773eductions
egestions1046703egestions
ejection172510043ejection_
elations83719123elations
election102015353election_
electrons112411753electrons
elutions82513053elutions
emotions10610283emotions
enations83316903enations
erection102115513erection_
ethions1038483_ethions
evection131910833evection_
evictions14228623evictions
exactions1838923exactions
excitons1746043excitons
executions1946393executions
exertions1639763exertions
exsection1847493exsection_
exsertions1746743exsertions
faction122613333faction_
factious13239243factious
fenthions1544233fenthions
fermions1336203fermions
festoons1136443festoons
fetations12511383fetations
fiction122010733fiction_
flection13239563flection_
fractions1449103fractions
frictions1448033frictions
functions1437743functions
gelations102513093gelations
gentians937563gentians
hectors123513263hect_ors
hellions11310023hellions
ideations1039903ideations
inactions1139323inactions
infections15510233infections
injections1948663injections
insertions10410343insertions
inspections1546423inspections
jetons134512613je_t_ons
jettisons1642233jettisons
jettons1437273je_ttons
junctions1835943junctions
kations114013663_kations
lecterns1035943lecterns
lectin82515013lecti_n_
lectors93415763lect_ors
legations102711923legations
legions84611783le_gions
lenitions939473lenitions
leptins92412693lepti_ns
leptons91910433lept_ons
lesions73813873le_sions
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
meltons9410923melt_ons
mention9314373mention_
mestinos1048163mestinos
midsections1644393midsections
motions94215003_motions
nations74720563_nations
negations102811963negations
nektons1136393nekt_ons
neutrons838293neutrons
newtons1036813newt_ons
notions74014483_notions
objections2145633objections
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
pectens11189203pect_ens
pectin102615533pecti_n_
pectines121914683pectines
pectinous1345553pectinous
pectizes21229783pectizes
pensions10311693pensions
pereions10310853pereions
petitions11511083petitions
plectrons13258073plectrons
portions10514413portions
potions93417423_potions
questions1845523questions
rations74123433_rations
reaction10612603reaction_
recautions1247813recautions
receptions1449743receptions
recisions1139913recisions
reckons13269653rec_kons
recoins94019243recoi_ns
recons84922993rec__ons
rectors93520513rect_ors
rectos85718783rect_o_s
redactions1359133redactions
reductions1359583reductions
refections151811643refections
regions83613473re_gions
rejections191510103rejections
relations92418333relations
relictions12310023relictions
remotions1149703remotions
resection111613273resection_
reunions837273reunions
ruction93611613ruction_
ructious10277083ructious
sacatons1038973sacatons
sanction1049533sanction_
satins64930483s_ati_ns
scion72214993s_c_ion_
seasons72614233se_asons
seating84130683seati_ng
seatings93614303seatings
seccos1039923sec_co_s
secerns987733sec_erns
secessions1246463secessions
seclusions1244633seclusions
second9411153sec__ond
seconds1038283sec__onds
secretins11108463secreti_ns
secretion11118293secretion_
sectarians1245833sectarians
sectile9311973secti_le
sectioning1346293sectioning
sector83415923sect_o_r
sects75622893sect___s
sedation9312453sedation_
sedition939333sedition_
seditious1046493seditious
seduction1266983seduction_
seisins73614393seisi_ns
seitans73312303seit_ans
seizins164010133seizi_ns
selection11311273selection_
semitone1048973semitone
semitones1148943semitones
seniors73413613se_niors
sensations1059853sensations
sentient8313633sentient
sentients948463sentients
sentimos10407423sentimos
septics112810433septi_cs
septimes1238303septimes
sequins1637863sequi_ns
sereins73716113serei_ns
seriations10316683seriations
serins64029673se_ri_ns
serious73616283se_rious
sermons9311783se_rmons
serrations10313093serrations
session739763session_
sestina72711973sesti_na
sestinas8249133sestinas
sestine73017923sesti_ne
sestines82717243sestines
seton55223543se_t_on_
setous64917373se_t_ous
setting83621393setti_ng
settings93810073settings
settlors8255013settlors
sextains15246813sextains
sextans14349263sext_ans
sextiles1537643sextiles
sexton133610793sext_on_
sextos134012163sext_o_s
smectites1344623smectites
solations9814623solations
solions7513753s_olions
solitons849593solitons
solutions988883solutions
sorptions1137123sorptions
speciations1548483speciations
specious1247483spec_ious
statins73719773stati_ns
station72717243station_
stetsons845623stetsons
stiction1038823stiction_
stotins73213873stoti_ns
strictions1249143strictions
suasions838783suasions
subjections2296353subjections
subsections1597103subsections
suctional1147683suctional
suctioned1245283suctioned
sudations1039903sudations
sulcations1289583sulcations
surjections2075283surjections
symbions1563933symbions
taction93213023taction_
tectites1039993tectites
tensions8310223tensions
ternions838813ternions
tertians839103tertians
testons7313563test_ons
testoons837323testoons
tractions11511623tractions
trisections1345643trisections
tuitions838283tuitions
unction9310663unction_
vacations141910553vacations
vectors123212593vect_ors
venations12311723venations
versions11310353versions
vexations1937753vexations
vocations141911423vocations
zeatins16311733zeati_ns
zechins21137123zechi_ns

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461623007.58019282.6
3Display Results3003000.1232439.0
 (SQL Overall)1786913007.87322696.7
 
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.