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

148 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
eduction116905(None) 
deduction1377081deduction
education12310201education
eductions1268771eductions
reduction1259901reduction
seduction1266981seduction
abduction14125412abduction
adduction13225162adduction
auction93412932_auction
deductions1467132deductions
diction102313052_diction
edition8310852ed_ition
educations1339232educations
eductive1476862eductive
eductor1035862educt_or
ejection172510042ejection
election102015352election
elution72913822elu_tion
equation17310482equation
erection102115512erection
eruption1047042eruption
evection131910832evection
eviction13228682eviction
exaction1738952exaction
induction1248982induction
redaction1259662redaction
reductions1359582reductions
ruction93611612_ruction
seductions1366872seductions
suction93713042_suction
abductions15125383abductions
action84719683__action
adaption1145643adaption
addiction13146013addiction
addition1096893addition
adductions14104953adductions
adjunction2043293adjunction
adnation9310783adnation
adoption1146083adoption
adulation10311013adulation
advection1545553advection
auctions104012143_auctions
audition979173audition
caution93013523cau_tion
coaction12310773coaction
coeducation1646233coeducation
conduction1549963conduction
decoction1447523decoction
decurion1146623decurion
dedication14311963dedication
deducting1436843deducting
deductive1645473deductive
defection151610643defection
dejection19178663dejection
delation92318083delation
deletion92011973deletion
demotion1169073demotion
depiction1437273depiction
detection121310413detection
devotion1256763devotion
dictions111812673_dictions
ductile1048483_ductile
ducting113713593_ducting
duration9312693_duration
durion7510963_du_rion
editions9310403ed_itions
educating1337933educating
educational1444873educational
educative15136553educative
educator1147153educator
educing1137683educ_ing
educt85017103educt___
eductors1135983eductors
educts9439893educt__s
egestion946863egestion
ejections18249963ejections
elation73620453e_lation
elections112414973elections
electron102611413electron
elocution1145673elocution
elusion72310953elu_sion
elutions82513053elu_tions
emotion9711303e_motion
emulation11312393emulation
emulsion1045923emulsion
enation73419233e_nation
equations1839493equations
erections112515213erections
eructation1248333eructation
eructing112110173eructing
erudition1046173erudition
eruptions1146763eruptions
evections142510693evections
evictions14228623evictions
evocation142010293evocation
evulsion1155063evulsion
exactions1838923exactions
exciton1646083e_xciton
execution1846303execution
exertion15310083exertion
expunction2143573expunction
exsection1847493exsection
exudation1787693exudation
faction122613333_faction
fiction122010733_fiction
flection13239563flection
fraction1359483fraction
friction1347913friction
fruition11106103fruition
function1337843function
ideation9310493ideation
inaction1039623inaction
indiction1239813indiction
inductions1348803inductions
inunction1146893inunction
junction1736203junction
lection92614863_lection
locution10227663locution
mediation12312293mediation
medication15411173medication
paction112713963_paction
prediction15410303prediction
production1547893production
reaction10612603reaction
redactions1359133redactions
reductional1454593reductional
reductive1547793reductive
reductor1156433reduct_or
reeducation1445933reeducation
refection141512283refection
rejection181710253rejection
reliction11310693reliction
resection111613273resection
ructions102811683_ructions
sanction1049533sanction
section92515663_section
sedation9312453sed_ation
sedition939333sed_ition
seductive1545613seductive
selection11311273selection
stiction1038823stiction
subduction1544683subduction
suctions103012903_suctions
sudation9310803sudation
taction93213023_taction
traction10412683traction
tuition738823_tuition
unction9310663_unction

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 Limit1461621486.89321204.4
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.37324235.9
 
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.