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

145 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
blandness123597(None) 
blankness1544671blankness
blindness1235341blindness
blondness1234961blondness
badness1039572b_a_dness
baldness1137042b_aldness
bandiness122310242b_andiness
blackness1735662blackness
blandest113811042bland_est
blandnesses1446622blandnesses
bluntness1144342bluntness
boundness1235942boundness
brandless1236122brandless
gladness1036152gla_dness
glandless1134162glandless
grandness1138302grandness
landless94011172_landless
lankness12237042_lankness
planeness1138152planeness
alanines8314803alanine_s
algidness1144273algidness
aloneness957313aloneness
balkiness1556903balkiness
balminess1356593balminess
banders104324563b_and_ers
bandies104124863b_andie_s
banners94018713b_an_ners
bannets94013843b_an_nets
bareness10912813b_areness
baroness101210063b_aroness
baseness10910943b_aseness
bassness1096743b_assness
bawdiness15235543b_awdiness
beadiness12249233beadiness
beardless1234913beardless
belatedness1444863belatedness
biasness1035813bia_sness
bilanders1235963biland_ers
bladders12397803bla_dders
bladeless1234303bladeless
bladers104214683bla_d_ers
blades95221253bla_d_e_s
blameless1334733blameless
blanchers16307433blanchers
blanches153311603blanche_s
blander103715163bland_e_r
blandish1497003bland_ish
blankest14439063blan_kest
blankets14356503blan_kets
blanknesses1744933blanknesses
blarneys13183193bla_rneys
blazoners2043863blazoners
bleakness1543593bleakness
bleariness1246053bleariness
blenders115210993blend_ers
blendes104713683blend_e_s
blinders113911143blind_ers
blindest11609093blind_est
blindnesses1446183blindnesses
blondes104213163blond_e_s
blondest11419243blond_est
blondines1246153blondine_s
blondnesses1445543blondnesses
bloodiness1344353bloodiness
bloodless1234513bloodless
blowiness1435623blowiness
blueness1038213bl_ueness
bluffness1742503bluffness
blunders113911333blund_ers
boldness1136973b_oldness
bondless1148813b_ondless
boniness102211803b_oniness
bonniness1136733bonniness
boundless1235183boundless
braininess1246123braininess
branders114313093brand_ers
brandies11714563brandie_s
branners104010923bran_ners
brashness1436323brashness
braveness14237763braveness
brawniness1544033brawniness
brininess1138203brininess
broadness1256663broadness
canoness1039393_canoness
cleanness1144973clean_ness
dankness13256693_dankness
deadness1039233dea_dness
elatedness1146033elatedness
flakiness1636473flakiness
flannels1134843flan_nels
flatness1138153fla_tness
fluidness1344293fluidness
fondness1237213_fondness
frankness1655223frankness
glanders103811503gland_ers
glandes95413833gland_e_s
glariness1038553glariness
glaziness1935753glaziness
handiness132110933_handiness
handless123512063_handless
hardness122411083_hardness
inaneness948383inaneness
kindness13236653_kindness
laciness102112553_laciness
lameness102612673_lameness
landers84026213_land_ers
landlers94312833_landlers
landmass1144423_landmass
lankiness1338053_lankiness
lanners73618333_lan_ners
lateness82614073_lateness
laundress1042813_laundress
laxness1436043_la_xness
laziness17239983_laziness
leanness837373lean_ness
lewdness1254173_lewdness
loneness8512093_loneness
longness938553_longness
loudness937013_loudness
madness10310073_ma_dness
meanness1037183mean_ness
oblateness1244893oblateness
oldness836403ol__dness
placidness1553303placidness
plainness1155183plainness
planless1036813plan_less
planners10399933plan_ners
pliantness1263643pliantness
randiness102511443_randiness
rankness12267943_rankness
roundness1047013roundness
sadness8310613_sa_dness
sandiness102111713_sandiness
sandless93212343_sandless
saneness82313723_saneness
scantness1135733scantness
slackness1535433slackness
slanders94014013sland_ers
slanginess1146273slanginess
slatiness92511363slatiness
soundness1036963soundness
staidness1037033staidness
validness13125363validness
wanness102610683_wan_ness
zaniness1738663_zaniness

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411457.29620372.9
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.53223724.2
 
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.