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

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

102 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
lonesomenesses165379(None) 
longsomenesses1763081longsomenesses
lonesomeness1454112lonesomene_s_s
awesomenesses1853383_awesomenesses
gamesomenesses1962723gamesomenesses
gruesomenesses1753073gruesomenesses
handsomenesses2062703handsomenesses
lissomenesses1453473l_issomenesses
loathsomenesses20112113loathsomenesses
longsomeness1553153longsomene_s_s
noisomenesses1554243no_isomenesses
tiresomenesses1653343tiresomenesses
toilsomenesses1662703toilsomenesses
wholesomenesses2361913wholesomenesses
winsomenesses1854043win_somenesses
cohesivenesses2256204cohesivenesses
fearsomenesses1953194fearsomenesses
footsorenesses1792224footsorenesses
fulsomenesses1853124_fulsomenesses
gladsomenesses1892384gladsomenesses
irksomenesses1953194_irksomenesses
lightsomenesses2161824lightsomenesses
lonelinesses12146344lone__linesses
lonenesses10311344lon____enesses
loosenesses1147244lo___osenesses
lovelornnesses1761404lovelornnesses
lovesicknesses2361594lovesicknesses
obesenesses1346764_obes__enesses
onerousnesses1348974_onerousnesses
operosenesses1575324_operosenesses
toothsomenesses2061904toothsomenesses
worrisomenesses2062274worrisomenesses
adhesivenesses2155055adhesivenesses
alonenesses1147215alon____enesses
awesomeness1653405_awesomene_s_s
closenesses1347845clo__s__enesses
coarsenesses1447245coars__enesses
cocksurenesses2261845cocksurenesses
concisenesses1746595con_cisenesses
concretenesses1854165concretenesses
confirmednesses2362015confirmednesses
contritenesses1655495contritenesses
covetousnesses1955225covetousnesses
densenesses1247365den_s__enesses
donenesses11310565don____enesses
gamesomeness1753205gamesomene_s_s
generousnesses1556945generousnesses
gloominesses1544125glo___ominesses
gonenesses11310255gon____enesses
grotesquenesses2561515grotesquenesses
gruesomeness1553065gruesomene_s_s
handsomeness1853055handsomene_s_s
hoarsenesses1545605hoars__enesses
homesicknesses2561595homesicknesses
insanenesses1246875_in_sanenesses
jocosenesses2143975jo__cosenesses
lamenesses12610565l____amenesses
lifelikenesses2152395lifelikenesses
lissomeness1353355l_issomene_s_s
literatenesses1464785literatenesses
loaminesses1358455lo___aminesses
loathsomeness1862275loathsomene_s_s
lonesomes1166985lonesom_____es
longnesses1138505lon____gnesses
looninesses1197995lo___oninesses
loopinesses13116735lo___opinesses
lopsidednesses1852525lo_psidednesses
losablenesses1596075lo_sablenesses
lostnesses1049305lo__s__tnesses
lousinesses111210335lo_us__inesses
lovablenesses18115845lo_vablenesses
lovelessnesses1646995lovelessnesses
lovelinesses15125335love__linesses
moderatenesses1764405moderatenesses
monogeneses1446435mon__ogene_ses
morosenesses1446865mo__rosenesses
noisomeness1354075no_isomene_s_s
oncogeneses1465135_on_cogene_ses
onenesses9311825_on____enesses
ontogeneses1255875_on_togene_ses
otiosenesses1245705_o_tiosenesses
pensivenesses1849025pen_sivenesses
ponderousnesses1854615ponderousnesses
randomnesses1553535ran_dom_nesses
remotenesses1446815__remotenesses
roominesses1337435ro___ominesses
samenesses12410855____samenesses
selfsamenesses1892145selfsamenesses
solemnnesses1443635sole__mnnesses
solenesses10412705____solenesses
sonorousnesses1356515sonorousnesses
sorenesses101313495____sorenesses
tensenesses1147615ten_s__enesses
tiresomeness1453605tiresomene_s_s
toilsomeness1452575toilsomene_s_s
tonelessnesses13137655tonelessnesses
wearisomenesses2062415wearisomenesses
welcomenesses2052585_welcomenesses
wholesomeness2162405wholesomene_s_s
winsomeness1653655win_somene_s_s
woebegonenesses216875woebegonenesses
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.343520965.0
2DLD Change Limit950241026.36014940.9
3Display Results1021020.0631619.0
 (SQL Overall)1786911026.76626410.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.