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

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

46 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
paradoxicalness2771561paradoxicalness_
paradoxical2353255paradoxical_____
paradoxicality2971465paradoxical__ity
paradoxically2853715paradoxical___ly
practicalness1953325p_ra_cticalness_
radicalness1454585__rad__icalness_
diabolicalness1971296_diabolicalness_
fanaticalness1862736fana__ticalness_
ironicalness1463086_ir__onicalness_
palatialness1453246pala__ti_alness_
pharisaicalness2291226phar_isaicalness_
practicalnesses2162956p_ra_cticalnesses
radicalnesses16124146__rad__icalnesses
tyrannicalness19111686tyra_nnicalness_
allegoricalness1871097allegoricalness_
artificialness1971407_ar_tificialness_
cordialness1444777cor_d__i_alness_
criticalness1653507_cr__iticalness_
fanaticalnesses2082317fana__ticalnesses
fantasticalness2071747fantasticalness_
gradualness1352857_grad___ualness_
grammaticalness2271307grammaticalness_
historicalness1962137_historicalness_
illogicalness1662147__illogicalness_
ironicalnesses1662587_ir__onicalnesses
logicalness1453247____logicalness_
lyricalness1653017lyr____icalness_
methodicalness2271687_methodicalness_
palatialnesses1653397pala__ti_alnesses
parabolically2254007parabolical___ly
paradiddles1651667parad__iddl_e_s_
paradisical1653777paradisical_____
paradoxes19267307paradox_____e_s_
paramedicals19142777paramedical___s_
paranoically1956557parano_ical___ly
pardonableness1993237par_donableness_
pastoralness1453607pa_sto__ralness_
physicalness2272697p___hysicalness_
pictorialness1762527p_ictori_alness_
poeticalness1653457p___oeticalness_
practicableness2362707p_ra_cticableness_
prejudicialness277947p_rejudicialness_
proximateness2462457p_r__oximateness_
pyridoxines2452127pyridoxi___ne_s_
radicalises1445587__rad__icalises_
verticalness1754217ver___ticalness_

Search took 10 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.376475242.0
2DLD Change Limit95024469.36010152.1
3Display Results46460.0461000.0
 (SQL Overall)178691469.78218267.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.