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

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

81 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
thoroughnesses217187(None) 
thoroughbasses2371152thoroughbasses
thoroughness1952192thoroughne_s_s
roughnesses15105133___roughnesses
toughnesses15104483t___oughnesses
amorousnesses1547814amorou_snesses
odorousnesses1456734odorou_snesses
porousnesses1469284_porou_snesses
thorninesses1544394thor__ninesses
thoroughbass2161544thorough_bas_s
thoroughbraces2581184thoroughbraces
thoroughest18102874thorough_e_s_t
thoroughfares2371554thorough_fares
throatinesses1653274th_roatinesses
timorousnesses1655694timorou_snesses
atherogeneses1753775athero_gene_ses
boorishnesses1864315boor_ishnesses
boringnesses15105025_boring_nesses
canorousnesses16127065canorou_snesses
churlishnesses2252545churlishnesses
corruptnesses1752845_corruptnesses
decorousnesses1756565decorou_snesses
dolorousnesses1555785dolorou_snesses
droughtinesses1951835__droughtinesses
enormousnesses1655875enormou_snesses
foreignnesses1752755_foreignnesses
ghoulishnesses2152285ghoulishnesses
gloriousnesses1556915gloriou_snesses
grogginesses1544075__grogginesses
grouchinesses1942655__grouchinesses
harshnesses1745855_har__shnesses
highnesses1746085_h___ighnesses
hirsutenesses1653595_hirsutenesses
hoggishnesses21143655_hoggishnesses
hoodednesses1744495_ho_odednesses
hornednesses1645515_hor_nednesses
horninesses1459005_hor__ninesses
horridnesses1644465_hor_ridnesses
horsinesses1439555_hor__sinesses
hugenesses1437145_h___ugenesses
humorousnesses1955445humorou_snesses
joyousnesses2244665_joyou_snesses
morosenesses1446865_moro_senesses
onerousnesses1348975onerou_snesses
orogeneses1147865__oro_gene_ses
profoundnesses2061495profoundnesses
proudnesses1447505__prou_dnesses
rigorousnesses1565855rigorou_snesses
riotousnesses1357305riotou_snesses
roughness1345765___roughne_s_s
roundnesses1247045___roundnesses
shortnesses1446795shor___tnesses
smoothnesses1762655smo_o_thnesses
sonorousnesses1356515sonorou_snesses
sporogeneses1554855sporo_gene_ses
tearfulnesses1645535tearfu_lnesses
tediousnesses1447765tediou_snesses
tenuousnesses1357055tenuou_snesses
thievishnesses2362195thievishnesses
thingnesses1545195th__ing_nesses
thirstinesses1642585thir_stinesses
thoroughbrace2471205thoroughbrace_
thoroughbred2261515thorough__bred
thoroughbreds2371265thorough_breds
thorougher1752605thorough____er
thoroughfare2271585thorough_fare_
thoroughpins2161815thorough__pins
thoroughworts2371265thorough_worts
threadinesses1753345th_readinesses
thriftinesses1952315th_riftinesses
torridnesses1344655t_or_ridnesses
tortuousnesses1455765t_ortuousnesses
touchinesses1744245t___ouchinesses
toughness1355095t___oughne_s_s
trignesses1188215t__r_ig_nesses
truenesses1039315t__r_u_enesses
uncouthnesses1862815_uncouthnesses
uxoriousnesses2156305uxoriou_snesses
vaporousnesses1956005vaporou_snesses
vigorousnesses1865525vigorou_snesses
wrongnesses1544925__wrong_nesses

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.360496363.9
2DLD Change Limit95024816.09315595.6
3Display Results81810.0631285.7
 (SQL Overall)178691816.51627423.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.