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

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

53 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
fantastications206205(None) 
fantastication1962231fantastication_
fantasticating2061882fantasticati_ng
fantasticates1882453fantasticat__es
fantasticality2261664fantasticali_ty
fantasticalness2071744fantasticalness
fantasticate1792864fantasticat___e
fantasticated1982354fantasticat__ed
fantasticoes1752084fantastic___oes
mastications1649414___mastications
aestivations1547485_a__estivations
anticipations1757495_ant_icipations
assassinations13102045_assassinations
attestations1244465_attest__ations
authentications2072125_authentications
bastardizations27112875bastardizations
canalizations24410435can_a_lizations
castigations1547205___castigations
constipations1747685con__stipations
contaminations1886105conta_minations
contestations1547745contest__ations
dandifications2145435dan_difications
domestications19143995_domestications
fabrications1945935f___abrications
factorizations2855765fact_orizations
falsifications2244975fa_lsifications
fantastical1654425fantastica____l
fantastically2155075fantastica__lly
fantastico1553385fantastic___o__
fantastics1544375fantastic_____s
fasciations1646265f___asci_ations
fascinations1746375f___ascinations
fenestrations1695405fen_est_rations
finalizations2549255fin_a_lizations
fortifications2286215fort_ifications
fustigations1644765f___ustigations
gentrifications2175045gentrifications
haruspications2151625ha_ruspications
inactivations1854245_in_activations
instantiations1493535instanti_ations
instigations1348245_in__stigations
intoxications22135685_int_oxications
investigations1853725_investigations
mastication15610295___mastication_
parasitizations2693565pa_rasitizations
pontifications2187925pont_ifications
quantifications29114405quant_ifications
ratifications1899785ra_t_ifications
rustications1448565___rustications
sanctifications2254135sanctifications
sanitizations2248555san__itizations
sophistications2262555sophistications
vandalizations2756315vanda_lizations

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 Filter178691658740.313570897.8
2DLD Change Limit65874534.40614951.0
3Display Results53530.0331606.1
 (SQL Overall)178691534.75237603.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.