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

208 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
masse7512529(None) 
manse75528231manse
marse76231151marse
mass66044941mass_
massa75518921massa
massed94421321massed
masses85028711masses
massy104518961massy
passe75525691passe
tasse54821841tasse
amass77119682amass_
amassed10388632amassed
amasser9418732amasser
amasses93912852amasses
amuse75920832amuse
apse67725382_apse
arse46539272_arse
ass37844062_ass_
asses55629282_asses
asset55932262_asset
base64847022ba_se
bases75644352bases
bass66146782bass_
basses85428302basses
basset85225382basset
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
baste74829982baste
carse74934332carse
case65848082ca_se
cases75048382cases
caste75932362caste
cause75225352cause
chasse115114602chasse
dassie74615572dassie
ease45042332ea_se
eases56041612eases
false84818122false
fesse86116332fesse
fosse86119462fosse
gases65633992gases
gassed85217632gassed
gasser75017772gasser
gasses75724782gasses
gassy95514022gassy
hanse85722792hanse
hassel95614212hassel
hassle93711592hassle
haste85927862haste
hawse116015122hawse
impasse11246462impasse
jesse126012832jesse
lapse74917682lapse
lase46148512la_se
lases54944762lases
lass47444542lass_
lasses64827592lasses
lassi56316852lassi
lassie64917742lassie
lasso55015682lasso
mabe85733362ma_be
mabes96331532mabes
mace87345792ma_ce
maces97139962maces
mache125925302mache
macle96127002macle
macs86742512macs_
made75440242ma_de
madre85720172madre
mads76845372mads_
mae57659112ma__e
maes66948402maes_
mage75739132ma_ge
mages85036022mages
mags75444532mags_
mahoe10315572mahoe
maile75232222maile
maist75535682maist
maize164618562maize
make105537892ma_ke
makes115336852makes
male66052302ma_le
males75049792males
mamie95826002mamie
mane65052032ma_ne
manes76648962manes
mange84930202mange
mans66354552mans_
manses84225512manses
maple95521142maple
maps86141052maps_
mare64759332ma_re
mares76457632mares
marge85328332marge
mars66261872mars_
marses84827112marses
marsh105320852marsh
mas58175822ma_s_
masa65034722ma_sa
masas75630412masas
maser75029972maser
mash96039402ma_sh
mashed125325042mashed
masher114123202masher
mashes115030002mashes
mashie11315932mashie
mashy136016502mashy
mask105227362ma_sk
masked134316522masked
maskeg13388692maskeg
masker124416102masker
masks115320532masks
mason74820182mason
masque17249382masque
massage1039892massage
massas85116462massas
masseur935702masseur
massier93615222massier
massif11412532massif
massive12289772massive
mast65959962ma_st
masted94025802masted
master84831342master
masts77035762masts
mate65154222ma_te
mates75251362mates
mats65460292mats_
matte75626842matte
mauve104013272mauve
mavie104722562mavie
maws96437142maws_
maxes145629532maxes
maybe12311132maybe
mays96940032mays_
mayst106622672mayst
maze155434982ma_ze
mazes165632172mazes
measle83513222measle
megasse10266242megasse
mense75025632mense
mesne75116292mesne
mess65932432mess_
messed95018182messed
messes84924342messes
messy104913832messy
mise66043582m_ise
mises74740562mises
miss65339422miss_
missed94423602missed
missel85216522missel
misses85130872misses
misset85028152misset
missy105617562missy
misuse83213642misuse
moose76327192moose
morse76032702morse
moss67641032moss_
mossed94818892mossed
mosser84618272mosser
mosses85527682mosses
mosso74715182mosso
mossy105217062mossy
moste75925082moste
mouse77133002mouse
mousse84813032mousse
muse67136032m_use
muses75134302muses
muss64933762muss_
mussed94418902mussed
mussel83412902mussel
musses84624782musses
mussy104117642mussy
myases113711552myases
oases55330982oases
paise75028332paise
parse75236992parse
pase65346862pa_se
pases75346502pases
pass65239952pass_
passed94320942passed
passee84522022passee
passel85117002passel
passer84721032passer
passes86030472passes
paste74932952paste
pause75021832pause
posse74722272posse
raise54828052raise
rase46149982ra_se
rases55447212rases
rassle63813202rassle
sass45035622sass_
sassed76116172sassed
sasses64124392sasses
sassy85813812sassy
tass45640572tass_
tassel66014772tassel
tasses64826762tasses
tasset65925312tasset
tassie66017022tassie
taste55127232taste
tawse85616502tawse
valse85117522valse
vase75629652va_se
vases84626262vases
waste86125052waste
wrasse9398772wrasse

Search took 3 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.313570897.8
2DLD Change Limit538002081.67032215.6
3Display Results2082080.0633301.6
 (SQL Overall)1786912082.04687336.8
 
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.