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

282 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
lections10241384(None) 
elections112414971elections
flections14239211flections
lectins92515001lecti_ns
lection92614861lection_
sections102714701sections
actions94218512_actions
auctions104012142auctions
bilections14136502bilections
bolections14137292bolections
dictions111812672dictions
ejections18249962ejections
elations83719122elations
election102015352election_
electrons112411762electrons
elutions82513052elutions
erections112515212erections
evections142510692evections
factions133013062factions
fictions132410742fictions
flection13239562flection_
lecterns1035942lecterns
lectin82515012lecti_n_
lectors93415772lect_ors
legations102711922legations
legions84611782le_gions
lenitions939472lenitions
leptins92412692lepti_ns
leptons91910432lept_ons
lesions73813872le_sions
locations112512742locations
locutions11207062locutions
lotions74614762l_otions
mentions10312892mentions
pactions122613502pactions
pectins112315232pecti_ns
plectrons13258072plectrons
reactions11711712reactions
ructions102811682ructions
section92515662section_
selections12310872selections
suctions103012902suctions
tactions102912422tactions
unctions1039732unctions
abjections2145673abjections
acetins9313173aceti_ns
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
advections1645553advections
aerations9317903aerations
affections1845893affections
alations82518893alations
amotions1069843amotions
auction93412933auction_
bastions10411693bastions
beckons15279143bec_kons
benthons1337973benthons
betons84919553be_t_ons
bijections21134933bijections
bilection13156803bilection_
bisections14136733bisections
bolection13117673bolection_
captions123813223captions
cations94524143_cations
cautions103313183cautions
cessions1039853cessions
cions75222853__c_ions
coactions1349743coactions
coitions10312853coitions
collections1547933collections
creations112614543creations
decagons1235893decagons
deceptions1547863deceptions
decisions1248383decisions
decoctions1547143decoctions
decurions1246023decurions
deductions1467133deductions
defections161510203defections
deflections17187323deflections
dejections20168353dejections
delations102616593delations
deletions102610933deletions
demotions1258443demotions
dentins83419223denti_ns
depictions1546893depictions
detections131410043detections
devotions1356593devotions
diction102313053diction_
directions1379643directions
editions9310403editions
eductions1268773eductions
egestions1046703egestions
ejection172510043ejection_
elation73620453elation_
electing112113783electi_ng
electives1448933electives
electors103013863elect_ors
electron102611413electron_
electros102811753electro_s
elevations1338633elevations
elisions82210423elisions
elocutions1245963elocutions
elusions82610083elusions
elution72913823elution_
emotions10610283emotions
enations83316903enations
erection102115513erection_
ethions1038483_ethions
evection131910833evection_
evictions14228623evictions
exactions1838923exactions
excitons1746043excitons
executions1946393executions
exertions1639763exertions
exsections1947633exsections
faction122613333faction_
factious13239243factious
fenthions1544233fenthions
fermions1336203fermions
festoons1136443festoons
fetations12511383fetations
fiction122010733fiction_
flexions1844413fle_xions
fractions1449103fractions
frictions1448033frictions
functions1437743functions
gelations102513093gelations
gentians937563gentians
hectors123513263hect_ors
hellions11310033hellions
ideations1039903ideations
illations9311393illations
inactions1139323inactions
infections15510233infections
inflections1646993inflections
injections1948663injections
jetons134512613je_t_ons
jettisons1642233jettisons
jettons1437273je_ttons
junctions1835943junctions
kations114013663_kations
lactations1239423lactations
lacteous1046783lacteous
lactone9311413lact_one
lactones10311243lact_ones
lampions12277973lampions
latinos73613803l_atinos
lattins74115483latti_ns
lavations1238973lavations
laxations1637623laxations
leching134613653lechi_ng
lecithins1443983lecithins
lectern937033lectern_
lectionary1554823lectionary
lector83514993lect_o_r
lectures101310163lectures
lefties10312073lefti_es
leftisms13235243leftisms
leftists11235513leftists
legation92412933legation_
leggins9259473leggi_ns
legion75712983le_gion_
lemons84415053le__mons
lenition8310083lenition_
lentils73912973lenti_ls
lentisks1244413lentisks
lentoids947443lentoids
lentos65317403lent_o_s
leptin82512333lepti_n_
lepton82510803lept_on_
lesbians1043603lesbians
lesion64715063le_sion_
lessons73811023le_ssons
letdowns1243483le_tdowns
letting83218533letti_ng
leucins938103leuci_ns
leukons1135753le_ukons
levins94514653le_vi_ns
lexicons1743893lexicons
libations112510443libations
lictors93212603lict_ors
ligations102111993ligations
lineations1039543lineations
lions55923213l___ions
lobations11219613lobations
location102113913location_
locution10227663locution_
logions86211293l_ogions
lotion65716523l_otion_
lunations9310723lunations
luxations1637273luxations
meltons9410923melt_ons
mention9314373mention_
mestinos1048163mestinos
motions94215003_motions
nations74720563_nations
negations102811963negations
nektons1136393nekt_ons
neutrons838293neutrons
newtons1036813newt_ons
notions74014483_notions
objections2145633objections
olfactions1563873olfactions
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
pectens11189203pect_ens
pectin102615533pecti_n_
pectines121914683pectines
pectinous1345553pectinous
pectizes21229793pectizes
pensions10311693pensions
pereions10310853pereions
petitions11511083petitions
placations1438583placations
plectron12228023plectron_
plications14310493plications
portions10514413portions
potions93417423_potions
prelections151210473prelections
questions1845523questions
rations74123433_rations
reaction10612603reaction_
recautions1247813recautions
receptions1449743receptions
recisions1139913recisions
reckons13269653rec_kons
recoins94019243recoi_ns
recons84922993rec__ons
rectors93520523rect_ors
rectos85718793rect_o_s
redactions1359133redactions
reductions1359583reductions
reelections13167943reelections
refections151811643refections
reflections16178553reflections
regions83613473re_gions
rejections191510103rejections
relations92418333relations
relictions12310023relictions
remotions1149703remotions
resections121513033resections
reunions837273reunions
ruction93611613ruction_
ructious10277083ructious
sanctions1138873sanctions
scions82612243_sc_ions
secretions12117853secretions
sectional1149423sectional
sectionals1247273sectionals
sectioned1246523sectioned
sectors93116453sect_ors
sedations10311253sedations
seditions1039013seditions
seductions1366873seductions
selection11311273selection_
sessions839723sessions
setons64620173se_t_ons
sextons143710413sext_ons
stations82415223stations
stictions1148353stictions
suction93713043suction_
taction93213023taction_
tectites1039993tectites
tensions8310223tensions
ternions838813ternions
tertians839103tertians
testons7313563test_ons
testoons837323testoons
tractions11511623tractions
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.420425454.8
2DLD Change Limit1461622827.22020244.0
3Display Results2822820.1262238.1
 (SQL Overall)1786912827.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.