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

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

64 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
fantasticalness207171(None) 
fanaticalness1862692fan_a_ticalness
fantasticates1882453fantastica_te_s
fanaticalnesses2082274fan_a_ticalnesses
fantastical1654404fantastical____
fantasticality2261664fantastical_ity
fantastically2155064fantastical__ly
fantasticate1792854fantastica_te__
fantasticated1982354fantastica_te_d
fantastications2062054fantastications
fantasticoes1752084fantastic__oe_s
dogmaticalness2071475dogma_ticalness
fantasticating2061885fantastica_ting
fantastication1962235fantastica_tion
fantastics1544375fantastic_____s
finicalness1653595fin____icalness
grammaticalness2271265gramma_ticalness
palatialness1453205pa_la_ti_alness
practicalness1953285__practicalness
antsiness937846_ant_s_i___ness
artificialness1971396_art_ificialness
criticalness1653466___criticalness
distastefulness1971776distastefulness
ethicalness1653346__et__hicalness
factitiousness1994306fact_itiousness
factualness1652986f___act_ualness
fanatical1446486fan_a_tical____
fanatically1948276fan_a_tical__ly
fanaticizes2553426fan_a_tic_ize_s
fancifulness2053756fan___cifulness
fantasias1286996fantas_i_a____s
fantasies1298856fantas_i____e_s
fantasises1395886fantas_i___se_s
fantasizers2392886fantas_i___zers
fantasizes2295466fantas_i___ze_s
fantastic1446146fantastic______
fantastico1553386fantastic_____o
fantasylands196956fantas_yla_n_ds
fatalness1245766f___a_t__alness
fattiness12239376fa_t__ti___ness
franticness1643586f__rantic__ness
historicalness1962116hist_oricalness
identicalness1662646__identicalness
initialness1155726_in__iti_alness
materialness1454656ma_t_eri_alness
methodicalness2271676_methodicalness
nastiness92310576__n_asti___ness
naturalness1153946__n_a_turalness
nonsensicalness1771366nonsensicalness
paradoxicalness2771546paradoxicalness
pastoralness1453596___pastoralness
pharisaicalness2291206pharisaicalness
physicalness2272686__phys_icalness
poeticalness1653436___poeticalness
radicalness1454546___ra_dicalness
substantialness1772156substanti_alness
tastefulness1554836___tastefulness
tastiness92311146___tasti___ness
tentativeness1654996tenta_ti_veness
typicalness1852556___t_ypicalness
tyrannicalness19111666_tyrannicalness
unnaturalness1362256_unna_turalness
verticalness1754186___verticalness
whimsicalness2361646_whims_icalness

Search took 9 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.1101624463.6
2DLD Change Limit95024648.68610939.9
3Display Results64640.0461391.3
 (SQL Overall)178691648.84220209.3
 
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.