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

98 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
longsomenesses176308(None) 
lonesomenesses1653791lonesomenesses
longsomeness1553152longsomene_s_s
handsomenesses2062703handsomenesses
lissomenesses1453473l_issomenesses
loathsomenesses20112113loathsomenesses
lonesomeness1454113lonesomene_s_s
noisomenesses1554243no_isomenesses
toilsomenesses1662703toilsomenesses
winsomenesses1854043win_somenesses
awesomenesses1853384_awesomenesses
fearsomenesses1953194fearsomenesses
footsorenesses1792224footsorenesses
fulsomenesses1853124_fulsomenesses
gamesomenesses1962724gamesomenesses
gladsomenesses1892384gladsomenesses
gruesomenesses1753074gruesomenesses
irksomenesses1953194_irksomenesses
lightsomenesses2161824lightsomenesses
lonenesses10311344lon____enesses
longnesses1138504long____nesses
loosenesses1147244lo___osenesses
tiresomenesses1653344tiresomenesses
toothsomenesses2061904toothsomenesses
wholesomenesses2361914wholesomenesses
worrisomenesses2062274worrisomenesses
alonenesses1147215alon____enesses
angiogeneses14123735_angiogene_ses
closenesses1347845clo__s__enesses
coarsenesses1447245coars__enesses
cocksurenesses2261845cocksurenesses
cohesivenesses2256205cohesivenesses
concisenesses1746595con_cisenesses
concretenesses1854165concretenesses
confirmednesses2362015confirmednesses
congruousnesses1884635congruousnesses
contritenesses1655495contritenesses
densenesses1247365den_s__enesses
donenesses11310565don____enesses
forgivenesses2045845forg_ivenesses
gamenesses1368985___g_amenesses
gloominesses1544125glo___ominesses
gonenesses11310255___g_onenesses
gorgeousnesses1655095gorgeousnesses
handsomeness1853055handsomene_s_s
hoarsenesses1545605hoars__enesses
ingrownnesses1751985_ingrownnesses
insanenesses1246875_in_sanenesses
jocosenesses2143975jo__cosenesses
lamenesses12610565l____amenesses
languidnesses1552405lang_uidnesses
largenesses1247555larg___enesses
lengthinesses1752145leng_thinesses
lissomeness1353355l_issomene_s_s
loaminesses1358455lo___aminesses
loathsomeness1862275loathsomene_s_s
logicalnesses1653195lo_gicalnesses
loginesses11410325lo_g___inesses
lonelinesses12146345lon__elinesses
looninesses1197995lo___oninesses
loopinesses13116735lo___opinesses
lopsidednesses1852525lo_psidednesses
losablenesses1596075lo_sablenesses
lostnesses1049305lo__s__tnesses
lousinesses111210325lo_us__inesses
lovablenesses18115845lo_vablenesses
lovelornnesses1761405lovelornnesses
lovesicknesses2361595lovesicknesses
monogeneses1446435mon__ogene_ses
morosenesses1446865mo__rosenesses
noisomeness1354075no_isomene_s_s
obesenesses1346765_obes__enesses
oncogeneses1465135_on_cogene_ses
onenesses9311825_on____enesses
onerousnesses1348975_onerousnesses
ongoingnesses1583105_ongoingnesses
ontogeneses1255875_on_togene_ses
operosenesses1575325_operosenesses
otiosenesses1245705_o_tiosenesses
pensivenesses1849025pen_sivenesses
randomnesses1553535ran_dom_nesses
roominesses1337435ro___ominesses
samenesses12410855____samenesses
sanguinenesses1562255sanguinenesses
selfsamenesses1892145selfsamenesses
singlenesses1346105sing__lenesses
solenesses10412705____solenesses
songfulnesses1754675song_fulnesses
songstresses1252015songs__tresses
sonorousnesses1356515sonorousnesses
sorenesses101313495____sorenesses
tangiblenesses1753595tangiblenesses
tensenesses1147615ten_s__enesses
toilsomeness1452575toilsomene_s_s
wearisomenesses2062415wearisomenesses
welcomenesses2052585_welcomenesses
winsomeness1653655win_somene_s_s
wondrousnesses1855845wondrousnesses

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.390458182.1
2DLD Change Limit95024986.48614650.6
3Display Results98980.0601633.3
 (SQL Overall)178691986.93625762.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.