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

250 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
sickness143783(None) 
slickness1535901slickness
iciness938862_iciness
ickiness1436752_ickiness
niceness1039842niceness
packness1636932packness
pickiness1737622pickiness
pinkness1436512pinkness
quickness2443732quickness
richness1337432richness
sickbeds17254212sickbeds
sickees134514212sick_ees
sickeners1535732sickeners
sickens134411482sick_ens
sickest131813792sick_est
sickies133717502sickie_s
sickles133417542sickle_s
sickliness1645002sickliness
sicknesses1636762sicknesses
silkiness1337252silkiness
siziness1737422siziness
slackness1535432slackness
sockless14267792sockless
spiciness1347052spiciness
stickiness1635902stickiness
suchness1335762suchness
suckless14288822suckless
thickness1844442thickness
wickless1736082wickless
acidness1136723acidness
airiness8412213airiness
airsickness1751813airsickness
archness1337513archness
backless162910633backless
biasness1035813biasness
bickers154316553bick_ers
bigness1038193bi_gness
blackness1735663blackness
briskness1544763briskness
chicness1535593chic_ness
clickless1743983clickless
cockiness17248783cockiness
cockneys1934493cockneys
dankness13256693dankness
darkness13247343darkness
dickens144410133dick_ens
dickenses1645073dickenses
dickers144117663dick_ers
dickeys17479303dick_eys
dickies143416343dickie_s
dickiest153412503dickiest
dimness1038843di_mness
direness9311303direness
feckless17225783feckless
fickleness1943663fickleness
ficklest17267903ficklest
fineness11310643fineness
firmness1334743firmness
fitness10299393fi_tness
hackneys2033683hackneys
hickeys19508223hick_eys
hickies163614743hickie_s
highness1536053highness
hipness12277383hi_pness
iceless9219963_iceless
ickers123914183_ick_ers
ickiest133611043_ickiest
icones84616383_icone_s
illness736473_illness
inkiness1238693_inkiness
inkless11348713_inkless
juiciness1835153juiciness
kickers124013293kick_ers
kickiest13319673kickiest
kindness13236653kindness
kinkiness1235763kinkiness
laciness102112553laciness
lankness12237043lankness
licenses10118923licenses
licitness1145373licitness
lickers134118253lick_ers
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
lioness739103li_oness
liteness82213213liteness
liveness112411393liveness
luckiness1596573luckiness
luckless14265893luckless
meekness1434303meekness
mickeys18447943mick_eys
mickles153415003mickle_s
micklest16219123micklest
mildness1136523mildness
milkiness1536523milkiness
milkless1434773milkless
miriness10310463miriness
muchness1534073muchness
neckless14236433neckless
nickels13338653nick_els
nickers134415093nick_ers
nickles133713823nickle_s
nighness1236103nighness
oiliness8311563oiliness
pickeers16347243pickeers
pickers153718093pick_ers
pickets154314183pick_ets
pickiest162712593pickiest
pickles153215443pickle_s
pipiness1238003pipiness
pixiness1736093pixiness
raciness102413453raciness
rankness12267943rankness
reckless14257973reckless
rickets134915093rick_ets
rickeys16548983rick_eys
rifeness1138583rifeness
riminess10510093riminess
ripeness1039363ripeness
riskiness1336963riskiness
riskless1235763riskless
rockiness15237833rockiness
rockless14297293rockless
sackers133820223sack_ers
sadness8310613s_adness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
sauciness1138043sauciness
scenes84520353s_cene_s
scones84521303s_cone_s
seasickness1752663seasickness
selfness1135153selfness
sexiness1537943sexiness
shakiness1637083shakiness
shickers173012823shick_ers
shininess1237333shininess
shyness1344993s_hyness
sices75637273sic__e_s
sickbays1943163sickbays
sickbed16396823sickbe_d
sicked134524403sick_e_d
sickee124622223sick_e_e
sicken124615253sick_e_n
sickened1546783sickened
sickener1436603sickener
sicker124023903sick_e_r
sickie123715743sickie__
sickish1638423sick_ish
sickishness2043653sickishness
sickle124418323sickle__
sickled144713433sickle_d
sicklies14710013sicklies
sickliest1547523sickliest
sickos125112033sick__os
sickouts1455503sickouts
sicks115127623sick___s
sidedness1146783sidedness
sighless1276553sighless
signees83510803si_gnees
signers84714443si_gners
signets83311503si_gnets
sikes96236083si_k_e_s
silanes72517163silane_s
silkies113715693silkie_s
silkiest123212853silkiest
silliness9510363silliness
simnels976103si_mnels
sines55954823si__ne_s
sinews94210623si__news
sinkers113618543sink_ers
sinless73014213si_nless
sinners74019023si_nners
sissiness8217963sissiness
sissyness11252963sissyness
skewness1533763skewness
sleekness1344543sleekness
slickeners1643663slickeners
slickens14317263slick_ens
slickers143112553slick_ers
slickest14229253slick_est
slicknesses1745193slicknesses
sliminess1137423sliminess
slimness1036523slimness
slinkiness1445153slinkiness
slowness1135013slowness
slyness1035263s_lyness
smokiness1535543smokiness
smugness1143813smugness
snakiness1367473snakiness
snickers143010963snick_ers
snideness1067683snideness
snubness1044373snubness
snugness934323snugness
sockets134012983sock_ets
softness1136433softness
soleness8814263soleness
soreness8914793soreness
sourness839543sourness
spaciness1337083spaciness
spiceless1335923spiceless
spikiness1536313spikiness
spininess1137963spininess
spryness1334003spryness
stackless1555933stackless
starkness1335963starkness
stickers142913033stick_ers
stickies142211973stickie_s
stickiest15229603stickiest
sticklers15227393sticklers
stickles142512103stickle_s
stiffness1543553stiffness
stillness936103stillness
stockiness1645243stockiness
strictness1245643strictness
success1146403suc_cess
suckers133717623suck_ers
suckiest143314113suckiest
sucklers14379963sucklers
suckles134516743suckle_s
sulkiness1347353sulkiness
sureness8912903sureness
swiftness1543653swiftness
tackiness1557693tackiness
tackless14419483tackless
tickers133617723tick_ers
tickets134113683tick_ets
ticklers14339303ticklers
tickles133416853tickle_s
tidiness938793tidiness
tininess8310633tininess
titaness836723titaness
trickiness1666353trickiness
viceless1337983viceless
victress1344523victress
vileness1139983vileness
wackiness1836523wackiness
weakness1535353weakness
wickedness2043073wickedness
wickers164114703wick_ers
wickets164010943wick_ets
wideness12259473wideness
wildness1236203wildness
wiliness1139113wiliness
wiriness1138953wiriness
wiseness112010753wiseness
witness103010013wi_tness
yuckiness1874923yuckiness

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622506.98620922.1
3Display Results2502500.1102272.7
 (SQL Overall)1786912507.51623774.7
 
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.