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

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

97 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
invitations144905(None) 
incitations13310881incitations
invitation13410021invitation_
cavitations1647842cavitations
imitations1259962i_mitations
incitation12312222incitation_
indications14310972indications
infixations2146692infixations
initiations11410722in_itiations
intimations13411882intimations
invitational1554892invitational
invitationals1652732invitationals
invocations1647062invocations
irritations1147832irritations
levitations1448292levitations
agitations11310063_agitations
animations12312193an_imations
annotations1146883annotations
aviations12311553_avi_ations
capitations1549853capitations
cavitation1549133cavitation_
citations11312503__citations
cogitations1448903cogitations
deviations14311163devi_ations
divinations15128413divinations
dubitations1456673dubitations
equitations2047443equitations
excitations2049003excitations
gravitations1644763gravitations
habitations1646883habitations
hesitations1448543hesitations
imitation11510853i_mitation_
imputations1546353imputations
incantations1446643incantations
inclinations1448753inclinations
incubations1547303incubations
indagations1345403indagations
indentations1347883indentations
indexations1946023indexations
indication13312033indication_
indictions1339303indi_ctions
indignations1446043indignations
indurations1249583indurations
infatuations1544433infatuations
infestations1546623infestations
infiltrations1653903infiltrations
infixation2047533infixation_
inflations13310323in_flations
inhabitations1853723inhabitations
inhalations14126743inhalations
inhibitions1644823inhibitions
inhumations1666033inhumations
initiation10412103in_itiation_
innovations1445263innovations
insanitations13136473insanitations
insinuations12136423insinuations
insolations1149183insolations
inspirations1447293inspirations
instigations1348243instigations
institutions1244733institutions
insulations11310233insulations
intimation12413043intimation_
intinctions1347003intinctions
intonations1149523intonations
intubations1346833intubations
inundations12125533inundations
invaginations1755083invaginations
invalidations1745623invalidations
invasions12115413inv__asions
inventions1348313inv_entions
invigilations1764483invigilations
invigorations1753913invigorations
invitatory1644773invitat_ory
invocation1547543invocation_
involutions1445903involutions
iodinations1268843iodinations
ionizations2049893ionizations
irrigations1246943irrigations
irritation1048973irritation_
levigations1546213levigations
levitation1349443levitation_
limitations1348183limitations
meditations1449333meditations
miscitations1647053miscitations
natations91412493_n_atations
navigations1545203navigations
nictations1278313_nictations
nidations1039213_n_idations
nitrations10312033_n_itrations
notations91512973_n_otations
nutations91411763_n_utations
obviations1545463obvi_ations
recitations13314193recitations
sanitations11410843sanitations
vindications1845673vindications
visitations1447673visitations
vitiations1338743__vitiations

Search took 7 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 Filter1786911216330.1561145455.1
2DLD Change Limit121633976.61018401.4
3Display Results97970.0462108.7
 (SQL Overall)178691976.81226231.8
 
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.