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

183 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
megasses1130774(None) 
degasses10278361degasses
megasse10266241megasse_
avgasses1284192avgasses
bagasses1136312bagasses
degases93413102dega_ses
degassed11275962degassed
degasser10325812degasser
degassers11354832degassers
degausses1143202degausses
eyasses10388022_eyasses
gasses75724782__gasses
masses85028712m__asses
measles92412752me_asles
megadoses1344662megadoses
megass9219442mega_s_s
messes84924342me__sses
metisses1036832metisses
molasses1037232molasses
morasses1038902morasses
repasses101810372repasses
admasses1135413admasses
aegises8311373aeg_ises
amasses93912853_amasses
asses55629283___asses
avgases11106313avga_ses
badasses1136173badasses
bagasse1035143bagasse_
basses85428303__basses
begazes1937963bega_zes
bekisses1434243bekisses
biasses94911653_biasses
biogasses1244003biogasses
brasses93818353_brasses
bypasses1533833bypasses
camasses12388973camasses
ceases84427073ce_a_ses
cerastes101111093cerastes
cesses84221363ce__sses
chasses124017503_chasses
classes94717943_classes
crevasses1444143crevasses
deashes113313903de_ashes
debases103814133deba_ses
declasses1246443declasses
degames113312623dega_mes
degauss933923degaus_s
degaussed1242543degaussed
degausser1172163degausser
degaussers1241663degaussers
detassel943653detassel
detassels1042673detassels
eases56041613_e_a_ses
easies64126633_e_asies
eelgrasses1142573eelgrasses
egises7312493_eg_ises
egresses949443_egresses
elapses957663_elapses
embassies1344003embassies
embosses1235963embosses
emdashes14224303emdashes
erases64425403_era_ses
esses56422973_e__sses
eyases94513683_eya_ses
eyeglasses1442263eyeglasses
feases95422923fe_a_ses
fesses94820253fe__sses
frasses104314513_frasses
gases65633993__ga_ses
gashes105725153__gashes
gassed85217633__gassed
gasser75017773__gasser
gassers84714633__gassers
gausses8308693__gausses
glasses84414273_glasses
grasses84117343_grasses
harasses11311033harasses
hearses104414533he_arses
impasses12257523impasses
jesses135215953je__sses
kavasses1544303kavasses
kvasses14365503_kvasses
lasses64827593__lasses
leases65428113le_a_ses
leashes103514403le_ashes
legacies1139043legacies
legaleses1044393legaleses
legalises1038563legalises
legatees9258433legatees
legates82917683lega_tes
ligases82310713liga_ses
malaises10312333malaises
manses84225513m__anses
marses84827113m__arses
mashes115030003m__ashes
massas85116463m__assas
masse75125293m__asse_
massed94421323m__assed
matelasses1254003matelasses
matrasses1157293matrasses
mealies92821933me_alies
meanies93620743me_anies
measle83513223me_asle_
measled10339303me_asled
measures1038913me_asures
meatuses1038203meatuses
megabars1344403megabars
megabits1355793megabits
megabytes1743183megabytes
megadose1244493megadose_
megadynes1642773megadynes
megahits1445683megahits
megalops1356123megalops
megalopses1543553megalopses
megaplex2042513megaplex
megapodes1544233megapodes
megapods1444903megapods
megaspores1543533megaspores
megastar1143533megastar
megastars1243653megastars
megatons11279703megatons
meioses9310833me_ioses
melanges1138613melanges
melanoses1147293melanoses
menaces112715523mena_ces
menages103615393mena_ges
menses84222453me__nses
menshes12310453me_nshes
merganser1242853merganser
mergansers1342243mergansers
merises93421423me_rises
meshes115019443me__shes
mesnes85216213me__snes
messages1138233messages
messed95018183me__ssed
metages102714973meta_ges
metalises11315073metalises
metastases1244543metastases
metates92720013meta_tes
metisse936503metisse_
misses85130873m__isses
mosses85527683m__osses
mousses94012703m_ousses
musses84624783m__usses
mutases92012043muta_ses
myases113711553m_ya_ses
myiases1235493myia_ses
negates83215843nega_tes
neguses837933neg_uses
nesses64718323ne__sses
outgasses1036663outgasses
passes86030473__passes
peases85229473pe_a_ses
pelisses1048483pelisses
petasoses1145443petasoses
petasuses1144373petasuses
quasses16209503_quasses
reassess836513re_assess
recesses10312323recesses
regales83520793rega_les
regauges1046093regauges
reglosses1045343reglosses
regresses10310463regresses
rehashes1436953rehashes
relapses1038033relapses
repassed11229273repassed
reraises8415643reraises
retastes82212903retastes
rewashes1447033rewashes
rubasses1035493rubasses
ryegrasses1442463ryegrasses
sasses64124393__sasses
strasses81311443strasses
syngasses1343813syngasses
tasses64826763__tasses
teargasses1143063teargasses
teases65426273te_a_ses
texases1437573texa_ses
trasses74819323_trasses
vinasses1135703vinasses
wrasses103812593_wrasses
yesses93615813ye__sses
zebrasses2043513zebrasses

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.436409841.7
2DLD Change Limit1461621838.42317352.7
3Display Results1831830.0632904.8
 (SQL Overall)1786911838.92220028.1
 
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.