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

136 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
slack11502176(None) 
alack114820061alack
black134719071black
clack134720171clack
flack144519411flack
lack105837681_lack
plack135017841plack
sack105337311s_ack
shack145321751shack
slacks124416531slacks
slank95822771slank
slick115520521slick
smack134615451smack
snack114718061snack
stack114421691stack
aback134816172aback
back125535762_back
blacks144914952blacks
blank115418552blank
block134917842block
clach124617822clach
clacks144516342clacks
clank114719522clank
click135217952click
clock134917982clock
cluck134914892cluck
crack134120532crack
flacks154114532flacks
flak116026172fla_k
flank124618092flank
flask125512422flask
fleck148213592fleck
flick145017212flick
flock144717422flock
glace87420152glace
hack135134542_hack
jack175224862_jack
klick105311432klick
knack104311042knack
kyack13468262kyack
lac510155822_lac_
lace66848472_lace
lacks116129202_lacks
lacs66942482_lacs
lacy95829632_lacy
lank84734452_lank
lark85733862_lark
lick106935072_lick
lock106134362_lock
luck105329822_luck
mack125733652_mack
pack125535442_pack
place94824612place
placks144414152placks
plank115221142plank
pluck134212302pluck
quack203812502quack
rack106234882_rack
sac57452862s_ac_
sacks114228872s_acks
sacs65739072s_acs
sank85236832s_ank
sark84938972s_ark
shacko153810112shacko
shacks154817562shacks
shank125422192shank
shark126225022shark
shlock15378192shlock
shock144917032shock
shuck144314532shuck
sick106435572s_ick
skank84415582skank
slab67133762sla_b
slabs75322642slabs
slacked143815452slacked
slacken13399932slacken
slacker133915292slacker
slackly1635262slackly
slag55934352sla_g
slags66525902slags
slain54923572slain
slake93724052slake
slam67737972sla_m
slams74927902slams
slang66324022slang
slant55238702slant
slap66434042sla_p
slaps76025712slaps
slash84719682slash
slat46959022sla_t
slatch114510532slatch
slate55438282slate
slats55436902slats
slaty86523152slaty
slave84224032slave
slaw77930712sla_w
slaws85222712slaws
slay76436382sla_y
slays85723682slays
sleek94619042sleek
slice74925822slice
slicks124816112slicks
slink95422912slink
slunk95016302slunk
smacks144112322smacks
smock135311672smock
snacks124514552snacks
snark95419942snark
sneck114713662sneck
snick114416012snick
snuck114411912snuck
soak87227662soa_k
sock105233212s_ock
solace83415822solace
space95325672space
spacy125415622spacy
spank115919572spank
spark114920892spark
speck135115652speck
spick134519072spick
stacks124317262stacks
stalk94518002stalk
stank95823302stank
stark95425622stark
stick115121562stick
stock114417562stock
stuck114515772stuck
suck106131732s_uck
swank125318232swank
tack106536292_tack
thack144915172thack
track114823012track
wack135330912_wack
whack174813022whack
wrack145413882wrack
yack135425972_yack

Search took 3 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.343520965.0
2DLD Change Limit538001361.78030224.7
3Display Results1361360.0334121.2
 (SQL Overall)1786911362.15682880.8
 
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.