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

139 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
murdering135713(None) 
bordering1338832bordering
burdening1335542burdening
juddering1933762juddering
maundering1455352maundering
moldering1367862moldering
mouldering1474282mouldering
murmuring1443632murmuring
murthering1644472murthering
mustering122212332mustering
muttering122611322muttering
ordering1039352_ordering
sundering11312322sundering
barbering14229693barbering
bartering122313653bartering
blundering1444823blundering
bouldering1464763bouldering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
burring104016993bur__ring
buttering122312533buttering
careering12311203careering
cindering13311223cindering
cornering12311893cornering
cumbering16108203cumbering
curding113515133curd__ing
curdling12228893curd_ling
curring103616843cur__ring
curveting1535353curveting
dandering122511063dandering
daundering1364463daundering
doddering1335183doddering
embordering1752623embordering
foddering1535163foddering
foundering1545353foundering
fullering1336653fullering
furring114013143fur__ring
furthering1744353furthering
gandering122111293gandering
gardening1236513gardening
garnering11298093garnering
gartering112111593gartering
gendering12249753gendering
guttering112410443guttering
hardening1438023hardening
hindering14310273hindering
hungering14187683hungering
hunkering17227123hunkering
hurdling13288013hurd_ling
laddering1237593laddering
laundering1245183laundering
lumbering14117933lumbering
lustering102711203lustering
maddening1445113maddening
mammering1337333mammering
marketing1636513marketing
marring103319553mar__ring
martyring1535783martyring
marveling1537103marveling
mastering122315313mastering
mattering122314063mattering
meandering1446983meandering
metering112915633m_etering
mildening1345673mildening
mildewing1643733mildewing
mirroring1246193mirroring
misordering1544033misordering
mitering113015403m_itering
modeling12311073m_odeling
modeming1437103m_odeming
mongering13310353mongering
morseling1238073morseling
mortaring1237943mortaring
mothering152110183mothering
mudding123310813mu_d_ding
muddling13268593mu_ddling
muddying16254543mu_ddying
murder93613783murder___
murdered1236033murder_ed
murderee1146843murder_ee
murderees1244353murderees
murderer1145263murder_er
murderers1244593murderers
murderess1243593murderess
murderous1244663murderous
murders103311363murder__s
murein8311763mur_e_in_
mureins9310733mur_e_ins
muring95120373mu___ring
murrine9411483mur__rine
niddering1255323niddering
nidering10510483_nidering
numbering14107003numbering
nurturing1045013nurturing
outdaring1179723outdaring
pandering133211963pandering
perduring1336013perduring
plundering1444183plundering
pondering132411333pondering
portering122012303portering
powdering16246503powdering
puckering1835883puckering
pureeing1137273pur_eeing
purring104515823pur__ring
purveying1843573purveying
puttering122611643puttering
quartering2045853quartering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rendering112213183rendering
reordering1266213reordering
rubbering1435703rubbering
shuddering1643513shuddering
smoldering1474103smoldering
smouldering1572173smouldering
soldering1169033soldering
suckering1638103suckering
suffering1637293suffering
summering1458753summering
supering11317683su_pering
surveying1644963surveying
teddering12256303teddering
tendering112210813tendering
thundering1544573thundering
tuckering1635693tuckering
ulcering1139333_ulcering
umbering1399433_umbering
undaring10412753_undaring
underling111514613_underling
underwing141410883_underwing
ushering1258923_ushering
uttering91613083_uttering
wandering143310983wandering
wildering1456743wildering
wondering142110463wondering
wuthering1697803wuthering

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411396.39323250.6
3Display Results1391390.0602316.7
 (SQL Overall)1786911396.87325999.0
 
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.