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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
lightsomenesses216182(None) 
lightsomeness1982012lightsomene_s_s
lissomenesses1453473li__ssomenesses
loathsomenesses20112113loathsomenesses
irksomenesses1953194_i_rksomenesses
lightfastnesses2261434lightfastnesses
lightnesses1546144light____nesses
lonesomenesses1653794l_onesomenesses
longsomenesses1763084l_ongsomenesses
righteousnesses1963394righteousnesses
tiresomenesses1653344ti_resomenesses
toothsomenesses2061904toothsomenesses
winsomenesses1854044wi__nsomenesses
awesomenesses1853385__awesomenesses
fearsomenesses1953195_fearsomenesses
flightinesses2053135flight___inesses
footsorenesses1792225_footsorenesses
fulsomenesses1853125__fulsomenesses
gamesomenesses1962725_gamesomenesses
gladsomenesses1892385_gladsomenesses
gruesomenesses1753075_gruesomenesses
handsomenesses2062705_handsomenesses
lissomeness1353355li__ssomene_s_s
litenesses10513025li__t___enesses
lithenesses1447315li__t__henesses
littlenesses1246095li__t_tlenesses
loathsomeness1862275loathsomene_s_s
mightinesses1844385might___inesses
noisomenesses1554245__noisomenesses
rightfulnesses2174465right_fulnesses
rightnesses1546235right____nesses
sightlessnesses1755035sightlessnesses
sightlinesses1743865sight__linesses
slightnesses1654625slight____nesses
tightnesses1565585tight____nesses
toilsomenesses1662705_toilsomenesses
wearisomenesses2062415wearisomenesses
wholesomenesses2361915wholesomenesses
worrisomenesses2062275worrisomenesses
adhesivenesses2155056_adhesivenesses
almightinesses2051836almight___inesses
brightnesses1844186bright____nesses
chastenesses1746316__chas_tenesses
citizenesses2345676ci__t_izenesses
cohesivenesses2256206_cohesivenesses
delightednesses2162536delight__ednesses
diffusenesses2052826diffus__enesses
diffusivenesses25103866diffusivenesses
dilatorinesses1552056dilat_orinesses
dilutenesses1346116dilut___enesses
ditsinesses12108766di__ts__inesses
diversenesses1754106divers__enesses
divisivenesses2154966di_visivenesses
extremenesses2252886__extremenesses
fictivenesses2157126fi_ct_ivenesses
finitenesses1557726finit___enesses
frightfulnesses2562906fright_fulnesses
fugitivenesses2154456fugit_ivenesses
gamenesses1368986__g___amenesses
ghastlinesses1742746__ghastlinesses
ghostlinesses1742496__ghostlinesses
gloominesses1544126__g_loominesses
gonenesses11310256__g___onenesses
gutsinesses12128156__guts__inesses
highnesses1746086high_____nesses
hirsutenesses1653596hi__rsutenesses
histogeneses1653756hi_st_ogene_ses
homeynesses1984816___h__omeynesses
hominesses15510866___h__ominesses
ignoblenesses1653686_ig_noblenesses
illusivenesses1755786_illusivenesses
illusorinesses1461656_illusorinesses
incisivenesses1966686_incisivenesses
insanenesses1246876_i__nsanenesses
intensenesses1356056_i_ntensenesses
invasivenesses2056026_invasivenesses
iratenesses11411446_irat___enesses
irksomeness1752686_i_rksomene_s_s
knightlinesses2282446knight__linesses
lamenesses12610566l_____amenesses
latenesses10413366l__at___enesses
laughablenesses2183146laugh_ablenesses
lecherousnesses20123856lecherousnesses
licitnesses1346416licit____nesses
lifelikenesses2152396li_felikenesses
lighteners1444986light___ene__rs
lightfastness2061316lightfastne_s_s
lighthouses1852976lightho____uses
lightness13107436light____ne_s_s
lightsome15114176lightsom_____e_
lightsomely2051746lightsom__e__ly
likablenesses1995446li__kablenesses
likenesses1449536li_____kenesses
liltingnesses1453576li_lt_ingnesses
liminesses121310856li_____minesses
limitednesses1654016limit__ednesses
limitlessnesses1654286limitlessnesses
limpnesses14116656li_____mpnesses
lionesses939436li____o__nesses
lipogeneses1444406li___pogene_ses
listlessnesses1266936li_stlessnesses
literalnesses1355246li__teralnesses
literatenesses1464786li_teratenesses
litigiousnesses1684116litigiousnesses
livablenesses18125846li__vablenesses
livenesses13411076li_____venesses
lonenesses10311346l_____onenesses
lonesomeness1454116l_onesomene_s_s
longsomeness1553156l_ongsomene_s_s
loosenesses1147246l____oosenesses
lustrousnesses1355756l_ustrousnesses
minutenesses1476176minut___enesses
negativenesses1855856negat_ivenesses
nighnesses1446466nigh_____nesses
nightdresses1752206night___dresses
otiosenesses1245706___otiosenesses
piggishnesses2043286piggis__hnesses
pigheadednesses23142946pigheadednesses
piteousnesses1557176pi__teousnesses
righteousness1763926righteousne_s_s
rigorousnesses1565856rig_orousnesses
riotousnesses1357306ri_ot_ousnesses
samenesses12410856_____samenesses
selfsamenesses1892146_selfsamenesses
solenesses10412706_____solenesses
sorenesses101313496_____sorenesses
tamenesses1259976____t_amenesses
tiresomeness1453606ti_resomene_s_s
toothsomeness1861946toothsomene_s_s
unchastenesses1962926unchas_tenesses
vigorousnesses1865526vig_orousnesses
virtuousnesses1795296vi_rtuousnesses
weightinesses2052906weight___inesses
welcomenesses2052586__welcomenesses
wholenesses1745806__wh__olenesses
winsomeness1653656wi__nsomene_s_s
wisenesses13310826wi___s__enesses

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.376475242.0
2DLD Change Limit950241376.76314050.6
3Display Results1371370.0931473.1
 (SQL Overall)1786911377.23224708.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.