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

296 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
hermai11891286(None) 
herma105318881herma_
hermae115314471hermae
derma84918512derma_
dermal93614342dermal
dermas94116812dermas
fermi103914162ferm_i
german9611982german
hemal104419802he_mal
herbal112513492herbal
herdman13238422herdman
hereat93527412hereat
herm95636152herm__
hermit11519442hermit
herms105626432herm_s
hernia9312292hernia
hetman112510602hetman
mermaid1297852mermaid
merman10513862merman
serai56830162ser_ai
terai53525482ter_ai
thermae125310502thermae
thermal125010972thermal
aerial64625713aerial
airmail946213airmail
airman82414223airman
barmaid1238203barmaid
barman103519703barman
bema85825253be_ma_
bemas96424283be_mas
berm86732753berm__
berme96022943berm_e
bermed115217723bermed
bermes106023003bermes
berms95323663berm_s
carman103920743carman
centai84814783centai
ceramal1138843ceramal
ceramic1339823ceramic
cercal10314123cercal
cerci93716393cer_ci
cereal8315833cereal
ceria75125353ceria_
cerias83321983cerias
cermet10321153cermet
certain92612213certain
charpai1436633charpai
degami10279013degami
derail74218813der_ail
derat65044083der_at
deray95024183der_ay
derm76031893derm__
dermic114511913dermic
dermis94717163dermis
dermoid1138523dermoid
derms85022893derm_s
desman9311693desman
dharma1276103dharma_
dharmas1356513dharmas
email74715103_e_mail
era35741503_er_a_
eras45441503_er_as
feral85424653fer_al
ferbam1339003ferbam
feria85922713feria_
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
fermata12278143fermata
fermate122813003fermate
fermis114313503fermis
firman112211343firman
formal113215203formal
format113021353format
gardai839663gardai
gemma106311773gemma_
gemmae11507793gemmae
gerah9315303ger_ah
germ75428963germ__
germane1049663germane
germanic1367503germanic
germans1079473germans
germen9612313germen
germs85118873germ_s
germy115113663germ_y
gherao1036753gher_ao
haemal113811643haemal
halma108219253halma_
halmas117017893halmas
hamal104623113h_amal
hammal134512063hammal
hammam12419333hammam
harm95637793harm__
harmed125218833harmed
harmer114719553harmer
harmin113117393harmin
harms106829013harm_s
hartal9415473hartal
hazmat20312263hazmat
head87137173he__ad
headman13229633headman
heal75645693he__al
heap96432893he__ap
hear76143883he__ar
hearsay1335523hearsay
heat77061423he__at
heehaw1543933heehaw
hegari1039523hegari
heishi1235843heishi
heliac111010893heliac
helm95530023helm__
helmed124513693helmed
helmet113718933helmet
helms105619463helm_s
hem86148733he_m__
hematic141816743he_matic
hematin121516023he_matin
heme95034413he_m_e
hemes105031083he_mes
hemic125718623he_mic
hemin103620933he_min
hemmed144211463hemmed
hemmer134112643hemmer
hemoid12313513he_moid
hemp115725623he_m_p
hempie132410563he_mpie
hemps126917333he_mps
hempy154912763he_mpy
hems95534943he_m_s
henna84414043henna_
hennas94211803hennas
hepcat13611823hepcat
heptad1237273heptad
her66547813her___
herald10311343herald
herb94730963her__b
herbage1337003herbage
herbals122710603herbals
herbaria1346093herbaria
herbed123513453herbed
herbs105520503her_bs
herby134715313her_by
herd84933063her__d
herded114215643herded
herder104516463herder
herdic123112303herdic
herdmen13238453herdmen
herds96424683her_ds
herdsman1465643herdsman
here76447103her__e
hereby14468333hereby
herein93717793herein
hereof123212373hereof
hereon93914363hereon
heres86245903her_es
heresy125011233heresy
heretic12314833heretic
hereto9313693hereto
heriot9422343heriot
herl75834553her__l
herls85226433her_ls
hermaean1343603hermaean
hermetic15310243hermetic
hermitic1539653hermitic
hermits12312143hermits
hern76134893her__n
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
herns84825583her_ns
hero74635783her__o
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heron85025503her_on
herons94820543herons
heros84930863her_os
herpes115517323herpes
herry114922473her_ry
hers75844873her__s
hertz174919043her_tz
hetmans12187593hetmans
hexad164910623he_xad
heyday1635143heyday
hiemal11339503hiemal
hitman112710223hitman
hora76136563hor_a_
horah117922053hor_ah
horal86328683hor_al
horas86333103hor_as
human102716033h_uman
hurrah12369183hurrah
hurray12459913hurray
hyrax1838033hyr_ax
karma113415003karma_
karmas123013733karmas
keramic1537233keramic
kermes124616123kermes
kermis124012393kermis
kerria10339913kerria
korai97018523kor_ai
korma115913073korma_
kormas124511233kormas
legman949653legman
leman75622603le_man
lemma94811033lemma_
lemmas10349163lemmas
mermaids1355753mermaids
mermen10813813mermen
nema65522523ne_ma_
nemas75321573ne_mas
neroli61111153neroli
normal83213533normal
overman12311463overman
pearmain1245833pearmain
penman10312323penman
perea75026443perea_
pereia85217983pereia
peri65636973per__i
periti8319953periti
perm85834633perm__
permed115217343permed
permian112612283permian
permit10321683permit
perms95524513perm_s
pertain92714963pertain
petsai838083petsai
preman104117453preman
rai37658223__r_ai
rami66034093__rami
regma84612333regma_
remail85017123re_mail
remain85919863re_main
reman75730153re_man
remap95418103re_map
reran57329103rer_an
reread71715433reread
seaman84015903seaman
semi65127223se_m_i
sera46141393ser_a_
serac75925203ser_ac
serail64222673ser_ail
serais64326133ser_ais
seral56336383ser_al
serdab937833serdab
serial64625863serial
sermon8413553sermon
serumal938783serumal
serval93913413serval
sherpa1138093sherpa_
sherpas1238093sherpas
tarmac10310333tarmac
tempi94912203te_mpi
terais64023513ter_ais
terbia8311153terbia
terga63315643terga_
tergal72912833tergal
term66233153term__
termed94816703termed
termer85717253termer
termini93410813termini
termly1138433termly
termor84412513termor
terms75523473term_s
terra54419663terra_
terrae62915213terrae
terrain7410853terrain
terras63516973terras
thereat104315243thereat
theriac1239143theriac
therian10311293therian
therm106018023therm__
thermals13518533thermals
therme115814993therm_e
thermel12569893thermel
thermes126214613thermes
thermic1439333thermic
thermit12312013thermit
thermos124610753thermos
therms115914873therm_s
uremia82910893uremia
vera76828843ver_a_
verbal112513663verbal
vermeil1285223vermeil
vermes115019143vermes
vermian12329713vermian
vermin113414523vermin
vermis114214963vermis
vernal93514213vernal
versal93013753versal
vervain1335563vervain
whereas13448903whereas
whereat134311923whereat
yeoman1138823yeoman
yerba101010763yerba_
yerbas11119293yerbas

Search took 6 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 Limit1127162964.87623116.5
3Display Results2962960.0933182.8
 (SQL Overall)1786912965.10934975.7
 
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.