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

438 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
hermit1151944(None) 
hermits12312141hermits
permit10321681permit
thermit12312011thermit
cermet10321152cermet
demit84832302de_mit
dermic114511912dermic
dermis94717162dermis
emit65438422_e_mit
fermi103914162fermi_
fermis114313502fermis
harmin113117392harmin
helmet113718932helmet
hemic125718622he_mic
hemin103620932he_min
henbit111412002henbit
herdic123112302herdic
hereat93527412hereat
herein93717792herein
heriot9422342heriot
herm95636152herm__
herma105318882herm_a
hermae115314472hermae
hermai118912862hermai
hermitic1539652hermitic
hermitry1644452hermitry
herms105626432herm_s
hernia9312292hernia
heroic113516922heroic
heroin94420592heroin
kermis124012392kermis
merit7339182mer_it
permits11314002permits
reemit8717222reemit
remit75737222re_mit
termite9313892termite
territ63421372territ
thermic1439332thermic
thermite1339032thermite
thermits1338512thermits
vermin113414522vermin
vermis114214962vermis
admit8319493_admit
adroit7518793adroit
aerie54634603aer_ie
afrit8323173afr_it
armet76739453_armet
armpit10811093_armpit
barmie103816393barmie
bedsit9312843bedsit
befit105222663be_fit
bemist105216953be_mist
bemix165011453be_mix
bemixt174510363be_mixt
bereft114317303bereft
beret74946363ber_et
berime105317333berime
berlin83116373berlin
berm86732753berm__
berme96022943berm_e
bermed115217723bermed
bermes106023003bermes
berming123614833berming
berms95323663berm_s
besmut10310653besmut
bevomit1445353bevomit
brit66350153_br_it
bruit76126723_bruit
ceramic1339823ceramic
ceramist12310933ceramist
cerci93716393cerci_
cercis104614493cercis
ceria75125353cer_ia
ceric94023093cer_ic
cerite84724873cer_ite
cermets1139713cermets
cervid1239323cervid
cervix1865163cervix
chemic153012093che_mic
chemist143615003che_mist
cheroot12413693cheroot
chert105232103cher__t
chervil1534953chervil
commit124016703commit
credit9315193credit
crit65743713_cr_it
dammit11311133dammit
debit85727853de_bit
deceit93018213deceit
delimit10311733delimit
demic105119193de_mic
demits94918073de_mits
deorbit1048173deorbit
derail74218813derail
derat65044083der_at
derm76031893derm__
derma84918513derm_a
dermal93614343dermal
dermas94116813dermas
dermoid1138523dermoid
derms85022893derm_s
derris73615273derris
desmid1048363desmid
dharmic1535013dharmic
dormie9312623dormie
dormin9312313dormin
droit65127123_droit
edit54934863_e_dit
eerie55228533eer_ie
emic86422753_e_mic
emir65918703_e_mir
emits75421473_e_mits
emmet94221383_emmet
enmity1137483_enmity
erect74129333_erect
eremite9312833_eremite
ergot65422893_ergot
ermine8416923_ermine
erst47436433_er_st
eruct74022353_eruct
erupt74220063_erupt
ervil8310303_ervil
exit114428673_e_xit
feria85922713fer_ia
ferity122813343fer_ity
ferlie92814053ferlie
fermata12278143fermata
fermate122813003fermate
ferment12315573ferment
fermion1236763fermion
fermium1446353fermium
ferret93021173ferret
ferric1139993ferric
ferrite103312753ferrite
fervid1337513fervid
format113021353format
formic13310453formic
forrit91916623forrit
frit77044473_fr_it
fruit85122223_fruit
furmity1535183furmity
gemot84024233ge_mot
gerbil938343gerbil
gerent73223093gerent
germ75428963germ__
german9611983german
germen9612313germen
germier10309543germier
germiest11249913germiest
germina1038493germina
germs85118873germ_s
germy115113663germ_y
gherkin1544043gherkin
grit55247243_gr_it
habit103027023h_abit
haemic133210083haemic
haemin113412663haemin
haffit1538533haffit
harlot94422803harlot
harm95637793harm__
harmed125218833harmed
harmer114719553harmer
harmine122816193harmine
harming133717933harming
harmins123716723harmins
harms106829013harm_s
harpin113614383harpin
harpist12312353harpist
hart76865773har__t
hazmat20312263hazmat
heart85440743he_art
heat77061423he__at
hectic132311523hectic
heft106736293he__ft
height134713433height
heil76328933he__il
heimish1535463heimish
heinie92512663heinie
heir77523803he__ir
heist87030913he_ist
helio85321193he_lio
helix154413013he_lix
helm95530023helm__
helmed124513693helmed
helmets12309073helmets
helming133712003helming
helminth1644943helminth
helms105619463helm_s
helot85332683he_lot
hem86148733he_m__
hemal104419803he_mal
heme95034413he_m_e
hemes105031083he_mes
hemins113417563he_mins
hemmed144211463hemmed
hemmer134112643hemmer
hemming15269973hemming
hemoid12313513hemoid
hemp115725623he_m_p
hempie132410563hempie
hemps126917333he_mps
hempy154912763he_mpy
hems95534943he_m_s
henbits12177003henbits
hent76656383he__nt
hepcat13611823hepcat
her66547813her___
herald10311343herald
herb94730963her__b
herbal112513493herbal
herbed123513453herbed
herbier1239593herbier
herbiest1339993herbiest
herbs105520503her_bs
herby134715313her_by
herd84933063her__d
herded114215643herded
herder104516463herder
herdics13249523herdics
herding122915123herding
herdman13238423herdman
herdmen13238453herdmen
herds96424683her_ds
here76447103her__e
hereby14468333hereby
heredity1546493heredity
hereinto1145433hereinto
hereof123212373hereof
hereon93914363hereon
heres86245903her_es
heresy125011233heresy
heretic12314833heretic
hereto9313693hereto
herewith1755193herewith
heriots10312063heriots
heritor10310563her_itor
herl75834553her__l
herls85226433her_ls
hermetic15310243hermetic
hermetist1448953hermetist
hermitage1543863hermitage
hermitism1646143hermitism
hern76134893her__n
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
herniate1148113herniate
herns84825583her_ns
hero74635783her__o
heroes94923823heroes
heroics122912003heroics
heroine103517483heroine
heroins103518013heroins
heroism12311013heroism
heroize193210963heroize
heron85025503her_on
herons94820543herons
heros84930863her_os
herpes115517323herpes
herried113514453herried
herries104025073herries
herring113615883herring
herry114922473her_ry
hers75844873her__s
hertz174919043her_tz
hessite1038993hessite
hest75950773he__st
het67674313he___t
hetman112510603hetman
hit66569193h___it
hobbit132810543hobbit
holmic1338783holmic
homie104622533h_omie
hornet94926433hornet
hornist102314823hornist
hornito1047073hornito
horrid10311563horrid
horst85833513hor_st
humic124113243h_umic
humid114213763h_umid
hurst85527193hur_st
hurt77142573hur__t
inherit10312973inher_it
intermit101213593intermit
jerid132316423jer_id
jerkin17258113jerkin
jerrid14259143jerrid
jesuit1339583jesuit
karmic1438113karmic
kempt134318463ke_mpt
keramic1537233keramic
kermes124616123kermes
kernite1159473kernite
kerria10339913kerria
krait94726773_krait
legit61323503le_git
limit73126343_limit
marmite112413993marmite
marmot10318743marmot
merest84725113merest
merits8320873mer_its
merlin83916683merlin
merlot83217603merlot
mermaid1297853mermaid
merman10513863merman
mermen10813813mermen
nereid7312923nereid
nereis6315343nereis
neumic1036853neumic
omit65337373__omit
orbit73622063_orbit
overfit132610963overfit
overlit102714743overlit
overmix1935573overmix
peewit111110903peewit
pelmet103419243pelmet
perdie94718513perdie
pereia85217983pereia
peri65636973per_i_
peril75425953per_il
peris75537073per_is
periti8319953per_iti
perlite9317313perlite
perm85834633perm__
permed115217343permed
permian112612283permian
perming123416093perming
perms95524513perm_s
permute1138793permute
pernio8513143pernio
persist9315853persist
pert66759323per__t
petit74332653pe_tit
pewit104622793pe_wit
premie103617993premie
premix173710333premix
premixt183510663premixt
readmit1039823readmit
rebait8320403rebait
recit75235103re_cit
recruit939773recruit
reedit7617223reedit
reemits9611303reemits
refit84230063re_fit
reknit10312533reknit
relit55340683re_lit
remet74843723re_met
remint85329973re_mint
remits85622943re_mits
remix145916553re_mix
remixt155014853re_mixt
rerent63832453rerent
rerig64018483rer_ig
resit54241043re_sit
rheumic1443543rheumic
semi65127223se_mi_
semis74623533se_mis
sennit63117923sennit
serai56830163serai_
serail64222673serail
serais64326133serais
serein63318463serein
serest64831613serest
serif84132133ser_if
serin55434443ser_in
sermon8413553sermon
sherbet12311383sherbet
sherif122915243sher_if
sheroot10414373sheroot
sherris10168803sherris
smit65138413__smit
spermic1338523spermic
sprit76736403spr_it
strait64025893strait
submit10312673submit
summit10311543summit
tempt95124843te_mpt
terai53525483terai_
terais64023513terais
terbia8311153terbia
terbic10410963terbic
tercet83624913tercet
tergite8311003tergite
term66233153term__
termed94816703termed
termer85717253termer
terming104016003terming
termini93410813termini
termites10313693termites
termitic1249283termitic
termly1138433termly
termor84412513termor
terms75523473term_s
terret63425623terret
territs72714503territs
thereat104315243thereat
therein102310353therein
theremin13107283theremin
therm106018023therm__
thermae125310503thermae
thermal125010973thermal
therme115814993therm_e
thermel12569893thermel
thermes126214613thermes
thermion1345933thermion
thermites1438043thermites
thermos124610753thermos
therms115914873therm_s
theroid11313403theroid
trait56940843_trait
turbit8715113turbit
uremia82910893uremia
uremic103410513uremic
varmint12311683varmint
verbid122311313verbid
verdict1339583verdict
verdin103113023verdin
verist93823893verist
verite94323443ver_ite
verity123714853ver_ity
vermeil1285223vermeil
vermes115019143vermes
vermian12329713vermian
vermuth1543533vermuth
vernix1636633vernix
verset94327323verset
verst84429373ver_st
vert77249373ver__t
vervet124619063vervet
vomit102622573_vomit
wert79749823wer__t
weskit1338343weskit
whereat134311923whereat
wherein13216593wherein
wormil1138043wormil
worrit92313313worrit
writ75537913_wr_it
xeric144315663xer_ic

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.1231452772.4
2DLD Change Limit1127164385.73619650.6
3Display Results4384380.1403128.6
 (SQL Overall)1786914385.99929786.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.