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 “sickliness” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
sickliness164500(None) 
fickleness1943662fickleness
ickiness1436752_ick_iness
pickiness1737622pick_iness
prickliness1943902prickliness
scaliness1149302s_caliness
sicklies14710012sickli_e_s
sickliest1547522sickli_est
sicklinesses1844862sicklinesses
sickness1437832sick__ness
silkiness1337252silk_iness
silliness9510362si_lliness
stickiness1635902stick_iness
cockiness17248783cock_iness
hilliness1248923hi_lliness
iciness938863_ic__iness
inkiness1238693_ink_iness
kindliness1544043kindliness
kingliness1543953kingliness
kinkiness1235763kink_iness
liveliness1345633liveliness
luckiness1596573luck_iness
milkiness1536523milk_iness
necklines15115723neckline_s
oiliness8311563oi__liness
picolines1339623picoline_s
riskiness1336963risk_iness
rockiness15237833rock_iness
saintliness1144153saintliness
scariness11310183s_cariness
seemliness1244153seemliness
shakiness1637083shak_iness
sickeners1535733sick_eners
sickies133717503sick_i_e_s
sickishness2043653sickishness
sickles133417543sickl__e_s
sicklied1546583sickli_e_d
sicklier1457213sickli_e_r
sickling152910333sicklin__g
sideliners11125133sideliners
sidelines10109683sideline_s
sightliness1574563sightliness
silkalines1443573silkaline_s
silkolines1443383silkoline_s
simpleness1445173simpleness
singleness1145733singleness
sissiness8217963si_ssiness
siziness1737423si__ziness
slickness1535903slick__ness
slinkiness1445153slink_iness
smokiness1535543smok_iness
snakiness1367473snak_iness
sockless14267793sockl__ess
spiciness1347053spic__iness
spikiness1536313spik_iness
steeliness1046793steeliness
stockiness1645243stock_iness
suckless14288823suckl__ess
sucklings16225113sucklin_gs
sulkiness1347353sulk_iness
surliness939943s_urliness
tackiness1557693tack_iness
ticklishness2152333ticklishness
timeliness1245303timeliness
trickiness1666353trick_iness
tricksiness1762943tricksiness
wackiness1836523wack_iness
weakliness1753853weakliness
wickedness2043073wickedness
wickless1736083wickl__ess
wifeliness1644483wifeliness
wiliness1139113wi__liness
yuckiness1874923yuck_iness

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 Filter1786911406030.423422437.4
2DLD Change Limit140603736.59321326.1
3Display Results73730.0302433.3
 (SQL Overall)178691737.04625360.6
 
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.