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

29 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
profoundness185161(None) 
profoundest1752922profound_est
profoundnesses2061492profoundnesses
profaneness1653583prof_aneness
profounder1643323profound_e_r
profounds1543933profound___s
profuseness1653043prof_useness
propounders1643263propound_ers
proudness1246693pr__ou_dness
rotundness1143403_ro_tundness
roundness1047013_r__oundness
boundness1235944___boundness
cofounders1643334_cofound_ers
crookedness1852414cro_okedness
fondness1237214___fo_ndness
groundless1243474gr__oundless
porousness1248444p_orou_sness
profound1444924profound____
profoundly1951794profound__ly
proneness11310444pr__o_neness
pronouncers1563284pronoun_cers
pronounces1454994pronoun_ce_s
propounded1643504propound_e_d
propounder1543824propound_e_r
propounds1444964propound___s
rootedness1144904_ro_otedness
soundness1036964___soundness
unsoundness1253104_unsoundness
uprootedness1562694upro_otedness

Search took 8 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 Filter1786911247900.403443402.0
2DLD Change Limit124790297.12617511.9
3Display Results29290.0161812.5
 (SQL Overall)178691297.54523683.4
 
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.