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

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

151 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
longnesses113850(None) 
lonenesses10311341lonenesses
alonenesses1147212alonenesses
blondnesses1445542blondnesses
boninesses121111452boninesses
congresses1348022congresses
donenesses11310562donenesses
fondnesses1437702fondnesses
gonenesses11310252gonenesses
lanknesses1437502lanknesses
loginesses11410322loginesses
longness938552longne_s_s
looninesses1197992looninesses
lornnesses1037822lornnesses
lostnesses1049302lostnesses
loudnesses1138432loudnesses
lovingnesses1643672lovingnesses
lownesses1236982lo_wnesses
onenesses9311822_onenesses
wrongnesses1544922wrongnesses
youngnesses1544282youngnesses
aloofnesses1443413aloofnesses
bignesses1267963_bignesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
blindnesses1446183blindnesses
blowinesses1635983blowinesses
bluntnesses1345393bluntnesses
bogginesses1555673bogginesses
boldnesses1337233boldnesses
bonninesses1337353bonninesses
boringnesses15105023boringnesses
boundnesses1446623boundnesses
boxinesses19127903boxinesses
canonesses1238423canonesses
closenesses1347843closenesses
coldnesses1338423coldnesses
confesses1438623con_fesses
congressed1445463congressed
coolnesses1237193coolnesses
corninesses13410603corninesses
cosinesses121012823cosinesses
coynesses1437573co_ynesses
cozinesses21179503cozinesses
danknesses1536253danknesses
dinginesses1337473dinginesses
dodginesses1435433dodginesses
dopinesses13159723dopinesses
dournesses1138243dournesses
downinesses1536143downinesses
dozinesses20168633dozinesses
dunnesses1037703dun_nesses
finenesses13310723finenesses
fogginesses1645493fogginesses
foulnesses1337933foulnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
glegnesses1245073glegnesses
goodnesses1236433goodnesses
gorinesses11311553gorinesses
hokinesses1758943hokinesses
holinesses13511493holinesses
hominesses15510873hominesses
horninesses1459003horninesses
hotnesses1238903ho_tnesses
ingresses1038533_ingresses
ironnesses1047833iron_nesses
jokinesses2147533jokinesses
kindnesses1537213kindnesses
lacinesses12312123lacinesses
lamenesses12610563lamenesses
lankinesses1539013lankinesses
largenesses1247553largenesses
largesses10246273larg_esses
latenesses10413363latenesses
laxnesses1646633l_axnesses
lazinesses19310153lazinesses
leannesses10108343leannesses
legginesses1345293legginesses
lewdnesses1435393lewdnesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lionesses939433l_ionesses
litenesses10513023litenesses
livenesses13411073livenesses
livingnesses1643663livingnesses
loaminesses1358453loaminesses
loathnesses1445863loathnesses
localnesses1345853localnesses
loesses7310033lo___esses
loftinesses1437923loftinesses
lonelinesses12146343lonelinesses
loneness8512093lonene_s_s
longhouses1444983longhouses
longleaves1452503longleaves
longnecks1642323longne_cks
loopinesses13116733loopinesses
loosenesses1147243loosenesses
lorgnettes1152693lorgnettes
lousinesses111210333lousinesses
lowlinesses1436683lowlinesses
lushnesses1337343lushnesses
manginesses1499593manginesses
mooninesses13127943mooninesses
mootnesses1237153mootnesses
mopinesses14139123mopinesses
morenesses12811393morenesses
nosinesses101411323nosinesses
nownesses1236893no_wnesses
oddnesses1136353_oddnesses
ogresses938473_o_gresses
oldnesses1037703_oldnesses
oozinesses19178023oozinesses
phoninesses1636453phoninesses
pinknesses1636583pinknesses
planenesses1349033planenesses
pokinesses1669613pokinesses
poornesses1236803poornesses
poshnesses1537463poshnesses
pronenesses1379263pronenesses
puninesses121110753puninesses
ranginesses121210113ranginesses
ranknesses1438093ranknesses
ropinesses121311023ropinesses
rosinesses101213153rosinesses
roughnesses15105133roughnesses
roundnesses1247043roundnesses
sanenesses10412693sanenesses
slanginesses1346963slanginesses
slownesses1344943slo_wnesses
smugnesses1344563smugnesses
snugnesses1165423snugnesses
softnesses1337603softnesses
sogginesses1346773sogginesses
solenesses10412703solenesses
sorenesses101313493sorenesses
soundnesses1247523soundnesses
sournesses10310013sournesses
sponginesses1544773sponginesses
stoninesses1138253stoninesses
tanginesses1278883tanginesses
thingnesses1545203thingnesses
tininesses10311163tininesses
toughnesses15104483toughnesses
trignesses1188213trignesses
voidnesses1436843voidnesses
wannesses1239233wan_nesses
woenesses1239133wo_enesses
wornnesses1337133wornnesses
zaninesses19310383zaninesses

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031516.45321788.8
3Display Results1511510.0761986.8
 (SQL Overall)1786911516.95225703.5
 
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.