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

262 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
sandiness10211171(None) 
bandiness122310241bandiness
handiness132110931handiness
randiness102511441randiness
bawdiness15235542bawdiness
candidness1444772candidness
canniness1138642canniness
fanciness1437672fanciness
gaudiness1136252gaudiness
hardiness132310352hardiness
lankiness1338052lankiness
manginess122010412manginess
manliness111310122manliness
ranginess101610212ranginess
sadness8310612sa_d_ness
saltiness93312112saltiness
sandiest93218682sandi_est
sandinesses12911392sandinesses
sandless93212342sand_less
saneness82313722san_eness
sanidines1048042sanidine_s
sappiness1337432sappiness
sardines92815562sardine_s
sassiness8249332sassiness
sauciness1138042sauciness
savviness1534712savviness
scantiness1236872scantiness
seediness10219172seediness
shadiness1337462shadiness
slanginess1146272slanginess
snakiness1367472snakiness
sunniness9247942sunniness
swankiness1744252swankiness
tanginess10239282tanginess
tardiness10229912tardiness
windiness1337372windiness
zaniness1738662zan_iness
achiness1339703_achiness
acidness1136723_acidness
airiness8412213_airiness
angriness1036453_angriness
antsiness937843_antsiness
aridness939223_aridness
artiness81615403_artiness
ashiness1138963_ashiness
avidness1246113_avidness
badness1039573ba_d_ness
bagginess1355953bagginess
baldness1137043bald_ness
balkiness1556903balkiness
balminess1356593balminess
bandies104124863bandi_e_s
bandinesses14109723bandinesses
battiness11239843battiness
beadiness12249233beadiness
blandness1235973bland_ness
boniness102211803bon_iness
bonniness1136733bonniness
caginess11310303ca_giness
cakiness1449553ca_kiness
campiness1537543campiness
candidest1346533candidest
candies104125613candi_e_s
canines93724033can_ine_s
canoness1039393can_oness
cattiness112310633cattiness
chanciness1745123chanciness
crankiness1636173crankiness
daffiness1634843daffiness
dailiness1038673dailiness
daintiness1145963daintiness
dandies94121443dandi_e_s
dandiest103415033dandi_est
dankness13256693dan_kness
dinginess1137813dinginess
dowdiness1485693dowdiness
earliness939693earliness
easiness8313043ea_siness
fanciless1444603fanciless
fanzines2036913fanzine_s
fattiness12239373fattiness
fondness1237213fond_ness
funkiness16226873funkiness
funniness12256533funniness
gabbiness1434403gabbiness
gaminess112911053ga_miness
gassiness10268313gassiness
gauziness1934613gauziness
gawkiness1734753gawkiness
giddiness1234683giddiness
grandness1138303grand_ness
hairiness1238013hairiness
hamminess1635703hamminess
handedness1545903handedness
handiest123417773handi_est
handinesses151410273handinesses
handless123512063hand_less
handpress1544033handpress
happiness1635993happiness
hardness122411083hard_ness
hastiness122410883hastiness
haziness20248513ha_ziness
headiness132510363headiness
inkiness1238693_inkiness
jauntiness1743973jauntiness
jazziness2432843jazziness
kindliness1544043kindliness
kindness13236653kind_ness
kinkiness1235763kinkiness
laciness102112553la_ciness
landings103110073landin_gs
landless94011173land_less
landlines1039753landline_s
lankness12237043lan_kness
larkiness1338113larkiness
laziness17239983la_ziness
madness10310073ma_d_ness
maltiness112910573maltiness
massiness112810143massiness
matiness102114743ma_tiness
maziness19239543ma_ziness
moldiness12227053moldiness
moodiness12197593moodiness
muddiness1334753muddiness
nandinas936573nandin_as
nandins8312003nandin__s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
neediness10227733neediness
nerdiness10208333nerdiness
pandies104224503pandi_e_s
pastiness112312353pastiness
pawkiness1835443pawkiness
puniness101610273pun_iness
punkiness15226983punkiness
rabidness12145263rabidness
raciness102413453ra_ciness
raininess949273raininess
rancidness1344223rancidness
randies84225663randi_e_s
randiest93418773randi_est
randinesses121311203randinesses
randomness1343983randomness
rankness12267943ran_kness
rapidness12155473rapidness
raspiness1137303raspiness
readiness102611853readiness
reediness10239613reediness
rowdiness1396233rowdiness
ruddiness1135123ruddiness
runniness9247103runniness
runtiness92410393runtiness
sabines94318483sa_bine_s
safeness11239633sa_feness
sageness92111983sa_geness
saintliness1144153saintliness
salines74029413sa_line_s
saltines82917793saltine_s
saltness82610243sa_ltness
sameness102712683sa_meness
sanders84025943sand__ers
sandglass1143723sandglass
sandier84017843sandi_e_r
sanding93520603sandin__g
sandlings11238093sandlin_gs
sandpeeps1442083sandpeeps
sandpiles1246303sandpile_s
sandpipers1592853sandpipers
sanguines1047183sanguine_s
sanidine939853sanidine__
sanies63031953san_i_e_s
sardine83317393sardine__
sardined10268663sardine_d
sardiuses1044753sardiuses
satinets8311733sa_tinets
savines104417633sa_vine_s
savoriness1354933savoriness
scaliness1149303scaliness
scantness1135733scan_tness
scariness11310183scariness
seaminess11310473seaminess
sentinels947423sentinels
sexiness1537943s_exiness
shabbiness1743133shabbiness
shagginess1543933shagginess
shakiness1637083shakiness
shandies122714103shandi_e_s
shininess1237333shininess
shoddiness1543563shoddiness
showiness1576073showiness
silkiness1337253silkiness
silliness9510353silliness
sissiness8217963sissiness
siziness1737423s_iziness
skinniness1443313skinniness
slatiness92511363slatiness
sliminess1137423sliminess
slinkiness1445153slinkiness
smarminess1444303smarminess
smokiness1535543smokiness
smudginess1442873smudginess
snappiness1443823snappiness
snideness1067683snideness
snowiness1296233snowiness
snubness1044373s_nubness
snugness934323s_nugness
soapiness1138293soapiness
sogginess1136183sogginess
solidness1036903solidness
sootiness999833sootiness
soppiness1336543soppiness
sordidness1244633sordidness
sordines92414063sordine_s
sorriness939583sorriness
soundness1036963sound_ness
spaciness1337083spaciness
speediness1345223speediness
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
sponginess1344593sponginess
spunkiness1644173spunkiness
staginess1038753staginess
staidness1037033staid_ness
standings11257153standin_gs
stanines85115663stan_ine_s
steadiness1146703steadiness
stinginess1145953stinginess
stodginess1243893stodginess
stoniness938343stoniness
sturdiness1144843sturdiness
sulkiness1347353sulkiness
sundress936983sund_ress
surliness939943surliness
swampiness1773353swampiness
tackiness1557693tackiness
talkiness1356913talkiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawdriness1482843tawdriness
tawniness1245123tawniness
tidiness938793_tidiness
tininess8310633tin_iness
tinniness936093tinniness
trendiness1146223trendiness
undines8716083_undine_s
unhandiness1563953unhandiness
validness13125363validness
vapidness15144423vapidness
wackiness1836523wackiness
wanness102610683wan__ness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weediness13247043weediness
woodiness13147873woodiness
wordiness13138633wordiness

Search took 9 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 Filter1786911486410.203880251.2
2DLD Change Limit1486412627.82618993.2
3Display Results2622620.1262079.4
 (SQL Overall)1786912628.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.