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

165 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
murdered123602(None) 
murderee1146841murderee
murderer1145261murderer
bordered1248932bordered
burdened1236422burdened
juddered1833582juddered
maundered1394942maundered
moldered1237172moldered
mouldered1343752mouldered
murder93613782murder__
murderees1244352murderees
murderers1244592murderers
murderess1243592murderess
murders103311362murder_s
murmured1343112murmured
murthered1544472murthered
mustered112511502mustered
muttered112610792muttered
ordered9108532_ordered
sundered10312152sundered
barbered13259543barbered
bartered113113013bartered
blundered1335193blundered
borderer1168103borderer
bouldered1344483bouldered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
burdener1136143burdener
burred95820723bur__red
burseed1049503burse_ed
burweed1347823burwe_ed
buttered112712623buttered
careered1139493careered
cindered1239793cindered
cornered11311133cornered
cumbered15157963cumbered
curded104217163curd__ed
curdled113910663curd_led
curred94319263cur__red
curveted1435293curveted
dandered112110963dandered
daundered1294423daundered
doddered1234943doddered
dormered1255673dormered
embordered1642493embordered
fendered13258673fendered
foddered1434553foddered
foundered1435403foundered
fullered1236383fullered
furred104514433fur__red
furthered1644473furthered
gandered112211173gandered
gardened1137003gardened
garnered10247113garnered
gartered10319583gartered
gendered11258873gendered
guttered10259163guttered
hardened1338613hardened
hindered1339453hindered
hundred1237143hund_red
hungered13217053hungered
hunkered16186923hunkered
hurdled12379833hurd_led
laddered1136743laddered
laundered1185023laundered
lumbered13188233lumbered
lustered92510603lustered
maddened1334893maddened
mammered12237653mammered
mannered11249653mannered
marketed1537323marketed
marred95421043mar__red
martyred1434283martyred
marveled1436433marveled
mastered112614003mastered
mattered112412903mattered
maunderer1294193maunderer
meandered1346143meandered
membered1535903membered
metered103514013m_etered
mildened1235773mildened
mildewed1543763mildewed
mirrored1145773mirrored
misdeed113211053misde_ed
misordered1443793misordered
mitered103213233m_itered
modeled1139463m_odeled
modemed1336723m_odemed
mongered1238953mongered
morseled1147193morseled
mortared1137213mortared
mothered142310103mothered
mudded114511383mu_d_ded
mudder104413493mudder__
mudders113211113mudder_s
muddied12339213mu_ddied
muddled124111593mu_ddled
mufflered1842123mufflered
muraenid1144563muraenid
muraled10410833mur_aled
muralled1136423muralled
murdering1357133murdering
murderous1244663murderous
mured85726703mu___red
murexes1636973mur_exes
muriated1139793muriated
murker123715243murker__
murmurer1242873murmurer
murre74821073mur__re_
murrelet10167573murrelet
murres85019043mur__res
murrey114312263mur__rey
mutterer10218913mutterer
numbered13147143numbered
nurtured935253nurtured
orderer8127943_orderer
outdared102711513outdared
pandered121812573pandered
perdured12287403perdured
plundered1344313plundered
pondered126411293pondered
portered112311543portered
powdered15256893powdered
puckered1736103puckered
purebred1344253purebred
pureed95017813pur_e_ed
purred94218073pur__red
purveyed1743363purveyed
puttered112611143puttered
quartered19155963quartered
quavered2144813quavered
queered17117213qu_eered
quivered2144823quivered
rendered102512263rendered
reordered1145383reordered
rubbered1335383rubbered
shuddered1543433shuddered
smoldered1343793smoldered
smouldered1441963smouldered
soldered1038153soldered
suckered1537833suckered
suffered1536733suffered
summered1338143summered
sunderer9310523sunderer
supered10316123su_pered
surveyed1544233surveyed
teddered11255183teddered
tendered102510603tendered
thundered1444573thundered
tuckered1535963tuckered
turreted935373turreted
ulcered1037973_ulcered
umbered121510113_umbered
underfed13311713_underfed
unordered1145293unordered
ushered1139153_ushered
uttered82712433_uttered
verderer1245373verderer
verdured13255763verdured
wandered132110793wandered
wildered1336633wildered
wondered13239943wondered
wuthered15157433wuthered

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 Filter1786911461620.486367677.0
2DLD Change Limit1461621658.01318240.6
3Display Results1651650.0802062.5
 (SQL Overall)1786911658.57920828.9
 
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.