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

147 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
whininess153512(None) 
shininess1237331shininess
brininess1138202brininess
phoniness1436302phoniness
raininess949272raininess
spininess1137962spininess
thingness1354892thingness
thinness11277162thin_ness
tininess8310632_tininess
whiniest14298752whini_est
whininesses1746182whininesses
whinnies14237272whinnie_s
whinniest15245132whinniest
whiteness1546482whiteness
wiliness1139112w_iliness
windiness1337372w_indiness
wiriness1138952w_iriness
airiness8412213_airiness
blindness1235343blindness
boniness102211803_boniness
bonniness1136733bonniness
braininess1246123braininess
canniness1138643canniness
chanciness1745123chanciness
chariness14310063chariness
chewiness1744823chewiness
chicness1535593chi_cness
chilliness1555313chilliness
chillness1455373chillness
chinless1337493chin_less
chinones13510473chinone_s
corniness112611183corniness
dailiness1038673dailiness
daintiness1145963daintiness
dinginess1137823_dinginess
downiness13106713downiness
faintness1235833faintness
fineness11310643_fineness
flintiness1345893flintiness
funniness12256533funniness
graininess1145793graininess
griminess1236703griminess
hairiness1238013hairiness
handiness132110933_handiness
haziness20248513_haziness
highness1536053_highness
hilliness1248923_hilliness
hinnies103615103_hinnie_s
hipness12277383_hi_pness
hippiness1635463_hippiness
hokiness152510183_hokiness
holiness112512503_holiness
hominess132712453_hominess
horniness12309143horniness
iciness938863__iciness
inkiness1238693__inkiness
juiciness1835153juiciness
kindness13236653_kindness
kinkiness1235763_kinkiness
liminess10510643_liminess
looniness9137573looniness
miriness10310463_miriness
mooniness11157863mooniness
noisiness948343noisiness
oiliness8311563_oiliness
pinkness1436513_pinkness
pipiness1238003_pipiness
pixiness1736093_pixiness
puniness101610273_puniness
quinines172410203quinine_s
riminess10510093_riminess
runniness9247103runniness
shadiness1337463shadiness
shakiness1637083shakiness
shiftiness1644793shiftiness
shiniest113212493shini_est
shininesses1448293shininesses
shinneys14275093shin_neys
shinnies113010913shinnie_s
showiness1576073showiness
siziness1737423_siziness
skinniness1443313skinniness
sliminess1137423sliminess
slinkiness1445153slinkiness
spiciness1347053spiciness
spikiness1536313spikiness
stinginess1145953stinginess
stoniness938343stoniness
sunniness9247943sunniness
tawniness1245123tawniness
thickness1844443thickness
thinners11327753thin_ners
thinnest11248893thin_nest
thionines12106973thionine_s
thorniness13264343thorniness
tidiness938793_tidiness
tinniness936093tinniness
vainness1136063vain_ness
wackiness1836523wackiness
wanness102610683w_an_ness
wariness11313213w_ariness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723w_aviness
waxiness1836723w_axiness
weariness1238843weariness
weediness13247043weediness
weepiness14215963weepiness
weirdness1343593weirdness
whatness1435093wh_atness
wheeziness2542543wheeziness
whiners134011573wh__iners
whines125120103wh__ine_s
whingers15358723whin_gers
whinges143610633whin_ge_s
whinier134110633whini_e_r
whining143311673whinin__g
whiningly19124253whiningly
whinnied15284153whinnie_d
whinnier14255003whinnie_r
whiteners1535243whiteners
whities133113253whiti_e_s
whitiest14259883whiti_est
whitings15287063whitin_gs
wholeness1545373wholeness
wideness12259473w_ideness
wildness1236203w_ildness
wimpiness1635293wimpiness
windless123310863w_indless
wineless112711173w_ineless
wingless122910023w_ingless
winiest103419693w_ini_est
winless103212283w_in_less
winners104316913w_in_ners
wintriness1345543w_intriness
wiseness112010753w_iseness
wispiness1435633wispiness
witness103010013w_i_tness
wittiness12197223wittiness
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
wornness1136363worn_ness
wrongness1344513wrongness
zaniness1738663_zaniness

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.1731032896.0
2DLD Change Limit1486411476.14024208.6
3Display Results1471470.0632333.3
 (SQL Overall)1786911476.37628025.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.