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 “intentional” 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
intentional1112884(None) 
intensional11146561intensional
attentional1154202attentional
insertional1147462insertional
intention9412012intention__
intentionally1655982intentionally
intentions10411402intention_s
international1357672international
intestinal1047512intesti_nal
intonational1256002intonational
intuitional1155292intuitional
unintentional1363422unintentional
antinational1297483antinational
conventional1757163conventional
extensional1854183extensional
ideational1146503i_deational
indention1049513indention__
indentions1149063indention_s
inflectional1754383inflectional
intension948493intension__
intensionally1654393intensionally
intensions1048403intension_s
intentionality17113453intentionality
interactional1557003interactional
internationals1454243internationals
intertidal1147713interti_dal
interzonal1946813inte_rzonal
invention1248333invention__
inventions1348313invention_s
tensional946213__tensional
affectional1953894affectional
annexational1953264annexational
antennal856354anten___nal
antirational1278494antirational
ascensional1362774ascensional
attention946104attention__
attentions1045984attention_s
attritional1154244attritional
binational1246374bin__ational
bisectional1554644bisectional
citational1266464cit_ational
conceptional1856914conceptional
connectional1646724connectional
contention12412224contention__
contentions13412094contention_s
convectional1947044convectional
deceptional1654774deceptional
dentinal939504__denti_nal
detention10169544detention__
detentions11148804detention_s
dimensional1453044dimensional
directional1445444directional
distention11158874distention__
distentions12178844distention_s
distortional1353484distortional
exceptional2254444exceptional
identical1246314i_denti_cal
inattention1152724inattention__
inattentions1252604inattention_s
incantational1553564incantational
incenting12912064incenti_n_g
inception1348694inception__
inceptions1448534inception_s
inclinational1553934inclinational
indenting11911264indenti_n_g
indicational1545754indicational
inertial8411724in_erti__al
infection14410474infection__
infections15510234infection_s
ingestion10137484ingestion__
ingestions1197594ingestion_s
inhalational1553044inhalational
injection1838654injection__
injections1948664injection_s
innovational1553834innovational
insentience1355534insentience
insentient1049424insentien_t
insertion9410594insertion__
insertions10410344insertion_s
institutional1353504institutional
instructional1555094instructional
intending1139984intendi_n_g
intensionality17152954intensionality
interionic1248254inte_rionic
interjectional23195604interjectional
interlocal1247094inte_rlocal
intermodal1346184inte_rmodal
internal8414084inte___rnal
internationally1873714internationally
interneuronal1362694interneuronal
internodal1145874inte_rnodal
interregional1453764interregional
interrenal1049814inte_rrenal
intersectional16146254intersectional
interstitial1255634interstitial
intertill9410424interti__ll
intertrial1049514intert_rial
intertribal1354684intertribal
intestinally1556014intesti_nally
intestine9411854intesti_n_e
intestines10410254intesti_nes
intinction1247784intinction__
intinctions1347004intinction_s
intonation10410264intonation__
intonations1149524intonation_s
intrazonal1954004int_razonal
intuition947624intuition__
intuitions1047294intuition_s
inventing13109974inventi_n_g
inventorial1453984inventorial
invitational1554904invitational
invocational1754414invocational
involutional1553574involutional
irrational1047214i_rrational
mutational1246514mut_ational
national8311534_n__ational
negational1147154_negational
nonnational11107834_nonnational
nontonal849744_n_ont_onal
notational1048124_notational
notional849404_n__otional
nutational1047044_nutational
nutritional1154784nutritional
potential1148534potenti__al
retention91611484retention__
retentions101611114retention_s
rotational1048094rot_ational
sectional1149424__sectional
sentential1047544sententi__al
septentrional1581284septentrional
situational1144584situational
stational948514_st_ational
tuitional946054__tuitional
unemotional1353494unemotional
unintentionally1872744unintentionally
unmentionable1753674unmentionable
unsensational1353664unsensational

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.65617192.6
3Display Results1371370.0801712.5
 (SQL Overall)1786911379.15619516.3
 
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.