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 “heres” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

385 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
heres8624590(None) 
ceres75540011ceres
feres86038181feres
haeres94017031haeres
hares86255541hares
hebes105521671hebes
hemes105031081hemes
herbs105520501herbs
herds96424681herds
here76447101here_
heresy125011231heresy
herls85226431herls
herms105626431herms
herns84825581herns
heroes94923821heroes
heros84930861heros
herpes115517321herpes
hers75844871her_s
hexes155123041hexes
hires86134341hires
meres75143571meres
peres76246641peres
seres55448891seres
theres96525471theres
wheres125917431wheres
acres76327762acres
adheres11310162adheres
aedes64625142aedes
aeries64737782aeries
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
beers75628392beers
bees65453382be_es
benes75536232benes
beret74946362beret
berets85822522berets
bergs84718042bergs
berks115423122berks
bermes106023002bermes
berms95323662berms
beses75830722beses
bores76448252bores
brees75632552brees
byres104421382byres
cares77369182cares
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
cere66741472cere_
cered85227442cered
cereus85215522cereus
ceros74726072ceros
certes84623082certes
cetes75731102cetes
chares115631802chares
cheers114518912cheers
cherts115617232cherts
chevres15379792chevres
chores114828022chores
cires74932912cires
coheres122917692coheres
cores76361852cores
cures75645432cures
dares66146702dares
deers64930522deers
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dere56845902dere_
derms85022892derms
dexes135224512dexes
drees65628522drees
dures65635922dures
ekes86726602_ekes
emes65434662_emes
eras45441502_eras
ere36352772_ere_
ergs55523812_ergs
ernes55224812_ernes
erns45428222_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
erses55826802_erses
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
eyres84921772eyres
fares85852872fares
feces105625362feces
fees76450602fe_es
femes105626222femes
fere76342232fere_
ferns85220082ferns
fetes85630142fetes
fezes175220022fezes
fires85740752fires
fores85847102fores
frees86131392frees
freres94716172freres
gees55647882ge_es
genes65133092genes
genres75515622genres
germs85118872germs
ghees95215552ghe_es
gores65740372gores
grees65132472grees
gyres94820322gyres
hades96035112hades
haes77651022h_aes
hajes155420942hajes
hakes126034302hakes
hales85449842hales
hames106138702hames
hards96435652hards
hare76255732hare_
hared95742182hared
harem104924452harem
harems115513822harems
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
hates86742572hates
haves116034872haves
hazes174928322hazes
heads95127112heads
heals85733452heals
heaps105223222heaps
hearer94323642hearer
hearers104319782hearers
hears86737372hears
hearse94114272hearse
hearses104414532hearses
hearts96218942hearts
heats85838402heats
heaves124120302heaves
hebe96424702hebe_
hecks145220652hecks
heder95623632heder
heders104119762heders
hedges115016242hedges
heed86437602he_ed
heeds95420422heeds
heel75034222he_el
heels85625532heels
heezes184211642heezes
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heired103813042heired
heiress1036812heiress
heirs85618562heirs
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
helves124316062helves
heme95034412heme_
hemps126917332hemps
hems95534942he_ms
henges104516452henges
henries102718282henries
henrys12366102henrys
hens75642572he_ns
hents87330742hents
her66547812her__
herb94730962her_b
herbed123513452herbed
herby134715312herby
herd84933062her_d
herded114215642herded
herder104516462herder
herders113914122herders
hereat93527412hereat
hereby14468332hereby
heredes11313132heredes
herein93717792herein
hereof123212372hereof
hereon93914362hereon
hereto9313692hereto
herl75834552her_l
herm95636152her_m
herma105318882herma
hern76134892her_n
hero74635782her_o
heron85025502heron
herons94820542herons
herries104025072herries
herry114922472herry
hertz174919032hertz
hertzes1938292hertzes
hes66654202h__es
hests85829932hests
heths116317782heths
hets75547202he_ts
hewed125619432hewed
hewer115719932hewer
hewers123715272hewers
hews105631572he_ws
hexed165615762hexed
hexer155116682hexer
hexers165612752hexers
hides95129422hides
hies74842832h_ies
hikes125426982hikes
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirees95117292hirees
hirer85423122hirer
hirers94518062hirers
hives116925512hives
hoers85724922hoer_s
hoes75755732h_oes
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
horas86333092horas
hordes104921632hordes
horns86125332horns
horse86132652horse
horses94729342horses
hoses85443172hoses
howes114730262howes
hues75235232h_ues
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
hypes135818672hypes
inheres10315172inheres
ires45639282_ires
jeers124818132jeers
jees115938542je_es
jefes155613672jefes
jerks166514892jerks
jetes124922842jetes
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616122kermes
kernes104717522kernes
kerns94719562kerns
kexes166216812kexes
lares54852632lares
leers54828982leers
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
lores55045402lores
lures56138532lures
lyres85019962lyres
mares76457632mares
memes94927702memes
merces105720742merces
mercs96020452mercs
merdes94518602merdes
mere67244442mere_
merer75126232merer
merest84725112merest
merges94122482merges
merks114722402merks
merles85322762merles
merls77423902merls
metes74736212metes
metres85121562metres
mezes167719262mezes
mires75640882mires
mores76249642mores
mures75937212mures
nares55544152nares
nenes55329672nenes
nerds65719252nerds
nereis6315342nereis
nerts55924982nerts
nerves94216192nerves
neves87021872neves
ogres65818632ogres
ores46056682_ores
pares77164482pares
pedes85327282pedes
peers75130272peers
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
pere66450262pere_
perea75026442perea
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pores75849032pores
prees75937172prees
pyres105523882pyres
rares55247442rares
redes65139122redes
rees45364192re_es
reges65628782reges
res35565042__res
rexes124526952rexes
rhemes115913182rhemes
seers55136382seers
sees45361052se_es
semes75731582semes
sere46153472sere_
sered65737292sered
serer55935502serer
serest64831612serest
serfs84922012serfs
serges74225962serges
series64540972series
sers45746652ser_s
serves94423652serves
sexes126126222sexes
shares95236412shares
sheers94322402sheers
sherds105614722sherds
shires95225572shires
shores94830402shores
sires55945372sires
sores55454282sores
spheres123114352spheres
steres63929532steres
tares57456562tares
tees45353582te_es
teles54536002teles
terces83921412terces
terms75523472terms
ternes65422902ternes
terns55226872terns
terse55026822terse
thebes115914492thebes
themes115319252themes
there87527392there_
thermes126214612thermes
therms115914872therms
theses96517972theses
threes97117322threes
tires55437492tires
tores55352672tores
trees55835762trees
tres46542902_tres
tyres84725232tyres
veers84521362veers
vees75439432ve_es
veges94118862veges
verbs104614392verbs
verges104320172verges
vermes115019142vermes
verse84723582verse
verses94223762verses
verts85724732verts
verves124617882verves
vexes155719122vexes
vires84529682vires
wares88250582wares
wees76249122we_es
were76238332were_
where117019422where_
whereas13448902whereas
wherves16548052wherves
whores125617102whores
wires86034912wires
xerus12313332xerus
yerks125416562yerks
yeses85119322yeses
yores85031322yores
zees136331892ze_es
zerks185113822zerks
zeroes154314342zeroes
zeros144918102zeros

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit538003852.23324093.1
3Display Results3853850.2361631.4
 (SQL Overall)1786913852.56269746.7
 
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.