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

169 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
megasse1026624(None) 
megass9219441megass_
megasses11307741megasses
bagasse1035142bagasse
degases93413102degases
degassed11275962degassed
degasser10325812degasser
degasses10278362degasses
masse75125292m__asse
measle83513222me_asle
megadose1244492megadose
metisse936502metisse
aegises8311373aegises
avgases11106313avgases
avgasses1284193avgasses
bagass938933bagass_
bagasses1136313bagasses
because1136233because
begaze1838333bega_ze
begazes1937963begazes
cease75227653ce_a_se
ceases84427073ce_ases
chasse115114603_chasse
crevasse1343093crevasse
debase94014473deba_se
debases103814133debases
declasse1165943declasse
degage92711383dega_ge
degame102713183dega_me
degames113312623degames
degas75119163dega_s_
degassers11354833degassers
degauss933923degauss
degaussed1242543degaussed
degausser1172163degausser
degausses1143203degausses
detassel943653detassel
ease45042333_e_a_se
eases56041613_e_ases
egads74610923_egads_
egises7312493_egises
elapse857523_elapse
embassy1442703embassy
erase54925493_era_se
erases64425403_erases
eyases94513683_eyases
eyass84410783_eyass_
eyasses10388023_eyasses
fease84824873fe_a_se
feases95422923fe_ases
fesse86116333fe__sse
gases65633993__gases
gassed85217633__gassed
gasser75017773__gasser
gasses75724783__gasses
gassy95514023__gassy
hearse94114283he_arse
impasse11246463impasse
jesse126012833je__sse
lease55230263le_a_se
leases65428113le_ases
legalese954753legalese
legalise949493legalise
legals73412733legals_
legate72917453lega_te
legatee82814633legatee
legates82917683legates
ligase7259913liga_se
ligases82310713ligases
malaise9312673malaise
manse75528233m__anse
marse76231153m__arse
mass66044943m__ass_
massa75518923m__assa
massed94421323m__assed
masses85028713m__asses
massy104518963m__assy
matelasse1163083matelasse
meads85425323me_ads_
meagre9349323me_agre
mealie82519813me_alie
meals75933383me_als_
meanie83718393me_anie
means75831233me_ans_
measled10339303me_asled
measles92412753me_asles
measly113610443me_asly
measure939033me_asure
meats75034053me_ats_
medals94218063medals_
medusae1044763medusae
mega77620873mega___
megabar1244503megabar
megabit12117963megabit
megabyte1643193megabyte
megadoses1344663megadoses
megadyne1542693megadyne
megahit1378773megahit
megaplex2042513megaplex
megapod1344893megapod
megapode1444303megapode
megara9310093mega_ra
megaron10248303megaron
megaspore1443443megaspore
megastar1143533megastar
megaton10269853megaton
megs75530633meg__s_
meioses9310833meioses
melange1038363melange
menace103216943mena_ce
menaces112715523menaces
menads95514383menads_
menage93216543mena_ge
menages103615393menages
mensae84114053me_nsae
mensas85115863mensas_
mense75025633me__nse
menses84222453me_nses
merganser1242853merganser
merises93421423merises
mesas76823203mesa_s_
mesne75116293me__sne
mess65932433me__ss_
message1037833message
messed95018183me__ssed
messes84924343me__sses
messy104913833me__ssy
metage93114453meta_ge
metages102714973metages
metalise10416053metalise
metals84520893metals_
metate82720533meta_te
metates92720013metates
metisses1036833metisses
molasses1037233molasses
morass84614503morass_
morasses1038903morasses
morassy12495043morassy
mousse84813033m_ousse
mutase82811993muta_se
mutases92012043mutases
myases113711553m_yases
myiases1235493myiases
negate72915573nega_te
negates83215843negates
neguses837933neguses
omegas936983omega_s_
passe75525693__passe
pease75231113pe_a_se
peases85229473pe_ases
pelisse967063pelisse
regale74821453rega_le
regales83520793regales
regauge945813regauge
regave104713383rega_ve
relapse947703relapse
repass84114703repass_
repassed11229273repassed
repasses101810373repasses
reraise7316313reraise
retaste72313133retaste
rubasse934903rubasse
tasse54821843__tasse
tease55428713te_a_se
teases65426273te_ases
texases1437573texases
vegans103910853vegans_
vinasse1044513vinasse
wrasse9398773_wrasse

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271696.67320085.0
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.14225019.7
 
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.