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

533 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
degame10271318(None) 
defame123212431defame
degage92711381degage
degames113312621degames
degami10279001degami
became123213162became
begaze1838332begaze
bename103316072bename
dame77140312d__ame
deave95022332de_ave
debase94014472debase
debate94419192debate
decade104216162decade
decamp1338452decamp
decane93818872decane
decare93919152decare
deface123113862deface
defamed14309832defamed
defamer132710322defamer
defames132812252defames
degamis11268432degamis
degas75119162dega_s
degases93413102degases
deglaze1835582deglaze
degrade10229902degrade
degree82814852degree
degum94711902degum_
degums10438622degums
dekare112811562dekare
delate73827752delate
delime9314042delime
deme76536282de__me
derate74531232derate
digamy1335882digamy
game76644322__game
legate72917452legate
legume936912legume
negate72915572negate
pregame1239552pregame
regale74821452regale
regave104713382regave
regime95313942regime
rename82718812rename
sesame8311012sesame
aerate64830553aerate
aflame1138723aflame
agama85815573_agama
agape85614843_agape
agate66525143_agate
agave95314033_agave
agaze156113663_agaze
algae65319623alga_e
arame75026623_arame
beagle93612593beagle
beam86939233be_am_
beamed115720733be_amed
beams95328173be_ams
beamy126218573be_amy
become123312593become
bedamn1137813bedamn
begall92610723begall
began86319573bega_n
begat86629723bega_t
begazed2036203begazed
begazes1937963begazes
begone9512133begone
begrime1276553begrime
begum105213923begum_
begums11429493begums
behave14209013behave
beldame1237233beldame
benamed122911093benamed
benames112814603benames
berake124216083berake
berate84729023berate
berime105317333berime
berme96022943be_rme
beshame1447483beshame
betake124512703betake
betime105914833betime
beware11313713beware
bigamy1436333bigamy
blame95625493_blame
byname13256363byname
came87648753__came
cease75227653ce_ase
cerate84829463cerate
cetane8315283cetane
dace76934923d__ace
daggle93711903daggle
dale55643983d__ale
dam67457043d__am_
damage10410773damage
dames85435853d__ames
damn75724323d__amn
damp96228843d__amp
dams77444373d__ams
dare55848863d__are
date56443323d__ate
daze147327233d__aze
dead65434243de_a_d
deaden83714323de_aden
deader84220473de_ader
deadmen11248573deadmen
deads75726913de_ads
deaf85838403de_a_f
deafen10389673de_afen
deafer104114813de_afer
deair65817193de_air
deal56347413de_a_l
dealate83617843dealate
dealer74122143de_aler
deals65435343de_als
dealt65234283de_alt
dean56039483de_a_n
deaned84620453de_aned
deans66131393de_ans
dear55343603de_a_r
dearer74822803de_arer
dearie73319813dearie
dears65736883de_ars
deary95826843de_ary
deash95617243de_ash
death94822523de_ath
deaved114916553de_aved
deaves105319533de_aves
debacle1237443debacle
debag94212303deba_g
debags104211063debags
debar85517863deba_r
debark134210943debark
debars94218043debars
debased113310583debased
debaser103510413debaser
debases103814133debases
debated113916083debated
debater104114693debater
debates103718523debates
debone93714783debone
debye1138903de_bye
decades113615503decades
decaf114919443deca_f
decafs124010883decafs
decal85523233deca_l
decals93717713decals
decamped1634963decamped
decamps1435643decamps
decanes103118913decanes
decant93524223decant
decares102818533decares
decay114718483deca_y
decayed14309333decayed
decayer13339353decayer
decays124612913decays
decease1049523decease
deciare10710663deciare
decide104116873decide
decile94619213decile
deckle1312012453deckle
declare10411223declare
decode104414743decode
decree93117783decree
dedal75719023deda_l
dedans85915073dedans
deduce1079253deduce
dee47665823de___e
deem75432893de_em_
deemed104713063de_emed
deems85421773de_ems
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defamers14258523defamers
defang1137753defang
defat95426693defa_t
defats105114553defats
defile105216663defile
define104718143define
deflate113613943deflate
defoam1238563defoam_
defoamed15356243defoamed
defoamer14276213defoamer
defoams1336193defoams
defuse105712723defuse
defuze19487843defuze
degassed11275963degassed
degasser10325813degasser
degasses10278363degasses
degauss933923degauss
degerm1037893degerm
degermed1335453degermed
degerms1135623degerms
deglazed2034953deglazed
deglazes1935463deglazes
degraded12288323degraded
degrader11247913degrader
degrades11269923degrades
degrease1045413degrease
degreed10258883degreed
degrees92810723degrees
degummed1542603degummed
degust8310253degust
deice84320033de_ice
deism84116033deism_
deisms94411043deisms
dekares122710873dekares
deke95228763de__ke
delaine8314783delaine
delated93722873delated
delates83526283delates
delay94820633dela_y
delayed123310763delayed
delayer113010533delayer
delays104014053delays
dele56843083de__le
deleave1147723deleave
delegate10410463delegate
delete73620703delete
delimed11310723delimed
delimes10314193delimes
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
delve96018263de_lve
demand104314253demand
demark134211023demark
demast9517063demast
demes86032693de__mes
demise94618323demise
demo77427553de__mo
demode104013463demode
demote94817803demote
demure9311533demure
demy105422853de__my
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
dene56643413de__ne
dengue838253dengue
denim85518843denim_
denimed1159233denimed
denims95214323denims
denote74118043denote
dense65923503de_nse
dentate8315153dentate
denude8169353denude
depart94720563depart
deplane10311413deplane
deplume1255063deplume
depone93616553depone
depose94215763depose
deprave1337073deprave
depute94512303depute
derail74218813derail
derange939813derange
derat65044083dera_t
derated93623503derated
derates84028883derates
derats74625063derats
deray95024183dera_y
derays105514253derays
dere56845903de__re
deride84420033deride
derive103817043derive
derm76031893de_rm_
derma84918513de_rma
dermal93614343dermal
dermas94116813dermas
derms85022893de_rms
derogate10311353derogate
desalt7518313desalt
desand84812633desand
desire7415303desire
deskmen1435023deskmen
desman9311693desman
detach12310413detach
detail74516433detail
detain74617383detain
deuce84517493de_uce
deva85720983deva__
devalue1136013devalue
devas96218883deva_s
deviate11312713deviate
device124512163device
devise104215753devise
devote104513783devote
dewan95718043dewa_n
dewans105215143dewans
dewar95817733dewa_r
dewars105117073dewars
dewater112912423dewater
dewax165510853dewa_x
dewaxed19316053dewaxed
dewaxes18297843dewaxes
dexie134716893de_xie
digamies1238623digamies
digamma1343093digamma
dilate73220693dilate
dime76237643d__ime
diram84419473diram_
dirams94413703dirams
disme85716243d_isme
dogbane1135653dogbane
doge66233803dog__e
dogface1454053dogface
doggie93910893doggie
dogie75222793dog_ie
dogma96112463dog_ma
dogmas105011243dogmas
dogvane1243853dogvane
dome77240733d__ome
donate73619503donate
dosage82810003dosage
dotage82711613dotage
dragee84415603dragee
drake104918303d_rake
dram75832003d_ram_
drama85117413d_rama
drams86025833d_rams
drape85319633d_rape
drave95219273d_rave
dream85120393dream_
dreamed114310633dreamed
dreamer104110843dreamer
dreams94513983dreams
dreamt94615713dreamt
dreamy12509993dreamy
dunam8313733dunam_
dunams937833dunams
duramen1096903duramen
dynamo1274163dynamo
eagle64219483_eagle
eagre64315323_eagre
ease45042333_e_ase
eave75733583_e_ave
edge65719663edg__e
egad64215413_ega_d
egads74610923_egads
egal55119433_ega_l
elate55335883_elate
eme55837183_e__me
enamel81210113_enamel
enate54428143_enate
endgame1145233endgame
engage82812103engage
erase54925493_erase
ergate7315143ergate
etape74413703_etape
evade938183_evade
exam132514623_exam_
examen1538283_examen
exams14199083_exams
fame95639393__fame
fease84824873fe_ase
feaze175216313fe_aze
female11310553female
feme96130543fe__me
femme125011433fe_mme
flame105124443_flame
frame105821803_frame
gae46457703__ga_e
gage65936103__gage
gale56347323__gale
gam67060063__gam_
gama77035513__gama
gamb96331843__gamb
gambe106219213__gambe
gamed95126393__gamed
gamer84928943__gamer
games86238553__games
gamey115320553__gamey
gamp98833213__gamp
gams76648883__gams
gamy105427533__gamy
gane55145293__gane
gape75134513__gape
gate55746573__gate
gave84634053__gave
gaze145032413__gaze
gelate73421253gelate
gemmae11507793gemmae
genome94312193genome
hame97043133__hame
heaume1137543heaume
heave114521813he_ave
hegari1039513hegari
hegumen1355463hegumen
heme95034413he__me
hermae115314473hermae
hexade17438903hexade
hexane16379533hexane
ideate7313683ide_ate
ingate73018233ingate
jugate14379463jugate
kame105728233__kame
lame66849293__lame
league758743league
lease55230263le_ase
leave84723723le_ave
legacy1256653legacy
legal65715943lega_l
legals73412733legals
legated92513983legated
legatee82814633legatee
legates82917673legates
legato72810953legato
legman949653legman
legmen939343leg_men
legumes1036633legumes
lexeme1536493lexeme
ligase7259913ligase
ligate72519243ligate
madame1139853madame
meagre9349323meagre
mega77620873mega__
megara9310093megara
megass9219443megass
megasse10266243megasse
melamed1249633melamed
meme85330553me__me
menace103216943menace
menage93216543menage
metage93114453metage
metamer1139613metamer
metate82720533metate
name65637413__name
negated93413233negated
negater83711953negater
negates83215833negates
neume74414403ne_ume
nongame1038173nongame
ogam75120033_ogam_
ogams84112683_ogams
oogamy1235633oogamy
peace95026083pe_ace
peage84723563pe_age
pease75231113pe_ase
pedate93117763pedate
pelage9515363pelage
penname11328553penname
pesade9311103pesade
pregames1339003pregames
prename11412643prename
ream65841613re_am_
reamed94326123re_amed
reamer84325213re_amer
reams75729623re_ams
reave84528023re_ave
rebate84424103rebate
recane83022873recane
reclame11411063reclame
redate74124683redate
reface113616353reface
reframe1239393reframe
regain74517763regain
regal65023793rega_l
regaled93615953regaled
regaler83814623regaler
regales83520793regales
regard85215773regard
regauge945813regauge
reggae858953reggae
regimen104411573regimen
regimes104514743regimes
regive104814323regive
reglaze1747223reglaze
reglue739703reglue
regma84612333reg_ma
regrade92612033regrade
regrate82618653regrate
relace83122153relace
relate64033633relate
relume8313273relume
remade94316983remade
remake124016113remake
remate84428683remate
renamed103114523renamed
renames92418053renames
repave114813873repave
resale64025543resale
resume8313783resume
retake104718533retake
retape83917683retape
retime85321803retime
revamp1336013revamp
rewake135218463rewake
rugae65114763ruga_e
rugate75813813rugate
sagamen10127503sagamen
same65245643__same
seam66645973se_am_
seamed94823883se_amed
seamen84518563se_amen
seamer84223613se_amer
seams75731663se_ams
seamy105921273se_amy
sedate73019803sedate
segue6314413seg_ue
seme65836653se__me
sememe10129983sememe
senate63725143senate
serape84818413serape
sesames9310743sesames
setae56026223seta_e
sewage10310733sewage
shame105726703_shame
tame66343663__tame
team66238653te_am_
teamed95418593te_amed
teams75726513te_ams
tease55428713te_ase
tegmen988403teg_men
tegumen10105423tegumen
telae54323293tela_e
telome8311923telome
tenace82715693tenace
togae67020113toga_e
togate74515683togate
untame82513603untame
upgaze1833543upgaze
vegan95114153vega_n
vegans103910853vegans
vegete1039483vegete
veggie1136303veggie
vegie94614513veg_ie
velamen1237123velamen
velate93720143velate
venae85920983vena_e
wakame1535433wakame
wame95035483__wame
weave115218533we_ave
yeggmen1442673yeggmen

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165336.53017261.3
3Display Results5335330.1733080.9
 (SQL Overall)1786915336.84326113.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.