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

66 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
semidarknesses216129(None) 
semidarkness19101332semidarkne_s_s
darknesses1537014____darknesses
secondarinesses1861564secondarinesses
sedatenesses1346964se__datenesses
smartnesses1337144s_m__artnesses
solitarinesses1452974solitarinesses
starknesses1545884s___tarknesses
danknesses1536255____danknesses
dearnesses1139585de___ar_nesses
decidednesses1853895decid_ednesses
demurenesses1544755dem__urenesses
exemplarinesses2661185exemplarinesses
familiarnesses1971785familiar_nesses
femalenesses1746865fem__alenesses
femininenesses1952995femininenesses
fetidnesses1546655fetid___nesses
gelidnesses1355985gelid___nesses
humidnesses1744585humid___nesses
mirinesses121512315__mi__rinesses
modernnesses1543865__modernnesses
nearnesses1039105ne___ar_nesses
ordinarinesses1552355ordinarinesses
peartnesses1338745pe___artnesses
remissnesses1344955remi__ssnesses
salutarinesses1462775salutarinesses
scarinesses1339905s___carinesses
seaminesses13310755se___aminesses
seasicknesses1873075se_asicknesses
securenesses1445675se__curenesses
seedinesses1259205se_ed__inesses
selfsamenesses1892145selfsamenesses
sempstresses1552205sempstr__esses
separatenesses1654265separatenesses
seriousnesses1249885seri_ousnesses
severenesses1545615se__verenesses
sexinesses1739215sexi____nesses
sharpnesses1645235s___harpnesses
sicknesses1636765s__i__cknesses
sidednesses1347105s__id_ednesses
slacknesses1745245s___lacknesses
slendernesses1453135slender_nesses
slicknesses1745195s_li__cknesses
sluggardnesses1761285sluggardnesses
smallnesses1344965s_m__allnesses
smarminesses1645105s_m__arminesses
smudginesses1643355s_mud_ginesses
snidenesses1248655s_nid__enesses
solidnesses1238105solid___nesses
sombernesses1643615som_ber_nesses
sparenesses1339175s___parenesses
specialnesses1753865speci_a_lnesses
squarenesses2144975s__quarenesses
staidnesses1237195staid___nesses
stalwartnesses1751295stalwartnesses
swartnesses1436715s___wartnesses
tearinesses11311695te___arinesses
temporarinesses1961985temporarinesses
tendernesses1345075te_nder_nesses
tepidnesses1445385tepid___nesses
timidnesses1445145timid___nesses
tumidnesses1444615tumid___nesses
venialnesses1555705veni_a_lnesses
weaknesses1735465we___a_knesses
wearinesses14310215we___arinesses
weirdnesses1545215we_i__rdnesses

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 Filter178691950240.360496363.9
2DLD Change Limit95024666.64014310.8
3Display Results66660.0461434.8
 (SQL Overall)178691667.04625360.6
 
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.