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

206 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
mused8552458(None) 
amused94412511amused
bused85624491bused
fused94820441fused
moused94423301moused
muled85824431muled
mured85726701mured
muse67136031muse_
muser76024121muser
muses75134301muses
mushed124420841mushed
mussed94418901mussed
musted93321071musted
muted85023381muted
used55722821_used
abused95614272abused
amuse75920832amuse_
amuser84712622amuser
amuses85117942amuses
based85331582based
bemused1236712bemused
boused95322882boused
buses75936012buses
bushed124822382bushed
busied95117222busied
busked134917702busked
bussed94717052bussed
busted95123152busted
cased86032412cased
caused95117042caused
cubed105519702cubed
cued76329562cu_ed
cured85932132cured
cursed94321252cursed
cusec94614902cusec
cusped114312042cusped
cussed94917122cussed
dosed76626912dosed
doused84821162doused
duded84417132duded
duked115218462duked
duped95118322duped
dured75025402dured
dusked124112512dusked
dusted83918372dusted
eased65430402eased
fumed116118822fumed
fuse76429992fuse_
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fussed104613802fussed
fuzed185415252fuzed
guised84612172guised
gushed114816242gushed
gusted84316722gusted
guyed1049892guyed
hosed95830982hosed
housed105624102housed
hued86925852hu_ed
hushed134416672hushed
husked144212222husked
juked175714072juked
justed144215772justed
lased65132342lased
loused74822912loused
lubed85319892lubed
luged74019092luged
lured65427492lured
lushed104218722lushed
lusted74319442lusted
luted64826142luted
lysed95011562lysed
maced108528692maced
maned86634102maned
maser75029972maser
mashed125325042mashed
masked134316522masked
massed94421322massed
masted94025802masted
mated85537782mated
mauled94817822mauled
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
med66146742m__ed
meed74934702m_eed
mensed93916542mensed
meshed124415932meshed
messed95018182messed
meted85424432meted
mewed115218012mewed
miked125020452miked
mimed105622732mimed
mined85333352mined
mired85729222mired
mise66043582mise_
miser75430402miser
mises74740562mises
misfed124113022misfed
misled94719312misled
missed94423602missed
misted93625822misted
misused104111282misused
mixed155717252mixed
mooed85123982mooed
moped105424732moped
mosey105922872mosey
moshed124517492moshed
mossed94818892mossed
mouse77133002mouse_
mouser85822442mouser
mouses85531422mouses
mousey115216192mousey
moussed10338912moussed
moved114218152moved
mowed113629012mowed
mucid104115252mucid
mucked153816092mucked
mud67336862mu__d
mudded114511382mudded
muffed154210592muffed
mugged114113832mugged
mule65236972mule_
mules75034292mules
muley104819282muley
mulled94721552mulled
mummed104411552mummed
mumped133813162mumped
mure65941332mure_
mures75937212mures
murex145517172murex
murid84520582murid
mus55946752mus__
musca9311762musca
muscid11219832muscid
muscled1237782muscled
musers84719102musers
museum1037702museum
mush94929122mus_h
musher113820572musher
mushes114124562mushes
mushy135316632mushy
music94316402music
musjid16216952musjid
musk104526192mus_k
muskeg13338182muskeg
musket122818202musket
musks116119642musks
musky144715292musky
muss64933762mus_s
mussel83412902mussel
musses84624782musses
mussy104117642mussy
must65145442mus_t
mustee83922102mustee
muster84724522muster
musth105314782musth
musts75527442musts
musty105620952musty
mute65136872mute_
muter74525542muter
mutes75033782mutes
mysid11610692mysid
nosed65524552nosed
nuked104014182nuked
nursed74514662nursed
ousel55222402ousel
ousted73720582ousted
outed65429062outed
paused95114962paused
posed85828412posed
puked124716222puked
puled84926522puled
pulsed94013722pulsed
pursed95220882pursed
puses75532202puses
pushed125017462pushed
rased65033932rased
reused75419562reused
rosed65930342rosed
roused75426442roused
rued55729792ru_ed
ruled65822522ruled
ruse45938932ruse_
ruses56136582ruses
rushed104419862rushed
rusted75020922rusted
smushed13368232smushed
soused74822982soused
sudsed83911372sudsed
sued56537932su_ed
sussed75015532sussed
toused74122012toused
tubed85818042tubed
tuned64622312tuned
tushed104615892tushed
tusked114112152tusked
umped104717272umped
unused72012882unused
use36835162_use_
user45023002_user
uses44931112_uses
vised95518762vised
wised95123342wised

Search took 4 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.310576422.6
2DLD Change Limit538002062.62620487.4
3Display Results2062060.0633269.8
 (SQL Overall)1786912062.99959583.5
 
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.