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

131 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
blackness173566(None) 
blankness1544671blankness
slackness1535431slackness
backless162910632b_ackless
blackeners1844122blackeners
blackens16388102black_ens
blackest16269302black_est
blacklegs1843912blacklegs
blacknesses1944992blacknesses
blandness1235972blandness
bleakness1543592bleakness
laciness102112552_laciness
lankness12237042_lankness
packness1636932_packness
slickness1535902slickness
backers153821893b_ack_ers
backrest1639393b_ackrest
backrests1744983b_ackrests
backsets1638853b_acksets
badness1039573b_a_dness
baldness1137043b_aldness
balkiness1556903balkiness
balminess1356593balminess
bareness10912813b_areness
barkless14318023b_arkless
baroness101210063b_aroness
baseness10910943b_aseness
bassness1096743b_assness
beadiness12249233beadiness
beakless14297383bea_kless
biasness1035813bia_sness
blackboys2243333blackboys
blackcaps2143353blackcaps
blacked163613373black_e_d
blacken15439793black_e_n
blackened1845273blackened
blackener1754973blackener
blacker154513513black_e_r
blackfins2054393blackfins
blackfish2343833blackfish
blackgums2042543blackgums
blackhead2184303blackhead
blackheads2264113blackheads
blackings18316763blackings
blackish1976713black_ish
blacklead1863903blacklead
blackleads1993383blackleads
blackleg1734233blackle_g
blacklist1746123blacklist
blacklists1844183blacklists
blackouts1745153blackouts
blacks144914953black___s
blacktops1943373blacktops
bladeless1234303bladeless
blameless1334733blameless
blankest14439063blank_est
blankets14356503blank_ets
blanknesses1744933blanknesses
blarneys13183193bla_rneys
blazoners2043863blazoners
bleariness1246053bleariness
blindness1235343blindness
blockers16398793block_ers
blockiest1736363blockiest
blondness1234963blondness
blowiness1435623blowiness
blueness1038213bl_ueness
bluffness1742503bluffness
bluntness1144343bluntness
brackens16327923brack_ens
brackets163310433brack_ets
bractless1335543bractless
brashness1436323brashness
braveness14237763braveness
briskness1544773briskness
butchness1643453butchness
clackers163911703clack_ers
clickless1743983clickless
cracknels1743433cracknels
dankness13256693_dankness
darkness13247343_darkness
deaconess1245543deaconess
exactness1843623exactness
flakiness1636473flakiness
flatness1138153fla_tness
fleckless1842893fleckless
flockless1843163flockless
frankness1655223frankness
gladness1036153gla_dness
glariness1038553glariness
glaziness1935753glaziness
hackneys2033683_hackneys
laceless10239853_laceless
lackers134120543_lack_ers
lackeys16458263_lack_eys
lacunes9159623_lacune_s
lameness102612673_lameness
lankiness1338053_lankiness
larkiness1338123_larkiness
lateness82614073_lateness
laxness1436043_la_xness
laziness17239983_laziness
luckiness1596573_luckiness
luckless14265893_luckless
oblateness1244893oblateness
placeless1335613placeless
placidness1553303placidness
plackets1646583plack_ets
plainness1155193plainness
planeness1138163planeness
pluckiness1883823pluckiness
quickness2443733quickness
raciness102413453_raciness
rankness12267943_rankness
sickness1437833_sickness
slackeners1643423slackeners
slackens14367713slack_ens
slackers143812743slack_ers
slackest14289403slack_est
slacknesses1745243slacknesses
slatiness92511363slatiness
sleekness1344543sleekness
spaciness1337083spaciness
stackless1555933stackless
starkness1335963starkness
tackiness1557693_tackiness
tackless14419483_tackless
thickness1844443thickness
trackless15246723trackless
wackiness1836523_wackiness
weakness1535353wea_kness

Search took 9 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.673265514.1
2DLD Change Limit1486411317.40620070.3
3Display Results1311310.0632079.4
 (SQL Overall)1786911318.14221946.8
 
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.