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

230 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
handiness13211093(None) 
bandiness122310241bandiness
hardiness132310351hardiness
randiness102511441randiness
sandiness102111711sandiness
bawdiness15235542bawdiness
candidness1444772candidness
canniness1138642canniness
chanciness1745122chanciness
fanciness1437672fanciness
gaudiness1136252gaudiness
hairiness1238012hairiness
hamminess1635702hamminess
handedness1545902handedness
handiest123417772handi_est
handinesses151410272handinesses
handless123512062hand_less
handpress1544032handpress
happiness1635992happiness
hardness122411082hard_ness
hastiness122410882hastiness
haziness20248512ha_ziness
headiness132510362headiness
lankiness1338052lankiness
manginess122010412manginess
manliness111310122manliness
ranginess101610212ranginess
shadiness1337462sha_diness
tanginess10239282tanginess
tardiness10229912tardiness
unhandiness1563952unhandiness
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
bandinesses14109733bandinesses
battiness11239843battiness
beadiness12249233beadiness
blandness1235973bland_ness
boniness102211803bon_iness
bonniness1136733bonniness
caginess11310303ca_giness
cakiness1449553ca_kiness
campiness1537543campiness
candidest1346533candidest
candies104125613candi_e_s
canines93724033can_ine_s
canoness1039393can_oness
cattiness112310633cattiness
chariness14310063cha_riness
chattiness1565123chattiness
crankiness1636173crankiness
daffiness1634843daffiness
dailiness1038673dailiness
daintiness1145963daintiness
dandies94121443dandi_e_s
dandiest103415033dandi_est
dankness13256693dan_kness
dinginess1137823dinginess
dowdiness1485693dowdiness
earliness939693earliness
easiness8313043ea_siness
fanciless1444603fanciless
fanzines2036913fanzine_s
fattiness12239373fattiness
fondness1237213fond_ness
funkiness16226873funkiness
funniness12256533funniness
gabbiness1434403gabbiness
gaminess112911053ga_miness
gassiness10268313gassiness
gauziness1934613gauziness
gawkiness1734753gawkiness
giddiness1234683giddiness
grandness1138303grand_ness
haleness11312623ha_leness
halfness1435563ha_lfness
handaxes1938403handaxe_s
handers114224333hand__ers
handicaps1744083handicaps
handier113817443handi_e_r
handing123518893handin__g
handleless1473123handleless
handlers124014143hand_lers
handles114020653hand_le_s
handlings14237343handlin_gs
handovers16136183handovers
handsels12317243hand_sels
handsets12258343hand_sets
hangings13258583hangin_gs
hangnest12311413han_gnest
hangnests1344543han_gnests
hankies143617763hanki_e_s
hardeners1338083hardeners
hardies114923233hardi_e_s
hardiest123416333hardi_est
hardinesses151110213hardinesses
harmines132715143harmine_s
harness102413933ha__rness
harshness1545963harshness
heartiness1338033heartiness
heaviness15207063heaviness
heftiness1536313heftiness
hilliness1248923hilliness
hippiness1635463hippiness
hoariness1238823hoariness
hokiness152510183h_okiness
holiness112512503h_oliness
hominess132712453h_ominess
horniness12309143horniness
horsiness12259473horsiness
huffiness1844283huffiness
humidness1544023humidness
humpiness1635773humpiness
hungriness1443173hungriness
huskiness16206583huskiness
inkiness1238693_inkiness
jauntiness1743973jauntiness
jazziness2432843jazziness
kindliness1544043kindliness
kindness13236653kind_ness
kinkiness1235763kinkiness
laciness102112553la_ciness
landings103110073landin_gs
landless94011173land_less
landlines1039763landline_s
lankness12237043lan_kness
larkiness1338113larkiness
laziness17239983la_ziness
madness10310073ma_d_ness
maltiness112910573maltiness
massiness112810143massiness
matiness102114743ma_tiness
maziness19239543ma_ziness
moldiness12227053moldiness
moodiness12197593moodiness
muddiness1334763muddiness
nandinas936573nandin_as
nandins8312003nandin__s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
neediness10227733neediness
nerdiness10208333nerdiness
pandies104224503pandi_e_s
pastiness112312353pastiness
pawkiness1835443pawkiness
phoniness1436303phon_iness
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
sadness8310613sa_d_ness
saltiness93312113saltiness
sandiest93218683sandi_est
sandinesses12911393sandinesses
sandless93212343sand_less
saneness82313723san_eness
sanidines1048043sanidine_s
sappiness1337433sappiness
sardines92815563sardine_s
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scantiness1236873scantiness
seediness10219173seediness
shabbiness1743133shabbiness
shagginess1543933shagginess
shakiness1637083sha_kiness
shandies122714103shandi_e_s
shininess1237333shin_iness
shoddiness1543563shoddiness
slanginess1146273slanginess
snakiness1367473snakiness
sunniness9247943sunniness
swankiness1744253swankiness
tackiness1557693tackiness
talkiness1356913talkiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawdriness1482843tawdriness
tawniness1245123tawniness
tidiness938793_tidiness
tininess8310633tin_iness
tinniness936093tinniness
trendiness1146223trendiness
undines8716083_undine_s
validness13125363validness
vapidness15144423vapidness
wackiness1836523wackiness
wanness102610683wan__ness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weediness13247043weediness
whininess1535123whin_iness
woodiness13147873woodiness
wordiness13138633wordiness

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 Filter1786911486410.186960704.3
2DLD Change Limit1486412306.69022218.4
3Display Results2302300.0932473.1
 (SQL Overall)1786912306.96925640.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.