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

67 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
downwardnesses229160(None) 
downwardness2061842downwardne_s_s
awkwardnesses2451823_awkwardnesses
forwardnesses20123263fo_rwardnesses
inwardnesses1654673__inwardnesses
outwardnesses1752613_outwardnesses
backwardnesses2661304backwardnesses
downinesses1536144down___inesses
dwarfnesses1843294d___warfnesses
frowardnesses20112894_frowardnesses
untowardnesses1862334untowardnesses
unwarinesses1546154__unwarinesses
upwardnesses1843094__upwardnesses
waywardnesses2351764_waywardnesses
awarenesses1447255___awarenesses
awkwardness2251695_awkwardne_s_s
boundednesses1753935boun_dednesses
boundnesses1446625boun___dnesses
contrarinesses1674245contrarinesses
cowardlinesses2052515co__wardlinesses
darknesses1537015d____arknesses
deadnesses1238945d___ea_dnesses
dearnesses1139585d___ear_nesses
doggednesses1643705do__ggednesses
donenesses11310565do_n___enesses
donnishnesses1784115do_nnishnesses
dournesses1138245do___ur_nesses
dowdinesses1635725do__w_dinesses
downrightnesses238925downrightnesses
downwards1743835downward_____s
downwashes2051765downwa____shes
drearinesses1347445d__rearinesses
fondnesses1437705fo_n___dnesses
foolhardinesses2261065foolhardinesses
forwardness1853085fo_rwardne_s_s
haggardnesses1952255_haggardnesses
hardnesses141810545____hardnesses
hoarinesses14310225ho___arinesses
hornednesses1645515horn__ednesses
inwardness1443775__inwardne_s_s
jointednesses2174025join_tednesses
laggardnesses1652395_laggardnesses
lukewarmnesses2361005lukewarmnesses
momentarinesses1972345momentarinesses
nearnesses1039105___near_nesses
ornatenesses1257305_orn_atenesses
ornerinesses1246575_orn_erinesses
outwardness1552805_outwardne_s_s
pointednesses1654975poin_tednesses
roundednesses1554295roun_dednesses
roundnesses1247045roun___dnesses
sluggardnesses1761285sluggardnesses
solitarinesses1452975solitarinesses
soundnesses1247525soun___dnesses
stalwartnesses1751295stalwartnesses
stewardesses1651475_steward_esses
swartnesses1436715___swartnesses
towardlinesses1851915to__wardlinesses
unawarenesses1653735_unawarenesses
unharnesses1445435__unhar_nesses
voluntarinesses1862155voluntarinesses
wardresses1445415____wardresses
warinesses131514525____warinesses
warmnesses15167355____warmnesses
wearinesses14310215__w_earinesses
weirdnesses1545215__w_eirdnesses
wontednesses1645995wo_n_tednesses

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.393454684.5
2DLD Change Limit95024675.56317081.4
3Display Results67670.0431558.1
 (SQL Overall)178691675.99929786.8
 
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.