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

181 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
musk10452619(None) 
busk105429221busk
cusk105521631cusk
dusk95724151dusk
husk116021951husk
mask105227351mask
mosk105622441mosk
muck125727851muck
murk105527251murk
mus55946751mus_
muse67136031muse
mush94929121mush
musks116119641musks
musky144715291musky
muss64933761muss
must65145441must
rusk85823311rusk
tusk85621631tusk
amuck1389562amuck
amus65529612amus_
amuse75920832amuse
ask77130702_ask
auk76234142au_k
auks85525262auks
bask105131422bask
bisk106523342bisk
bosk105825732bosk
brusk114912432brusk
buck125129902buck
bulk105426152bulk
bunk105731352bunk
bus56950972bus_
bush96630712bush
busks115521372busks
buss65134912buss
bust65947782bust
busy94727172busy
cask105626432cask
cusks114916052cusks
cusp86021062cusp
cuss65430612cuss
desk95618902desk
disk96625832disk
duck115929172duck
dunk96228572dunk
dusks105317252dusks
dusky135213042dusky
dust57142532dust
emus66821682emus_
fuck134924632fuck
funk115825622funk
fuse76429992fuse
fuss76027932fuss
guck114922532guck
gunk95423572gunk
gush85424002gush
gust55240702gust
huck135927632huck
hulk115321612hulk
hunk116029542hunk
hush105224112hush
husks125015452husks
husky156112562husky
junk155121032junk
jus106930222jus_
just115433342just
luck105329822luck
lunk86030722lunk
lurk86624162lurk
lush75327692lush
lust47442602lust
mack125733642mack
mark105138052mark
mas58175812mas_
masa65034712masa
mash96039392mash
masks115320532masks
mass66044932mass
mast65959952mast
meek105624832meek
merk106027942merk
mesa67025482mesa
mesh96823002mesh
mess65932432mess
mick126333422mick
milk105028462milk
mink106636512mink
mirk106729492mirk
mis58162612mis_
mise66043572mise
miso67229892miso
miss65339412miss
mist66154522mist
mock126429442mock
monk105928512monk
mos57067122mos_
mosh95227602mosh
mosks116117002mosks
moss67641032moss
most66554202most
mouse77133002mouse
mousy106716942mousy
mu46737482mu__
much115224032much
mucks134622642mucks
mucky165015252mucky
mud67336862mu_d
muds75530652muds
muff124723852muff
mug65837692mu_g
mugg86316012mugg
mugs76232042mugs
mujik1866102mujik
mule65236972mule
mull65128802mull
mum76643612mu_m
mumm75718862mumm
mump105425722mump
mums85732772mums
mumu86022062mumu
mun56143852mu_n
muni65824402muni
muns65535912muns
muon65722732muon
mura65633292mura
mure65941332mure
murks114821722murks
murky145216682murky
murr65225132murr
musca9311762musca
mused85524582mused
muser76024122muser
muses75134302muses
mushy135316632mushy
music94316402music
musick14408702musick
muskeg13338182muskeg
musket122818202musket
muskie123412532muskie
muskit122813252muskit
muskox1933952muskox
mussy104117642mussy
musth105314782musth
musts75527442musts
musty105620952musty
mut58357182mu_t
mute65136872mute
muts64839982muts
mutt65739402mutt
nus37939392nus_
oust46747442oust
puck124927942puck
punk105729972punk
pus55547842pus_
push95526622push
puss64830132puss
risk85724102risk
ruck104728332ruck
ruse45938932ruse
rush76628182rush
rusks95816192rusks
rust45544912rust
smush104410582smush
suck106131732suck
suk75632972su_k
suks85927122suks
sulk85326652sulk
sunk85031812sunk
suss45229302suss
task85326652task
tsk75814732_tsk
tuck104626572tuck
turk86125862turk
tush74523902tush
tusks94915532tusks
us26937432_us_
use36835162_use
wuss75219332wuss
yuck136423532yuck
yuk106725602yu_k
yuks116418022yuks

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 Filter178691298720.0632836365.1
2DLD Change Limit298721810.87334217.6
3Display Results1811810.0463934.8
 (SQL Overall)1786911810.982181966.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.