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

103 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
stickiness163590(None) 
stockiness1645241stockiness
ickiness1436752__ickiness
pickiness1737622_pickiness
sickliness1645002s_ickliness
sickness1437832s_ick_ness
silkiness1337252s_ilkiness
slickness1535902slick_ness
slinkiness1445152slinkiness
spiciness1347052spic_iness
spikiness1536312spi_kiness
stickies142211972sticki_e_s
stickiest15229602sticki_est
stickinesses1845082stickinesses
stinginess1145952stinginess
stockinets1643532stockinets
tackiness1557692_tackiness
trickiness1666362trickiness
bitchiness1743793bitchiness
cockiness17248783_cockiness
finickiness2052023finickiness
friskiness1744463friskiness
iciness938863__ic_iness
inkiness1238693__inkiness
itchiness1444753it_chiness
juiciness1835153juic_iness
kinkiness1235763_kinkiness
luckiness1596573_luckiness
milkiness1536523_milkiness
pluckiness1883823pluckiness
prickliness1943923prickliness
quickness2443733quick_ness
quirkiness2342823quirkiness
riskiness1336973_riskiness
rockiness15237833_rockiness
sauciness1138043sauc_iness
shakiness1637083s_hakiness
shiftiness1644793shiftiness
shininess1237343shi_niness
shtickiest1943283shticki_est
sickeners1535733s_ickeners
sickies133717503s_icki_e_s
sickishness2043653s_ickishness
silliness9510363s_illiness
sissiness8217973s_issiness
siziness1737423s_i_ziness
skimpiness1842863skimpiness
skinniness1443313skinniness
slackness1535433slack_ness
slickeners1643663slickeners
sliminess1137423sli_miness
smokiness1535543s_mokiness
snakiness1367473s_nakiness
sneakiness1454873sneakiness
sniffiness1643763sniffiness
spaciness1337083spac_iness
spiffiness1842983spiffiness
spininess1137963spi_niness
spookiness1644433spookiness
spunkiness1644173spunkiness
stackless1555933stack_less
staginess1038753st_aginess
starchiness1643943starchiness
starkness1335963stark_ness
steadiness1146703steadiness
steaminess1236773steaminess
steeliness1046793steeliness
stibines1038153sti_bine_s
stickers142913033stick__ers
stickier14229763sticki_e_r
sticking153513463stickin__g
sticklers15227393stick_lers
stickles142512103stick_le_s
stickpins1744093stickpin__s
stickseeds1772393stickseeds
stickweeds2082443stickweeds
stiffness1543553sti_ffness
stillness936103sti_llness
stinkiest13198463stinki_est
stockiest15207753stocki_est
stockinesses1844503stockinesses
stockinet1547193stockine_t
stockings16296093stockin_gs
stodginess1243893stodginess
stoniness938343st_oniness
storminess1245213storminess
streakiness1543823streakiness
strictness1245643stric_tness
stringiness1245273stringiness
stuffiness1643693stuffiness
sturdiness1144843sturdiness
sulkiness1347353s_ulkiness
swankiness1744253swankiness
talkiness1356913_talkiness
thickness1844443thick_ness
tickings15368583_tickin_gs
tidiness938793_ti_diness
tininess8310633_ti_niness
tinniness936093_tinniness
tipsiness1135713_tipsiness
tricksiness1762963tricksiness
wackiness1836523_wackiness
yuckiness1874923_yuckiness

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.406440125.6
2DLD Change Limit1406031036.11023011.9
3Display Results1031030.0601716.7
 (SQL Overall)1786911036.57627173.2
 
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.