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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
black13471907(None) 
alack114820061alack
back125535761b_ack
blacks144914951blacks
blank115418551blank
block134917841block
clack134720171clack
flack144519411flack
lack105837681_lack
plack135017841plack
slack115021761slack
aback134816172aback
bach116131392b_ach
backs135729622b_acks
balk105132222b_alk
bank105835752b_ank
bark106242152b_ark
bask105131422b_ask
beach124623892beach
beak106534382bea_k
beck126226572b_eck
bipack1636522bipack
blab86629132bla_b
blabs95619632blabs
blacked163613372blacked
blacken15439792blacken
blacker154513512blacker
blackly1835252blackly
blade85923332blade
blae66134642bla_e
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blain75421792blain
blam86131702bla_m
blame95625492blame
blams95023852blams
blanch133410852blanch
bland85320452bland
blanks124112892blanks
blare75826232blare
blase75524232blase
blast76532572blast
blat66550952bla_t
blate75933782blate
blats75132502blats
blaw97026722bla_w
blawn106813702blawn
blaws105620462blaws
blaze165520832blaze
bleach133611402bleach
bleak115915382bleak
blink115720142blink
bloc85023272bloc_
blocks144513942blocks
blocky17388352blocky
blocs95219652blocs
bock126032512b_ock
brace95629272brace
brach126123302brach
bract96332722bract
brank115222282brank
brick134618152brick
brock136017072brock
buck125129902b_uck
clach124617822clach
clacks144516342clacks
clank114719522clank
click135217952click
clock134917982clock
cluck134914892cluck
crack134120532crack
flacks154114532flacks
flak116026172fla_k
flank124618092flank
flask125512422flask
fleck148213592fleck
flick145017212flick
flock144717422flock
glace87420162glace
hack135134542_hack
jack175224862_jack
klick105311442klick
knack104311042knack
kyack13468262kyack
lac510155822_lac_
lace66848472_lace
lacks116129202_lacks
lacs66942482_lacs
lacy95829632_lacy
lank84734452_lank
lark85733862_lark
lick106935082_lick
lock106134362_lock
luck105329822_luck
mack125733652_mack
pack125535442_pack
place94824612place
placks144414152placks
plank115221142plank
pluck134212302pluck
quack203812502quack
rack106234882_rack
sack105337312_sack
shack145321752shack
slacks124416532slacks
slank95822772slank
slick115520522slick
smack134615452smack
snack114718062snack
stack114421692stack
tack106536292_tack
thack144915172thack
track114823012track
wack135330912_wack
whack174813022whack
wrack145413882wrack
yack135425972_yack

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001181.60633499.4
3Display Results1181180.0333575.8
 (SQL Overall)1786911181.95291542.5
 
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.