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

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

37 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
severenesses154561(None) 
securenesses1445672securenesses
serenenesses12117112serenenesses
severeness1346122severene_s_s
adversenesses1753393adversenesses
aversenesses1545663_aversenesses
beerinesses1398923be_erinesses
clevernesses1743633clever_nesses
covertnesses1746333covertnesses
demurenesses1544753demurenesses
diversenesses1754103diversenesses
eerinesses10612603_e_erinesses
evennesses1345943_eve_nnesses
governesses1546723gover_nesses
invernesses1447033inver_nesses
leerinesses11119483le_erinesses
levelnesses1445553leve_lnesses
overtnesses1448713_overtnesses
perversenesses1952663perversenesses
savagenesses1644223savagenesses
savorinesses1544613savorinesses
sedatenesses1346963sedatenesses
seedinesses1259203se_edinesses
seeresses939053se_er__esses
selectnesses1446113selectnesses
servilenesses1646303servilenesses
sheernesses1445843sheer_nesses
silverinesses1643693silverinesses
sincerenesses1554733sincerenesses
sobernesses1346593sober_nesses
sorenesses101313493s__orenesses
sparenesses1339173s_parenesses
squarenesses2144973squarenesses
sternnesses1146633s_ternnesses
superbnesses1695563superbnesses
surenesses101212213s__urenesses
sveltenesses1545233sveltenesses

Search took 6 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.733243780.4
2DLD Change Limit95024374.81319743.2
3Display Results37370.0331121.2
 (SQL Overall)178691375.57932029.2
 
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.