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

133 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
avidnesses143646(None) 
acidnesses1337251acidnesses
aridnesses1139931aridnesses
acridnesses1445782acridnesses
agednesses1237412agednesses
algidnesses1345162algidnesses
avidness1246112avidne_s_s
evilnesses1346002evilnesses
lividnesses1545022lividnesses
rabidnesses1476132rabidnesses
rapidnesses1476472rapidnesses
vainnesses1337342vainnesses
validnesses1576022validnesses
vapidnesses1774892vapidnesses
vividnesses1844222vividnesses
voidnesses1436842voidnesses
wavinesses16199282wavi_nesses
achinesses1539303achinesses
acidness1136723acidne_s_s
addresses1165633a_ddresses
agilenesses1247773agilenesses
airinesses102613613airinesses
aliennesses1145863aliennesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
apishnesses1646373apishnesses
aptnesses11168993a_ptnesses
archnesses1547173archnesses
aridness939223aridne_s_s
artinesses10815213artinesses
ashinesses1339163ashinesses
aviatresses1483003aviatresses
awaynesses1644273awaynesses
badnesses1239253_badnesses
baldnesses1337653baldnesses
bandinesses14109733bandinesses
bawdinesses17126323bawdinesses
bignesses1267963_bignesses
blindnesses1446183blindnesses
boldnesses1337233boldnesses
caginesses13310943cagi_nesses
cakinesses16310613caki_nesses
candidnesses1685393candidnesses
chicnesses1745213chicnesses
civilnesses1644853civilnesses
coldnesses1338423coldnesses
datednesses1357903datednesses
dazednesses2245153dazednesses
deadnesses1238943deadnesses
dimnesses1238213_dimnesses
easinesses10314443easi_nesses
evennesses1345943evennesses
eyednesses1445813eyednesses
fadednesses16126563fadednesses
fairnesses1357383fairnesses
fervidnesses1943843fervidnesses
fetidnesses1546653fetidnesses
finesses111912343_fi_nesses
fitnesses12219373_fitnesses
fluidnesses1545483fluidnesses
fondnesses1437703fondnesses
gaminesses13410463gami_nesses
gaudinesses1337853gaudinesses
gelidnesses1355983gelidnesses
gladnesses1236683gladnesses
glibnesses1344753glibnesses
goodnesses1236433goodnesses
grimnesses13106533grimnesses
handinesses151410273handinesses
hardinesses151110213hardinesses
hardnesses141810543hardnesses
hazinesses2239223hazi_nesses
heavinesses1747453heavi_nesses
hipnesses1436753_hipnesses
humidnesses1744583humidnesses
icinesses11310073ici_nesses
idlesses936003__idlesses
jadednesses20145773jadednesses
kindnesses1537213kindnesses
lacinesses12312123laci_nesses
lavishnesses1844773lavishnesses
lazinesses19310153lazi_nesses
lewdnesses1435393lewdnesses
lionesses939433_lionesses
livenesses13411073livenesses
loudnesses1138433loudnesses
lucidnesses1445243lucidnesses
luridnesses1246723luridnesses
madnesses1239833_madnesses
matinesses12314543mati_nesses
mazednesses2345403mazednesses
mazinesses2139923mazi_nesses
mildnesses1397393mildnesses
naivenesses1449113naivenesses
nakednesses1645843nakednesses
oddnesses1136353_oddnesses
oldnesses1037703_oldnesses
ovalnesses1346053ovalnesses
pallidnesses1543923pallidnesses
placidnesses1743953placidnesses
primnesses1497803primnesses
racinesses12313513raci_nesses
rancidnesses1544883rancidnesses
randinesses121311203randinesses
rednesses10312313_rednesses
rigidnesses1345923rigidnesses
sadnesses10310303_sadnesses
sandinesses12911393sandinesses
savvinesses1735663savvinesses
slimnesses1236423slimnesses
snidenesses1248653snidenesses
solidnesses1238103solidnesses
staidnesses1237193staidnesses
tacitnesses1336323tacitnesses
tardinesses121110243tardinesses
tepidnesses1445383tepidnesses
thinnesses1346263thinnesses
tidinesses1139223_tidinesses
timidnesses1445143timidnesses
trignesses1188213trignesses
trimnesses1287753trimnesses
tumidnesses1444613tumidnesses
vastnesses13128203vastnesses
vilenesses13310223_vilenesses
vinasses1135703_vi_nasses
vitesses1136333_vi_tesses
warinesses131514523wari_nesses
waxinesses20138763waxi_nesses
weirdnesses1545213weirdnesses
widenesses1438773_widenesses
wildnesses14157363wildnesses
witnesses12219923_witnesses
zaninesses19310383zani_nesses

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.403443402.0
2DLD Change Limit1406031336.26622439.0
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.73226543.5
 
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.