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

189 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
degasses1027836(None) 
degases93413101dega_ses
degassed11275961degassed
degasser10325811degasser
degassers11354831degassers
degausses1143201degausses
megasses11307741megasses
avgasses1284192avgasses
bagasses1136312bagasses
deashes113313902de_ashes
debases103814132deba_ses
declasses1246442declasses
degames113312622dega_mes
degauss933922degaus_s
degaussed1242542degaussed
degausser1172162degausser
degaussers1241662degaussers
detassel943652detassel
detassels1042672detassels
eyasses10388022_eyasses
gasses75724782__gasses
megasse10266242megasse_
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
daises74318983d__aises
dashes106124983d__ashes
dassies84418663d__assies
dearies83526273de_aries
deashed123411303de_ashed
deaves105319533de_a_ves
debacles1335723debacles
debase94014473deba_se_
debased113310583deba_sed
debaser103510413deba_ser
debasers11377903debasers
debates103718533deba_tes
decades113615513deca_des
decanes103118913deca_nes
decares102818533deca_res
deceases11410153deceases
declasse1165943declasse_
declassed1344993declassed
defaces133213403defa_ces
defames132812253defa_mes
defenses1237913defenses
defuses114814593de_fuses
degage92711383dega_ge_
degame102713183dega_me_
degamis11268443dega_mis
degas75119163dega___s
degassing1234823degassing
deglazes1935463deglazes
degrades11269923degrades
degreases1146153degreases
degrees92810723deg_rees
degusted1135733degusted
degusts936063deg_usts
dehisces1464713dehisces
deixises1635693deixises
dekares122710873deka_res
delaines9312963delaines
delates83526283dela_tes
delouses9310013delouses
demasted1238763demasted
demasts1089223dema_sts
demesnes1137083demesnes
demises103719563de_mises
demitasses1342953demitasses
demoses103815823de_moses
deposes103117213de_poses
depresses1259883depresses
deranges1039973deranges
derates84028893dera_tes
dermises112512023dermises
derrises93012783derrises
despises1139433despises
detaches1439653detaches
devalues1235853devalues
devisees12358283devisees
devises114116763de_vises
dewaxes18297843dewa_xes
digamies1238643digamies
digresses1137863digresses
disses75225963d__isses
dosses76126273d__osses
dresses83716173d_resses
drosses84513823d_rosses
duenesses1039333duenesses
duresses939173duresses
eases56041613_e_a_ses
easies64126633_e_asies
eelgrasses1142573eelgrasses
egises7312493_eg_ises
egresses949443_egresses
elapses957663_elapses
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
masses85028713__masses
measles92412753me_asles
megadoses1344663megadoses
megass9219443mega_s_s
messes84924343me__sses
metisses1036833metisses
molasses1037233molasses
morasses1038903morasses
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.440406115.9
2DLD Change Limit1461621897.90618487.5
3Display Results1891890.0762486.8
 (SQL Overall)1786911898.42221217.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.