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

164 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
massed9442132(None) 
amassed10388631amassed
gassed85217631gassed
mashed125325041mashed
masked134316521masked
masse75125291masse_
masses85028711masses
masted94025801masted
messed95018181messed
missed94423601missed
mossed94818891mossed
mussed94418901mussed
passed94320941passed
sassed76116171sassed
amasser9418732amasser
amasses93912852amasses
amused94412512amused
ashed97829772_ashed
asked106919312_asked
asses55629282_asses
asset55932262_asset
based85331582ba_sed
bashed126225702bashed
basked135218602basked
basses85428302basses
basset85225382basset
basted95227232basted
biassed10418702biassed
bossed94816532bossed
brassed103612372brassed
bussed94717052bussed
cased86032412ca_sed
cashed125124352cashed
casked134815512casked
caused95117042caused
cessed94615612cessed
chassed134712132chassed
classed104113652classed
cussed94917122cussed
dashed115920562dashed
dissed85220182dissed
dossed84516632dossed
eased65430402ea_sed
fashed136720252fashed
fasted105320952fasted
fessed104515062fessed
fussed104613802fussed
gashed116321972gashed
gasped104814292gasped
gasser75017772gasser
gasses75724782gasses
gasted84821582gasted
glassed93710432glassed
grassed93812792grassed
hashed136021942hashed
hasped125014442hasped
hassel95614212hassel
hassled11358302hassled
hasted105125282hasted
hissed104114452hissed
jassid1467222jassid
jessed144112302jessed
kissed114412852kissed
lapsed94712582lapsed
lased65132342la_sed
lashed105625212lashed
lasses64827592lasses
lassoed8408742lassoed
lasted74323602lasted
maced108528692ma_ced
macled116718112macled
madded113513552madded
mailed95326752mailed
maimed114812662maimed
malfed12369762malfed
malled94626112malled
malted94819862malted
maned86634102ma_ned
manned94418642manned
manse75528232manse_
manses84225512manses
mapped134015882mapped
marked133921622marked
marled95523162marled
marred95421042marred
marse76231152marse_
marses84827112marses
marted94425212marted
maser75029972ma_ser
masher114123202masher
mashes115030002mashes
masjid16187322masjid
maskeg13388692maskeg
masker124416102masker
masoned1039802masoned
mass66044942mass__
massa75518922mass_a
massaged1236752massaged
massas85116462massas
massedly1444302massedly
masseur935702masseur
massier93615222massier
massif11412532massif
massy104518962mass_y
master84831342master
mated85537782ma_ted
matted94521412matted
mauled94817822mauled
mawed115824742ma_wed
maxed155821192ma_xed
mayed115522402ma_yed
mazed175523872ma_zed
measled10339302measled
mensed93916542mensed
meshed124415932meshed
messes84924342messes
misfed124113022misfed
misled94719312misled
missel85216522missel
missend104411372missend
misses85130872misses
misset85028152misset
misted93625822misted
misused104111282misused
moshed124517492moshed
mosser84618272mosser
mosses85527682mosses
moused94423302moused
moussed10338912moussed
mused85524582m_used
mushed124420842mushed
mussel83412902mussel
musses84624782musses
musted93321072musted
parsed96323892parsed
pashed125923142pashed
passe75525692passe_
passee84522022passee
passel85117002passel
passer84721032passer
passes86030472passes
pasted94426902pasted
paused95114962paused
pissed94816932pissed
raised76120332raised
rased65033932ra_sed
rasped94715202rasped
rassled83310452rassled
sashed105622942sashed
sasses64124392sasses
smashed133711222smashed
sussed75015532sussed
tasked114714642tasked
tasse54821842tasse_
tassel66014772tassel
tasses64826762tasses
tasset65925312tasset
tasted74123972tasted
tawsed10499742tawsed
tossed74215222tossed
washed135521502washed
wasted104423022wasted
wissed104114642wissed
yessed104511162yessed

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 Filter178691825510.343520965.0
2DLD Change Limit825511642.59331836.1
3Display Results1641640.0463565.2
 (SQL Overall)1786911642.98259923.2
 
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.