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 “educational” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
educational144487(None) 
coeducational1853292coeducational
education12310202education__
educationally1963312educationally
educations1339232education_s
equational1945602equ_ational
reductional1454592reduc_tional
avocational1645183avocational
dictional1268613_dic_tional
educating1337933educati_n_g
educationalist1763283educationalist
educationese1551963educationese
educationist1555263educationist
eduction1169053educ_tion__
eductions1268773educ_tion_s
ideational1146503id_eational
indicational1545753indicational
locational1246593_locational
mediational1445643med_iational
mutational1246513_mutational
noneducational1762523noneducational
nutational1047043_nutational
redactional1454353redac_tional
reputational1474583reputational
suctional1147683_suc_tional
vocational1546953_vocational
adaptational1572794adaptational
additional1244644ad_ditional
adulation10311014adulation__
adulations11310124adulation_s
agitational1244844agitational
antieducational18101544antieducational
binational1246374_binational
citational1266464_citational
coeducation1646234coeducation__
coeducationally23102354coeducationally
coeducations1745874coeducation_s
decagonal1343724_deca_gonal
deceptional1654774deceptional
decisional1344834_decisional
dedication14311964dedication__
dedications15310874dedication_s
deduction1377084deduc_tion__
deductions1467134deduc_tion_s
derivational1654264derivational
devotional1444674_devotional
duration9312694_duration__
durations10311464_duration_s
ecotonal1046254e__cot_onal
educationalists1892724educationalists
educationeses1661544educationeses
educationists1654344educationists
educative15136554educati__ve
educator1147154educat_o__r
educators1246994educat_o_rs
educatory1545444educat_o_ry
emotional1146664e__motional
emulation11312394emulation__
emulations12310944emulation_s
equation17310484equ_ation__
equationally2453824equ_ationally
equations1839494equ_ation_s
eructation1248334eructation__
eructations1347234eructation_s
evasional1244294e__vasional
evocation142010294evocation__
evocations15259874evocation_s
excavational2452764excavational
exceptional2254444exceptional
excisional1953844e_xcisional
expectational2452494expectational
exudation1787694exudation__
exudations18107074exudation_s
factional1478764_fac_tional
fictional1477804_fic_tional
fluctuational1861234fluctuational
foundational1652854foundational
fractional1547134frac_tional
frictional1546254fric_tional
functional15116674_functional
generational1354824generational
gestational1245114gestational
gradational1354474gradational
gyrational1444744_gyrational
invocational1754414invocational
irrational1047214_irrational
junctional19105364_junctional
lactational1344654lactational
levitational1553634levitational
librational1344554librational
maturational1454184maturational
medication15411174medication__
medications1649934medication_s
migrational1444744migrational
narrational1145444narrational
national8311534___national
negational1147154_negational
nonnational11107834nonnational
nonrational11109124nonrational
notational1048124_notational
occasional1453374_occasional
occupational1883004occupational
operational1347524operational
ovational1246854__ovational
permutational1752694permutational
perorational1446394perorational
populational1654414populational
prevocational2054014prevocational
probational1547084probational
productional1794714produc_tional
radiational1245964radiational
rational8412544___rational
recreational1455174recreational
reduction1259904reduc_tion__
reductions1359584reduc_tion_s
reeducation1445934reeducation__
reeducations1545474reeducation_s
relational1047714_relational
rotational1048094_rotational
salutational1253324salutational
salvational1443714salvational
sectional1149424_sec_tional
seduction1266984seduc_tion__
seductions1366874seduc_tion_s
sensational1146384sensational
situational1144584situational
speciational1654314speciational
stational948514__stational
subnational1354584subnational
subrational1345504subrational
summational1553684summational
tractional1248054trac_tional
tuitional946054_tu_itional
valuational1444054valuational
variational1444784variational
vegetational1653374vegetational
vibrational1644364vibrational

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191378.70317099.7
3Display Results1371370.0801712.5
 (SQL Overall)1786911379.20319416.6
 
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.