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

141 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
educations133923(None) 
education12310201education_
eductions1268771educ_tions
adulations11310122adulations
coeducations1745872coeducations
dedications15310872dedications
deductions1467132deduc_tions
durations10311462_durations
educating1337932educati_ng
educational1444872educational
educationese1551962educationese
educationist1555262educationist
educators1246992educat_ors
eduction1169052educ_tion_
emulations12310942emulations
equations1839492equ_ations
eructations1347232eructations
evocations15259872evocations
exudations18107072exudations
medications1649932medications
reductions1359582reduc_tions
reeducations1545472reeducations
seductions1366872seduc_tions
abdications1657653abdications
abductions15125383abduc_tions
adductions14104953adduc_tions
adjurations1944823adjurations
adnations1039753ad_nations
adorations11310233adorations
adulation10311013adulation_
advocations1755413advocations
arcuations1249343arcuations
auctions104012143_auc_tions
avocations15168683avocations
cations94524143___cations
caudations13108223caudations
causations1268143causations
coeducation1646233coeducation_
dealations11311373dealations
dedication14311963dedication_
deduction1377083deduc_tion_
defecations1779003defecations
deflations1439713deflations
delations102616593_delations
dentations11413633dentations
denudations1346343denudations
deputations1448343deputations
deviations14311163deviations
dictations1389703_dictations
dictions111812673_dic_tions
dilations102614453_dilations
donations101112353_donations
dotations101411633_dotations
duration9312693_duration_
edifications1848693edifications
editions9310403ed__itions
educates1139623educat__es
educationeses1661543educationeses
educationists1654343educationists
educative15136553educati_ve
educator1147153educat_o_r
educatory1545443educat_ory
eductors1135983educ_t_ors
ejections18249963ejec_tions
elations83719123e__lations
elections112414973elec_tions
elevations1338633elevations
elocutions1245963elocutions
elucidations1544513elucidations
elutions82513053elu__tions
eluviations14115793eluviations
emaciations1548163emaciations
emanations1289593emanations
emulation11312393emulation_
enations83316903e__nations
enucleations1444103enucleations
enunciations1445093enunciations
epilations12311713epilations
equation17310483equ_ation_
equitations2047443equitations
eradications1549303eradications
erections112515213erec_tions
eructation1248333eructation_
eruditions1146103eruditions
eruptions1146763eru_ptions
evacuations1646303evacuations
evections142510693evec_tions
evictions14228623evic_tions
evocation142010293evocation_
exactions1838923exac_tions
execrations2048923execrations
executions1946393executions
exhumations2344083exhumations
expiations1959663expiations
exudation1787693exudation_
exultations1846523exultations
exuviations2195693exuviations
federations1548883federations
furcations1547533furcations
ideations1039903id_eations
indications14310973indications
inductions1348803induc_tions
indurations1249583indurations
laudations1146843laudations
locations112512743_locations
lunations9310723_lunations
luxations1637273_luxations
mediations13310983med_iations
medication15411173medication_
meditations1449333meditations
miseducations18113293miseducations
modulations14147263modulations
mutations111211453_mutations
nodulations12147003nodulations
nutations91411763_nutations
ovulations1337973ovulations
peculations15310283peculations
placations1438583placations
plications14310493plications
predications17411183predications
pupations1338123_pupations
redactions1359133redac_tions
reduction1259903reduc_tion_
reeducation1445933reeducation_
refutations1448673refutations
regulations12310713regulations
relocations13311143relocations
reluctations1446753reluctations
reputations13410733reputations
revocations16410313revocations
ructions102811683_ruc_tions
sedations10311253sed__ations
seduction1266983seduc_tion_
suctions103012903_suc_tions
sudations1039903_sudations
sulcations1289583sulcations
truncations1344763truncations
ululations1037143ululations
undulations1246053undulations
vacations141910553_vacations
vocations141911423_vocations

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit1406031415.73624512.4
3Display Results1411410.0761855.3
 (SQL Overall)1786911416.21828737.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.