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

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

180 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
informational185434(None) 
conformational21153712conformational
deformational19122972deformational
information16147712information__
informationally2362462informationally
informations17127032information_s
reformational18113422reformational
confirmational21153393confirmational
innovational1553833inno_vational
international1357673international
intonational1256003into_national
invocational1754413invo_cational
antirational1278494antir_ational
conformation1947324conformation__
conformations2046724conformation_s
deformation1747664deformation__
deformations1846844deformation_s
formation1439424__formation__
formations1538204__formation_s
incantational1553564incantational
inclinational1553934inclinational
indicational1545754in_dicational
inflectional1754384inf_lectional
informatics1854104informati__cs
informative1965154informati__ve
informatively2453294informatively
informatorily2161584informat_orily
informatory1953464informat_o_ry
infuriation1448244infuriation__
infuriations1547444infuriation_s
inhalational1553044in_halational
inscriptional17173514inscriptional
insertional1147464inser__tional
inspirational1554414inspirational
instructional1555094instructional
interactional1557004interactional
internationals1454244internationals
invitational1554904in_vitational
involutional1553574invo_lutional
irrational1047214i___rrational
irrotational1254024irro_tational
narrational1145444_n_arrational
nonnational11107834_n_onnational
nonrational11109124_n_onrational
notational1048124_n_o_tational
perorational1446394peror_ational
reformation1648414reformation__
reformations1747604reformation_s
aberrational1453485_aberrational
affirmation1953685affirmation__
affirmations2053235affirmation_s
annexational1953265an_nexational
antinational1297485an_tinational
aspirational1455005aspir_ational
associational1552935associational
avocational1645185_avo_cational
binational1246375bin____ational
confirmation1946185confirmation__
confirmations2055675confirmation_s
confrontational2071595confrontational
connotational1554155conno_tational
conservational1955345conservational
consociational1853555consociational
conversational1954165conversational
convocational2054475convo_cational
disinformation2063335disinformation__
disinformations2173305disinformation_s
dissertational1562575dissertational
distortional1353485distor__tional
explorational2252555explor_ational
foraminal1444265__for_ami_nal
foundational1652855__foundational
fractional1547135__f_ractional
frictional1546255__f_rictional
generational1354825gener_ational
gyrational1444745__gyr_ational
hyperrational2153935hyperrational
ideational1146505i___deational
immigrational1851935immigrational
importation15147125importation__
importations16156145importation_s
incarnation1347465incarnation__
incarnations1446665incarnation_s
incurvation1646985incurvation__
incurvations1746385incurvation_s
induration11410615indur_ation__
indurations1249585indur_ation_s
inebriation1357245inebriation__
inebriations1456325inebriation_s
infarction1545795infar_ction__
infarctions1645025infar_ction_s
infatuation1444935infatuation__
infatuations1544435infatuation_s
inferential1457545inferenti__al
infestation1447045infestation__
infestations1546625infestation_s
infixation2047535inf_ixation__
infixations2146695inf_ixation_s
inflammation19132885inflammation__
inflammations20102545inflammation_s
inflation12311095inf__lation__
inflationary1852745inf__lationary
inflations13310325inf__lation_s
informal1355645inform_____al
informalities1864295informalities
informality1953895informali__ty
informant1446475informa___n_t
informants1544635informa___nts
informativeness2363155informativeness
informing1537025inform__i_n_g
infraction1557455inf_raction__
infractions1646965inf_raction_s
infuriating1546285infuriati_n_g
infuriatingly2062085infuriati_ngly
inhumation1567055in_humation__
inhumations1666035in_humation_s
innervation1447445innervation__
innervations1546925innervation_s
innovation1345645inno_vation__
innovations1445265inno_vation_s
inquisitional2272835inquisitional
insolation10410215inso_lation__
insolations1149185inso_lation_s
institutional1353505institutional
insurrectional1662605insurrectional
intentional11128845in__tentional
interjectional23195605interjectional
intermarginal1672905intermarginal
internationally1873715internationally
interregional1453765interregional
interrogational1693905interrogational
intersectional16146255intersectional
intimation12413045in_timation__
intimations13411885in_timation_s
intonation10410265into_nation__
intonations1149525into_nation_s
intrazonal1954005in_tr_a_zonal
intuitional1155295in__tuitional
invitationals1652745in_vitationals
invocation1547545invo_cation__
invocations1647065invo_cation_s
irrationals1154735i___rrationals
librational1344555_libr_ational
locational1246595__lo_cational
malformation1953325malformation__
malformations2053075malformation_s
maturational1454185matur_ational
migrational1444745_migr_ational
misinformation2172595misinformation__
misinformations2282585misinformation_s
national8311535_n____ational
navigational1653295_navigational
negational1147155_n__egational
nonemotional1453785_nonemotional
noninformation1973315noninformation__
noninformations2073135noninformation_s
nonnationals1294895_n_onnationals
nonvocational1853705nonvo_cational
notional849405_n_o___tional
nutational1047045_n__utational
nutritional1154785_nutr_itional
observational1853185observational
operational1347525_oper_ational
ovational1246855___o_vational
preformation1946475preformation__
preformations2045715preformation_s
probational1547085_pro_bational
promotional1555635_pro_motional
rational8412545____r_ational
recreational1455175_recreational
rotational1048095__ro_tational
subrational1345495_subr_ational
summational1553685__summational
supernational1555615supernational
unconditional1663465unconditional
unemotional1353495un__emotional
unsensational1353665unsensational
variational1444785__variational
vibrational1644365_vibr_ational
vocational1546955__vo_cational

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901808.82614138.9
3Display Results1801800.1261428.6
 (SQL Overall)1786911809.35819095.0
 
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.