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

453 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
hermae11531447(None) 
herma105318881herma_
hermai118912861hermai
thermae125310501thermae
berme96022942berm_e
derma84918512derma_
dermal93614342dermal
dermas94116812dermas
feriae95618602feriae
fermate122813002fermate
gemmae11507792gemmae
german9611982german
germane1049662germane
hemal104419802he_mal
heme95034412he_m_e
herbage1337012herbage
herbal112513492herbal
herdman13238422herdman
here76447102her__e
hereat93527412hereat
herm95636152herm__
hermaean1343602hermaean
hermit11519442hermit
herms105626432herm_s
herniae1039042herniae
hetman112510602hetman
merman10513862merman
terrae62915212terrae
thermal125010972thermal
therme115814992therm_e
aerate64830553aerate
aerial64625713aerial
aerie54634603aer_ie
aerobe8412403aerobe
airman82414223airman
aortae65115473aortae
arame75026623_arame
areae55229743_areae
aurae54128113aur_ae
barman103519703barman
barmie103816393barmie
became123213163became
bedmate1239433bedmate
bema85825253be_ma_
bemas96424283be_mas
bename103316073bename
berake124216083berake
berate84729023berate
bereave1258353bereave
berime105317333berime
berm86732753berm__
bermed115217723bermed
bermes106023003bermes
berms95323663berm_s
brae65639113_br_ae
bursae84515603bursae
carman103920743carman
cellae84915933cellae
ceramal1138843ceramal
cerate84829463cerate
cercal10314123cercal
cere66741473cer__e
cereal8315833cereal
ceria75125363ceria_
cerias83321983cerias
cerise84822043cerise
cerite84724873cerite
cermet10321153cermet
ceruse83914523ceruse
chelae113614613che_lae
comae97128423_comae
cremate113816183cremate
creme94319323crem_e
curiae84518373curiae
cymae126713013_cymae
defame123212433defame
degame102713183degame
deme76536283de_m_e
derat65044083der_at
derate74531233derate
deray95024183der_ay
dere56845903der__e
deride84420033deride
derive103817043derive
derm76031893derm__
dermic114511913dermic
dermis94717163dermis
derms85022893derm_s
desman9311693desman
dharma1276103dharma_
dharmas1356513dharmas
dormie9312623dormie
eerie55228533eer_ie
eme55837183_e_m_e
era35741503_er_a_
eras45441503_er_as
erase54925493_erase
ere36352773_er__e
ergate7315143_ergate
ermine8416923_ermine
erne46727433_er_ne
erode64520993_erode
erose55727283_erose
female11310553fe_male
feme96130543fe_m_e
femme125011433fe_mme
feral85424653fer_al
ferbam1339003ferbam
fere76342233fer__e
feria85922713feria_
ferial94621253ferial
ferias95020393ferias
ferine96422583ferine
ferlie92814053ferlie
fermata12278143fermata
fermi103914163ferm_i
fermis114313503fermis
ferrate103014043ferrate
ferulae10309603ferulae
ferule93413203ferule
firman112211343firman
formal113215203formal
format113021353format
formate123115093formate
forme105225993form_e
formee113919943formee
frae75330473_fr_ae
frame105821803_frame
gemma106311773gemma_
gemmate12418383gemmate
gerah9315303ger_ah
germ75428963germ__
germans1079473germans
germen9612313germen
germier10309543germier
germs85118873germ_s
germy115113663germ_y
gherao1036753gher_ao
hae67364003h___ae
haemal113811643haemal
halma108219253halma_
halmas117017893halmas
hamal104623113h_amal
hamate113319833h_amate
hame97043133h_am_e
hammal134512063hammal
hammam12419333hammam
hare76255733har__e
harm95637793harm__
harmed125218833harmed
harmer114719553harmer
harmin113117393harmin
harmine122816193harmine
harms106829013harm_s
hartal9415473hartal
hazmat20312263hazmat
head87137173he__ad
headman13229633headman
heal75645693he__al
heap96432893he__ap
hear76143883he__ar
hearsay1335523hearsay
hearse94114283hearse
heat77061423he__at
heaume1137543heaume
heave114521813he_ave
hebe96424703he__be
heckle153112093heckle
hectare1238473hectare
heddle114211163heddle
hedge105317353he_dge
heehaw1543953heehaw
heeze175313483he_eze
heinie92512663heinie
hektare1435513hektare
heliac111010893heliac
helm95530023helm__
helmed124513693helmed
helmet113718933helmet
helms105619463helm_s
helpmate1545603helpmate
helve115018093he_lve
hem86148733he_m__
hemes105031083he_mes
hemic125718623he_mic
hemin103620933he_min
hemmed144211463hemmed
hemmer134112643hemmer
hemp115725623he_m_p
hempen1338963he_mpen
hempie132410563hempie
hemps126917333he_mps
hempy154912763he_mpy
hems95534943he_m_s
henbane1237363henbane
hence104920053he_nce
henge94819833he_nge
henna84414043henna_
hennaed1135103hennaed
hennas94211803hennas
hepcat13611823hepcat
heptad1237273heptad
heptane1238363heptane
her66547813her___
herald10311343herald
herb94730963her__b
herbaged1554533herbaged
herbages1437103herbages
herbals122710613herbals
herbed123513453herbed
herbier1239593herbier
herbs105520503her_bs
herby134715313her_by
herd84933063her__d
herded114215643herded
herder104516463herder
herdic123112303herdic
herdmen13238453herdmen
herds96424683her_ds
herdsman1465643herdsman
hereby14468333hereby
heredes11313133heredes
herein93717793herein
hereof123212373hereof
hereon93914363hereon
heres86245903her_es
heresy125011233heresy
hereto9313693hereto
heriot9422343heriot
heritage1246533heritage
herl75834553her__l
herls85226433her_ls
hermitage1543863hermitage
hermits12312143hermits
hern76134893her__n
hernia9312293hernia
hernial10310433hernial
hernias10310773hernias
herniate1148113herniate
herns84825583her_ns
hero74635783her__o
heroes94923833heroes
heroic113516923heroic
heroin94420593heroin
heroine103517493heroine
heroize193210973heroize
heron85025503her_on
herons94820543herons
heros84930863her_os
herpes115517323herpes
herried113514473herried
herries104025083herries
herry114922473her_ry
hers75844873her__s
hertz174919043her_tz
hertzes1938303hertzes
hetmans12187593hetmans
hexad164910623he_xad
hexade17438903hexade
hexane16379533hexane
hexone16289233hexone
hexose16267843hexose
heyday1635143heyday
hiemal11339513hiemal
hire75538963hir__e
hiree85427803hir_ee
hirple11158973hirple
hirsle9159573hirsle
hitman112710223hitman
hogmane1336343hogmane
homage121210603h_omage
home98042443h_om_e
homie104622533h_omie
hora76136563hor_a_
horah117922053hor_ah
horal86328683hor_al
horas86333103hor_as
horde94623053hor_de
hormone12410503hormone
horse86132653hor_se
horste94817413horste
human102716033h_uman
humane112812173h_umane
humate113214443h_umate
hurdle103712793hurdle
hurrah12369183hurrah
hurray12459913hurray
hurtle93512943hurtle
hydrae13258573hydrae
hydriae14246903hydriae
hyphae1746433hyphae
hyrax1838033hyr_ax
karma113415003karma_
karmas123013733karmas
kermes124616133kermes
kermis124012393kermis
kerne94718223ker_ne
korma115913073korma_
kormas124511233kormas
larvae938843larvae
legman949653legman
leman75622603le_man
lemma94811033lemma_
lemmas10349163lemmas
mae57659113___mae
mammae94613213mammae
mediae94217413mediae
meme85330553me_m_e
mensae84114053mensae
merde84320123mer_de
mere67244443mer__e
merge84523693mer_ge
mergee94018143mergee
merle75824373mer_le
mermaid1297853mermaid
mermen10813813mermen
morae75831193mor_ae
nema65522523ne_ma_
nemas75321573ne_mas
nervate1039533nervate
nerve86617373ner_ve
neume74414403neum_e
normal83213533normal
ocreae83310273ocreae
overman12311463overman
parae76335703par_ae
penman10312323penman
pennae84314033pennae
percale11314093percale
perdie94718513perdie
perdue93912633perdue
pere66450263per__e
perea75026443perea_
perm85834633perm__
permease1246503permease
permeate12311613permeate
permed115217353permed
permian112612283permian
permit10321683permit
perms95524513perm_s
permute1138793permute
perse75429523per_se
peruke123210393peruke
peruse84016843peruse
pervade1337023pervade
premade12311443premade
preman104117453preman
premie103617993premie
rediae74221993rediae
reframe1239393reframe
reggae858953reggae
regma84612333regma_
reimage1037913reimage
remade94316983re_made
remake124016113re_make
reman75730153re_man
remap95418103re_map
remate84428683re_mate
rename82718813rename
reran57329103rer_an
reread71715433reread
rerise64325633rerise
rerose63320853rerose
rheme106214053rhe_m_e
seaman84015903seaman
seme65836653se_m_e
sera46141393ser_a_
serac75925203ser_ac
serai56830163ser_ai
seral56336383ser_al
serape84818413serape
serdab937833serdab
sere46153473ser__e
serene63522353serene
serfage1138403serfage
serge64727473ser_ge
serial64625863serial
seriate73722473seriate
serine65432673serine
sermon8413553sermon
serosae7310253serosae
serrate73017543serrate
serumal938783serumal
serval93913413serval
serve85425963ser_ve
sesame8311013sesame
setae56026223se_tae
sherpa1138093sherpa_
sherpas1238093sherpas
striae65422273striae
strumae9368093strumae
summae103911013summae
tarmac10310333tarmac
telae54323293te_lae
teniae64517353teniae
terai53525483ter_ai
terce75721843ter_ce
terete6319333terete
terga63315643terga_
tergal72912833tergal
term66233153term__
termed94816703termed
termer85717253termer
termite9313893termite
termly1138433termly
termor84412513termor
terms75523473term_s
ternate7415483ternate
terne56426153ter_ne
terra54419673terra_
terrace93311843terrace
terrane72814233terrane
terras63516973terras
terse55026823ter_se
testae64216253testae
thecae11299653the_cae
theme105921733the_m_e
there87527393ther__e
thereat104315243thereat
theriac1239143theriac
therian10311293therian
therm106018023therm__
thermals13518533thermals
thermel12569893thermel
thermes126214613thermes
thermic1439333thermic
thermit12312013thermit
thermite1339033thermite
thermos124610753thermos
therms115914873therm_s
ursae55214453_ursae
venae85920983ve_nae
vera76828843ver_a_
verbal112513663verbal
verge93419843ver_ge
verite94323443verite
vermes115019143vermes
vermian12329713vermian
vermin113414523vermin
vermis114214963vermis
vernal93514213vernal
versal93013753versal
verse84723583ver_se
verste94515633verste
verve115417723ver_ve
were76238333wer__e
where117019433wher__e
whereas13448903whereas
whereat134311923whereat
wherve15568123wher_ve
yeoman1138823yeoman
yerba101010763yerba_
yerbas11119293yerbas

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.436409841.7
2DLD Change Limit1127164536.14018357.7
3Display Results4534530.1403235.7
 (SQL Overall)1786914536.71626606.8
 
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.