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

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

91 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
invitational155490(None) 
invitationals1652741invitationals
indicational1545752indicational
invitation13410022invitation__
invitations1449052invitation_s
invocational1754412invocational
levitational1553632levitational
agitational1244843_agitational
antinational1297483antinational
antirational1278493antirational
citational1266463__citational
gravitational1762553gravitational
incantational1553563incantational
incitation12312223incitation__
incitations13310883incitation_s
inclinational1553933inclinational
inhalational1553043inhalational
innovational1553833innovational
inspirational1554413inspirational
institutional1353503institutional
intonational1256003intonational
involutional1553573involutional
irrotational1254023irrotational
limitational1453543limitational
navigational1653293navigational
notational1048123_n_otational
nutational1047043_n_utational
adaptational1572794adaptational
annexational1953264annexational
arbitrational1553184arbitrational
aspirational1455004aspirational
avocational1645184_avocational
binational1246374__binational
cavitation1549134cavitation__
cavitations1647844cavitation_s
connotational1554154connotational
convocational2054474convocational
derivational1654264derivational
dilatational1352774dilatational
gestational1245114_gestational
ideational1146504i__deational
imbibitional1861704imbibitional
imitation11510854i_mitation__
imitations1259964i_mitation_s
immigrational1851934immigrational
indication13312034indication__
indications14310974indication_s
infixation2047534infixation__
infixations2146694infixation_s
inflectional1754384inflectional
informational1854344informational
initiation10412104in_itiation__
initiations11410724in_itiation_s
inquisitional2272834inquisitional
insertional1147464in_sertional
intentional11128844in_tentional
interactional1557004interactional
international1357674international
intimation12413044intimation__
intimations13411884intimation_s
intuitional1155294in_tuitional
investigational1961934investigational
invitatory1644784invitat_o_ry
invocation1547544invocation__
invocations1647064invocation_s
irrational1047214i__rrational
irritation1048974irritation__
irritations1147834irritation_s
lactational1344654_lactational
levitation1349444levitation__
levitations1448294levitation_s
mediational1445644medi_ational
motivational1753914motivational
mutational1246514__mutational
narrational1145444_narrational
national8311534_n___ational
negational1147154_n_egational
nonnational11107834_nonnational
nonrational11109124_nonrational
nonvocational1853704nonvocational
ovational1246854_ov__ational
radiational1245954radi_ational
reputational1474584reputational
rotational1048094__rotational
salutational1253324salutational
situational1144584__situational
stational948514___stational
variational1444784vari_ational
vegetational1653374vegetational
vibrational1644364__vibrational
vocational1546954__vocational

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 Filter1786911247900.393454684.5
2DLD Change Limit124790916.56019022.9
3Display Results91910.0631444.4
 (SQL Overall)178691917.01625469.1
 
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.