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 “anticipations” 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.

83 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
anticipations175749(None) 
anticipation1668281anticipation_
anticipating1756262anticipati_ng
anticipators1654672anticipat_ors
participations2054532participations
anglicizations26123333anglicizations
annihilations1653993annihilations
anticipates1586983anticipat__es
anticipator1555093anticipat_o_r
anticipatory1953713anticipat_ory
antiquations2146243anti_quations
articulations1546733articulations
intimidations1686663intimidations
participation1955253participation_
vaticinations1845033vaticinations
abdications1657654abdic__ations
acetifications2146054acetifications
activations1669264act__ivations
affiliations1844184affili_ations
anglicization25113604anglicization_
animations12312194an___imations
annihilation1594504annihilation_
annunciations1572654annunci_ations
anodizations2276924an_odizations
anticipant1456824anticipa___nt
anticipants1555064anticipa__nts
anticipatable1981914anticipatable
anticipate1467734anticipat___e
anticipated1665634anticipat__ed
antidilution1383844antidilution_
antiquation2047424anti_quation_
antivitamins1763674antivitami_ns
arabicizations2753904arabicizations
articulation1447974articulation_
assimilations1555204assimilations
associations1445754associ_ations
atomizations2348474a_tomizations
autoxidations2153554autoxidations
cantillations1545734canti_llations
citifications2048544citifications
dandifications2145434dandifications
denticulations1753914denticulations
elicitations1446804_elicitations
emancipations1953744emancipations
enunciations1445094enunci_ations
eroticizations25115784eroticizations
extirpations2174284exti_rpations
felicitations1874584felicitations
gallicizations2673904gallicizations
incitations13310884in__citations
indications14310974indic__ations
initiations11410724in_iti_ations
intimations13411884int__imations
intimidation1547364intimidation_
intoxications22135684intoxications
invigilations1764484invigilations
laicizations2347414_laicizations
latinizations22159014latinizations
mastications1649414mastic__ations
nazifications2745524nazifications
nictations1278314_n_ic_tations
notifications1848234notifications
officiations2053504offici_ations
optimisations17153444optimisations
optimizations26155714optimizations
participating2053374participati_ng
participational2171884participational
participators1963064participat_ors
plasticizations2853534plasticizations
pontifications2187924pontifications
quantifications29114404quantifications
ratifications1899784ratifications
ratiocinations1674134ratiocinations
reticulations1556614reticulations
sanctifications2254134sanctifications
sanitizations2248554san_itizations
solicitations1544894solicitations
titivations1446264__titivations
unifications1748044un_ifications
unitizations2147454un_itizations
urtications1348034urtic__ations
utilizations2148894_utilizations
vaticination1745764vaticination_

Search took 5 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.360496363.9
2DLD Change Limit95024834.54620902.8
3Display Results83830.0601383.3
 (SQL Overall)178691834.96635982.9
 
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.