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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
antieducational1810152(None) 
noneducational1762503_noneducational
antinational1297454anti___national
antirational1278444anti___rational
coeducational1853284__coeducational
educational1444874____educational
annexational1953265an_ne__xational
antiquation2047415anti_qu_ation__
antiquations2146235anti_qu_ation_s
antitraditional16161485antitraditional
indicational1545735___indicational
interactional1556985int_erac_tional
international1357665int_e_rnational
noneducation1554335_noneducation__
reductional1454585___reduc_tional
aberrational1453486a__be_rrational
acculturational1971666acculturational
acidulation14105406a_ci_dulation__
acidulations15104816a_ci_dulation_s
affectional1953886a_ffe__c_tional
aggregational1662226aggre__gational
agitational1244826a_gi___tational
altercation1347016alt_e_rcation__
altercations1446366alt_e_rcation_s
antedating1277546ant_ed__ati_n_g
antenuptial1352066ant_enu_pti__al
anticipation1668276anti_cipation__
anticipations1757486anti_cipation_s
anticlinal1246376anti___c_li_nal
antidefamation2061486antidefamation__
antidilution1383836anti_dilution__
antielectron1463446antielec_tron__
antielectrons1562976antielec_tron_s
antievolution1662666antievolution__
antifriction1773986antifric_tion__
antiquating2146426anti_qu_ati_n_g
antirejection2283206antirejec_tion__
antispeculation19102006antispeculation__
arbitrational1553176arbi__trational
articulation1447976arti_culation__
articulations1546736arti_culation_s
aspirational1454996aspi___rational
attentional1154206a_tte___ntional
attenuation1144186a_ttenu_ation__
attenuations1243806a_ttenu_ation_s
attributional1562196attribu__tional
avocational1645176a____vocational
coeducation1646236__coeducation__
coeducationally23102336__coeducationally
coeducations1745856__coeducation_s
configurational2162196confi_gurational
education12310206____education__
educationally1963306____educationally
educations1339226____education_s
equational1945606____equ_ational
ideational1146486___i_d_eational
inflectional1754366infle__c_tional
institutional1353496insti_tu__tional
instructional1555076in_struc_tional
intentional11128836int_e___ntional
interjectional23195586int_erjectional
internationals1454236int_e_rnationals
interrogational1693906interrogational
intersectional16146236int_ersectional
intonational1255996int___onational
introduction1555786introduc_tion__
introductions1655136introduc_tion_s
intuitional1155276int___u_itional
invitational1554896invi___tational
invocational1754416___invocational
jurisdictional2471166jurisdic_tional
maturational1454176mat___urational
mediational1445626___med_iational
miseducation1793456_miseducation__
miseducations18113296_miseducation_s
motivational1753906moti___vational
navigational1653286navi___gational
negational1147156_n__e__gational
nonvocational1853686_n_onvocational
nutational1047036_n____utational
orientational1353776_orie_ntational
overeducation1955356overeducation__
overeducations2054956overeducation_s
participational2171876parti_cipational
prevocational2054016__prevocational
productional1794706__produc_tional
redactional1454346___redac_tional
reeducation1445936__reeducation__
reeducations1545466__reeducation_s
reputational1474576___reputational
situational1144586__si_tu_ational
transductional1782506transduc_tional
unsensational1353646un_se_nsational
untraditional1463856untrad__itional

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 Filter178691950240.1061685764.2
2DLD Change Limit95024947.03313511.2
3Display Results94940.0761236.8
 (SQL Overall)178691947.21524766.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.