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

39 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
splendiferously248106(None) 
splendiferous1961732splendiferous__
pestiferously2162064_p_estiferously
seleniferous1562224selen_iferous__
slanderously1653114s_land__erously
plenteously1653765_plen__te_ously
ponderously1754275_p_ond__erously
serendipitously2171235serendipitously
splendorous1452075splend__orous__
splendrous1353185splend___rous__
amentiferous1762086_amentiferous__
argentiferous1761366argentiferous__
endogenously1762566___endogenously
generously1445626__gen___erously
indigenously17103196___indigenously
lecherously1993186__le__cherously
ludicrously1753276__l_udi_crously
odoriferously2061576__odoriferously
pestiferous1653026_p_estiferous__
plentifully1952736_plentif___ully
plunderous1343826_plund__erous__
preposterously2171316_preposterously
salutiferous1571926sal_utiferous__
seditiously1555586s__e_di_tiously
seminiferous1762146semin_iferous__
slanderous1144896s_land__erous__
slaughterously2191406s_laughterously
slenderly1343456s_lend__er___ly
somniferous1652646s_omn_iferous__
speciously1746346sp_e_ci___ously
splendider1442406splendider_____
splendidest1552316splendide___s_t
splendidly1751986splendi_____dly
spontaneously1862376sp_ontane_ously
stoloniferous1661306stolon_iferous__
sulfurously1753156sul____furously
thunderously1972436_thund__erously
ungenerously1662876ungen___erously
vociferously2352406___vociferously

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 Limit95024398.72010897.2
3Display Results39390.0301300.0
 (SQL Overall)178691398.86020168.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.