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

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
pendulousness165419(None) 
pendulousnesses1854232pendulousnesses
sedulousness1365022se_dulousness
credulousness1653603credulousness
emulousness1355323_e_mulousness
nebulousness1454703ne_bulousness
penuriousness1557173penuriousness
perilousness1457783pe_rilousness
ponderousness16105333ponderousness
populousness1654233p_opulousness
sensuousness1155333sensu_ousness
tenuousness1146673ten_u_ousness
venturousness1655183venturousness
arduousness1255774_ardu_ousness
bibulousness1653764_bibulousness
deciduousness1754024decidu_ousness
endlessness1245484_end_lessness
enormousness1455364_enormousness
enviousness1447644_en_viousness
fabulousness1754024_fabulousness
garrulousness1493334garrulousness
generousness1356964gen_erousness
jealousness1845324je__alousness
mendaciousness1954244mendaciousness
meticulousness1872674meticulousness
pendulous1243854pendulou____s
perniciousness1855304perniciousness
perviousness1747654pe_rviousness
plenteousness1554554plen_teousness
querulousness2253114querulousness
scandalousness1792144scandalousness
sedulousnesses1455544se_dulousnesses
sinuousness1146914sin_u_ousness
tediousness1247764te_d_iousness
tenaciousness1556544tenaciousness
tremulousness1563634tremulousness
venomousness1754694ven_omousness
wondrousness1655304wond_rousness
zealousness2055194ze__alousness

Search took 7 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.1531167915.0
2DLD Change Limit95024396.51614583.2
3Display Results39390.0331181.8
 (SQL Overall)178691396.70226662.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.