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

527 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
dekares12271087(None) 
decares102818531decares
dekare112811561dekare_
bewares12313372bewares
dares66146702d__ares
dearer74822802de_arer
dearest83618672de_arest
dearies83526272de_aries
dears65736882de_ar_s
deaves105319532de_aves
debarks14388492debarks
debars94218042debar_s
debases103814132debases
debates103718522debates
decades113615502decades
decanes103118912decanes
decare93919152decare_
deciares11510632deciares
declares11611312declares
defaces133213402defaces
defames132812252defames
degames113312622degames
degases93413102degases
dekes105224452dek__es
delates83526282delates
demarks14339232demarks
denars74621432denar_s
departs104310682departs
derates84028882derates
desires81316132desires
dewars105117072dewar_s
dewaxes18297842dewaxes
hektares1535812hektares
aerates74627483aerates
alkanes113812933alkanes
ares45871023___ares
bares75457133__bares
beakers134216873beakers
beards94116673be_ards
bearer85323913be_arer
bearers94619593be_arers
bears75739043be_ar_s
begazes1937963begazes
behaves15198523behaves
bemires113212833bemires
benames112814603benames
berakes134815773berakes
berates94126853berates
betakes134212523betakes
beware11313713beware_
bewared13310113bewared
blares85021633_blares
cares77369183__cares
ceases84427073ce_ases
cedars93312833cedar_s
centares102913893centares
centres93817123centres
cerates95428233cerates
ceres75540013ce__res
cetanes9315133cetanes
chares115631803_chares
curares94916853curares
daces85030683d__aces
dales66439743d__ales
damages11511273damages
damars93814993damar_s
dames85435853d__ames
darbs85323263d__arbs
dare55848863d__are_
dared75935013d__ared
darer65230793d__arer
darers75921873d__arers
darks106727873d__arks
darns66927893d__arns
darts67635733d__arts
dataries9314033dataries
dates65639153d__ates
daycares1454803daycares
daymares1445333daymares
dazes155024143d__azes
deaden83714323de_aden
deadens93410693de_adens
deader84220473de_ader
deadest93014883de_adest
deads75726913de_a_ds
deafen10389673de_afen
deafens11317253de_afens
deafer104114813de_afer
deafest112911513de_afest
deaired9411533deaired
deairs74013783de_airs
dealates92716683dealates
dealer74122143de_aler
dealers84118613de_alers
deals65435343de_a_ls
deaned84620453de_aned
deans66131393de_a_ns
dear55343603de_ar__
dearie73319813de_arie
dearly104615323de_arly
dearness939973de_arness
dearth104212513de_arth
dearths11498843de_arths
deary95826843de_ar_y
deashes113313903deashes
deaths105914443de_aths
deave95022333de_ave_
deaved114916553de_aved
debacles1335723debacles
debags104211063deba_gs
debar85517863debar__
debark134210943debar_k
debarked16175823debarked
debarker15155503debarker
debarkers16164553debarkers
debarred12165633debarred
debase94014473debase_
debased113310583debased
debaser103510413debaser
debasers11377903debasers
debate94419193debate_
debated113916083debated
debater104114693debater
debaters113511913debaters
debeards1235503debeards
debones103315113debones
debris93311493de_bris
debyes1238103de_byes
decade104216163decade_
decafs124010883deca_fs
decals93717713deca_ls
decamps1435643decamps
decane93818873decane_
decants103514443decants
decayed14309333decayed
decayer13339353decayer
decayers14307963decayers
decays124612913deca_ys
deceases11410153deceases
decerns10119053decerns
deciare10710663deciare_
decides114217653decides
deciles104417713deciles
deckers144413833decker_s
deckles143312803deckles
declare10411223declare_
declared1248743declared
declarer1148063declarer
declarers1236423declarers
decodes113914983decodes
decors94017773decor_s
decree93117783de_cree
decrees102513123decrees
decries103319803decries
decuries11312223decuries
decurves1435863decurves
dedans85915073deda_ns
deduces1168793deduces
deers64930523de_er_s
dees56356633de___es
deface123113863deface_
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defame123212433defame_
defamed14309833defamed
defamer132710323defamer
defamers14258523defamers
defangs1235363defangs
defats105114553defa_ts
defers105116943defer_s
defiers113913993defiers
defies104624053de_fies
defiles114016843defiles
defines114118683defines
deflates123013943deflates
deforces14248403deforces
deforest1238793deforest
deforms1337803deforms
defrags1236193defrags
defrays1436113defrays
defuses114814593defuses
defuzes20398303defuzes
degage92711383degage_
degame102713183degame_
degamis11268433degamis
degas75119163dega__s
degasses10278363degasses
degauss933923degauss
degerms1135623degerms
deglazes1935463deglazes
degrades11269923degrades
degree82814853de_gree
degrees92810723degrees
dehorns11428363dehorns
dehorts11379773dehorts
deicers103612733deicers
deices94119373de_ices
deifies113317453deifies
deities82621923deities
dekagram1643283dekagram
dekagrams1742823dekagrams
dekalitres1542963dekalitres
dekametres17133603dekametres
deke95228763dek__e_
deked115718533dek__ed
dekkos1034103dek_kos
delaines9312943delaines
delate73827753delate_
delated93722873delated
delayed123310763delayed
delayer113010533delayer
delayers12268663delayers
delays104014053dela_ys
deleaves1248063deleaves
deles65139253de__les
deletes83117933deletes
delimes10314193delimes
dellies83622213dellies
deludes91810643deludes
deluges9169263deluges
delvers113411993delvers
delves104917083de_lves
demands114311413demands
demarches1745913demarches
demark134211023demar_k
demarked16187223demarked
demasts1089223demasts
demerges12129503demerges
demes86032693de__mes
demies94825803de_mies
demirep1236213demirep
demireps1343993demireps
demises103719563demises
demoses103815823demoses
demotes104717673demotes
demure9311533demure_
demurer1037873demurer
demurest1137453demurest
demurs939773demur_s
denar65223293denar__
denari710917353denar_i
denarii8389123denarii
denarius948813denarius
denary105316863denar_y
denatures1038123denatures
denes65639723de__nes
dengues938183dengues
deniers84515183deniers
denies74729643de_nies
denotes83817003denotes
dentures9312453dentures
denudes91510043denudes
deodaras1044693deodaras
deodars937623deodar_s
depart94720563depar_t
departed1238823departed
departee1139723departee
departees1265723departees
deperms1236603deperms
deplanes11311203deplanes
deplores1139533deplores
depones103717093depones
deports105012883deports
deposes103117213deposes
depraves1436873depraves
depress10239863de_press
deputes104911783deputes
derails84216393derails
deranges1039973deranges
derate74531233derate_
derated93623503derated
derats74625063dera_ts
derays105514253dera_ys
derbies103016053derbies
dere56845903de__re_
derides93420853derides
derives114017813derives
derms85022893de__rms
derries83124623derries
derris73615273de_rris
desalts839573desalts
desands94810163desands
descries11311923descries
deserts82513053deserts
deserves12109893deserves
desexes1537833desexes
desire7415303desire_
desired9311983desired
desirer8310783desirer
desirers939263desirers
desorbs10437713desorbs
detaches1439653detaches
details84214043details
detains83716093detains
deterges101510083deterges
deters74724683deter_s
detoxes1538803detoxes
deuces94015513de_uces
devalues1235853devalues
devas96218883deva__s
deviates12312733deviates
devices133212583devices
devises114116763devises
devotes113713753devotes
dewans105215143dewa_ns
dewar95817733dewar__
dewater112912423dewater
dewaters122910713dewaters
dewaxed19316053dewaxed
deworms1338013deworms
dexes135224513de__xes
dexies145018343de_xies
diaries83321953d_iaries
diehards1346213diehards
dietaries10410653dietaries
dikers114418793diker_s
dikes105831333dik__es
dilates83220653dilates
dinars75417563dinar_s
disarms1039043disarms
dockages1635983dockages
donates83217223donates
dosages92310803dosages
dotages92311793dotages
dotards937253dotards
drakes114715863d_rakes
drapes95419653d_rapes
drearies92313413drearies
drears74614253drear_s
dryades12395633dryades
dukes105023473duk__es
dures65635923d__ures
dwarfs13436273d_warfs
dwarves1434463d_warves
dykes135215573dyk__es
eagres74014573_eagres
eared65139503_e_ared
earls56127513_e_arls
earns55927563_e_arns
ears46356593_e_ar_s
eases56041613_e_ases
eaves85231993_e_aves
ecartes94212563_ecartes
ekes86726603_ek__es
elates65032363_elates
enates64026423_enates
enures63919713_enures
erases64425403_erases
eskars10357593eskar_s
etapes85415293_etapes
evades1039023_evades
eyases94513683_eyases
eyres84921773_e_yres
fares85852873__fares
feared106320433fe_ared
fearer94820183fe_arer
fearers104815273fe_arers
fears84829393fe_ar_s
feases95422923fe_ases
feazes184514173fe_azes
females12310663females
feres86038183fe__res
feuars938653feuar_s
flares94521703_flares
geared85317743ge_ared
gears64628693ge_ar_s
gelates83219583gelates
genres75515623ge_nres
glares75518863_glares
hares86255543__hares
hearer94323643he_arer
hearers104319783he_arers
hears86737373he_ar_s
hearse94114273he_arse
hearses104414533he_arses
hearts96218943he_arts
heaves124120303he_aves
hectares1338853hectares
hegaris11310423hegaris
hektare1435503hektare_
heres86245903he__res
hexades18378703hexades
hexanes17319463hexanes
ideates8313723ide_ates
infares10313023infares
kaes85734063__ka_es
kales95730983__kales
kames115024693__kames
kanes95529373__kanes
karns96624143__karns
karts97630113__karts
kebars124112493kebar_s
lares54852633__lares
leakages1334933leakages
leakers113415423leakers
learns65513743le_arns
lears55938733le_ar_s
leases65428113le_ases
leaves94222383le_aves
legates82917673legates
lekvars1432693lekvar_s
lemures938793lemures
makars124612633makar_s
mares76457633__mares
menaces112715523menaces
menages103615393menages
meres75143573me__res
metages102714973metages
metates92720003metates
metres85121563me_tres
nares55544153__nares
neared75119803ne_ared
nearer64618893ne_arer
nearest73415843ne_arest
nears55529423ne_ar_s
negates83215833negates
oeuvres1032833oeuvres
pares77164483__pares
peaces106324083pe_aces
peages94321843pe_ages
pearls84715383pe_arls
pears75138613pe_ar_s
peases85229473pe_ases
pekans121710553peka_ns
pekes114623563pek__es
pekoes124410423pek_oes
pelages10714613pelages
penates93321593penates
peres76246643pe__res
pesades10310893pesades
petards104311153petards
pikakes1245823pikakes
prepares122014163prepares
rares55247443__rares
reales64934123re_ales
reared75930013re_ared
rearer64928913re_arer
rearers74323563re_arers
rearms85114653re_arms
rears54739653re_ar_s
reaves94127573re_aves
rebars84019823rebar_s
rebates95123173rebates
rebores95319163rebores
recanes93222263recanes
redates83423863redates
redwares1239053redwares
reearns749103reearns
refaces123216743refaces
refires104820313refires
regales83520793regales
regards94112563regards
rehires105016113rehires
relaces93420883relaces
relates73731423relates
relaxes143215323relaxes
remakes134116173remakes
remarks13329983remarks
remates93827103remates
renames92418053renames
reparks13249513reparks
repaves123513653repaves
resales74724903resales
retakes113718863retakes
retapes93917423retapes
retards85015003retards
retaxes143615093retaxes
retires74726213retires
reveres103621343reveres
rewakes144614983rewakes
rewards114813993rewards
rewarms12439593rewarms
rewaxes173911333rewaxes
rewires104717113rewires
scares85033003_scares
seared75232843se_ared
searer65432023se_arer
searest73322023se_arest
sears54744913se_ar_s
seawares1139333seawares
secures9613163secures
sedates83418033sedates
senates73322583senates
senores73218113senores
serapes95218103serapes
seres55448893se__res
sesames9310743sesames
sewages1139753sewages
sewars94018623sewar_s
shares95236413_shares
skates104219393_skates
skeanes113610713skeanes
snares65329033_snares
spares84834553_spares
squares163714453squares
stares66038753_stares
takahes1436173takahes
tares57456563__tares
teared75722153te_ared
tearer64822903te_arer
tearers75218233te_arers
tears55436463te_ar_s
teases65426273te_ases
teawares1148083teawares
tekkies1035943tekkies
tenaces92814513tenaces
tenures7412013tenures
texases1437573texases
uakaris1146633uakaris
ukases10358063_ukases
urares64519093_urares
velars93913723velar_s
velures1039093velures
venires103012453venires
wakames1635283wakames
wares88250583__wares
wearer94319403we_arer
wearers104615903we_arers
wearies103020223we_aries
wears86030303we_ar_s
weaves123616373we_aves
wekas123911793weka__s
welfares1445543welfares
wetwares1445953wetwares
yearns9509543ye_arns
years84527673ye_ar_s

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.1401276364.3
2DLD Change Limit1340275277.09318895.7
3Display Results5275270.1862833.3
 (SQL Overall)1786915277.41924085.6
 
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.