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

406 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
hermits1231214(None) 
hermit11519441hermit_
permits11314001permits
thermits1338511thermits
cermets1139712cermets
demits94918072de_mits
dermis94717162dermi_s
emits75421472_e_mits
fermis114313502fermi_s
harmins123716722harmins
helmets12309072helmets
hemins113417572he_mins
henbits12177002henbits
herdics13249522herdics
heriots10312062heriots
hermitic1539652hermitic
hermitism1646142hermitism
hermitry1644452hermitry
herms105626432herm__s
hernias10310772hernias
heroics122912002heroics
heroins103518012heroins
herries104025082herries
kermis124012392kermi_s
merits8320872mer_its
permit10321682permit_
reemits9611302reemits
remits85622942re_mits
termite9313892termite
termites10313692termites
territs72714502territs
thermit12312012thermit_
thermite1339032thermite
thermites1438042thermites
vermis114214962vermi_s
admits9411413_admits
aeries64737783aer_ies
afrits9311903afr_its
armets84918353_armets
armies85123693_armies
armpits1157133_armpits
bedsits1037563bedsits
befits114711503be_fits
bemist105216963be_mist
bemists113410703be_mists
berets85822523ber_ets
berimes115216643berimes
berlins93216013berlins
bermes106023003berm_es
berming123614833berming
berms95323663berm__s
berries94423553berries
besmuts1134683besmuts
bevomits1543463bevomits
brits76433083_br_its
bruits85714453_bruits
ceramics1446803ceramics
ceramist12310933ceramist
ceramists1346723ceramists
cercis104614493cerci_s
cerias83321983cer_ias
cerite84724873cer_ite
cerites94823433cer_ites
cermet10321153cermet_
chemics16349583che_mics
chemist143615003che_mist
chemists152710323che_mists
cheroots1348193cheroots
cherries131812993cherries
cherts115617233cher__ts
chervils1644553chervils
commits133812383commits
credits1039973credits
crits75527573_cr_its
debits94214503de_bits
deceits102810883deceits
delimits1137573delimits
demies94825803de_mies
demit84832303de_mit_
deorbits1144613deorbits
derails84216393derails
derats74625063der_ats
derbies103016053derbies
dermas94116813derm_as
dermic114511913dermi_c
dermises112512023dermises
dermoids1246163dermoids
derms85022893derm__s
derries83124623derries
derris73615273derri_s
desmids1166603desmids
dormins10311273dormins
droits74314313_droits
edits65819033_e_dits
emirs76116163_e_mirs
emit65438423_e_mit_
emmets10349153_emmets
enmity1137483_enmity
erects84116183_erects
eremite9312833_eremite
eremites10312603_eremites
ergots74512373_ergots
ermine8416923_ermine
ermines9416673_ermines
eructs83610793_eructs
erupts8348903_erupts
ervils948773_ervils
exits125515913_e_xits
ferias95020393fer_ias
ferity122813343fer_ity
ferlies103216693ferlies
fermata12278143fermata
fermatas13246223fermatas
fermate122813003fermate
ferments13311473ferments
fermi103914163fermi__
fermion1236763fermion
fermions1336203fermions
fermium1446353fermium
fermiums1544353fermiums
ferrets103111393ferrets
ferries103521083ferries
ferrite103312753ferrite
ferrites112312833ferrites
formats123113573formats
fremitus1344023fremitus
frits86129103_fr_its
fruits94512493_fruits
furmity1535193furmity
gemots93712153ge_mots
gerbils1037303gerbils
gerents82612923gerents
germans1079473germans
germens1078633germens
germier10309543germier
germiest11249923germiest
germina1038503germina
germs85118873germ__s
gherkins1643993gherkins
grits65529583_gr_its
habits113014653h_abits
haemins122811403haemins
haffits1636193haffits
hardies114923233hardies
harlots103413293harlots
harmers124116593harmers
harmin113117393harmi_n
harmine122816193harmine
harmines132715153harmines
harming133717933harming
harms106829013harm__s
harpies123818323harpies
harpins123615703harpins
harpist12312363harpist
harpists1338103harpists
harries103525503harries
harts88441593har__ts
hazmats2136603hazmats
hearties11315423hearties
hearts96218943he_arts
heats85838403he__ats
heavies132713873heavies
hefts116218153he__fts
heights14399443heights
heils85222193he__ils
heimish1535463heimish
heinies102514543heinies
heirs85618563he__irs
heist87030913he__ist
heists96814633he_ists
helios94816633he_lios
helmet113718933helmet_
helming133712003helming
helminth1644943helminth
helminths1742773helminths
helms105619463helm__s
helots95217703he_lots
hemes105031083he_m_es
hemic125718623he_mi_c
hemin103620933he_mi_n
hemmers143310843hemmers
hemming15269973hemming
hemps126917333he_m_ps
hems95534943he_m__s
henbit111412003henbit_
henries102718283henries
hents87330743he__nts
hepcats1436473hepcats
heralds1137713heralds
herbals122710613herbals
herbier1239593herbier
herbiest1339993herbiest
herbs105520503her__bs
herders113914123herders
herdic123112303herdi_c
herding122915123herding
herds96424683her__ds
hereat93527413hereat_
heredes11313133heredes
heredity1546493heredity
herein93717793herei_n
hereinto1145433hereinto
heres86245903her__es
heresies11312703heresies
heretic12314833heretic
heretics13310503heretics
hereto9313693her_eto
herewith1755193herewith
heriot9422343her_iot
heritor10310563her_itor
heritors11310903her_itors
herls85226433her__ls
herm95636153herm___
herma105318883herm__a
hermae115314473herm_ae
hermai118912863herm_ai
hermetic15310243hermetic
hermetism1646643hermetism
hermetist1448953hermetist
hermetists1545613hermetists
hermitage1543863hermitage
hermitages1643903hermitages
hermitisms1745613hermitisms
hermitries1546763hermitries
hernia9312293herni_a
herniae1039043herniae
hernial10310433hernial
herniate1148113herniate
herniates1247333herniates
herns84825583her__ns
heroes94923833her_oes
heroic113516923heroi_c
heroin94420593heroi_n
heroine103517493heroine
heroines112916573heroines
heroism12311013heroism
heroisms1338693heroisms
heroize193210973heroize
heroizes202610983heroizes
herons94820543her_ons
heros84930863her__os
herpes115517323her_pes
herried113514473herried
herring113615883herring
herrings12379533herrings
hers75844873her___s
hertz174919043her__tz
hertzes1938303hertzes
hessite1038993hessite
hessites1138613hessites
hests85829933he__sts
hetmans12187593hetmans
hets75547203he___ts
hits75545143h___its
hobbits14317553hobbits
homies114524733h_omies
hornets104113553hornets
hornist102314823hornist
hornists11208833hornists
hornito1047073hornito
hornitos1145393hornitos
horsts95817513hor_sts
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
hursts97213093hur_sts
hurts86922823hur__ts
inherits11310103inher_its
intermits111212203intermits
jemmies18318333jemmies
jerids142810943jer_ids
jerkies183411583jerkies
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
jesuits1436323jesuits
keramics1644823keramics
kermes124616133kerm_es
kermess13396223kermess
kermises14248313kermises
kernite1159473kernite
kernites1269113kernites
kerrias11289513kerrias
kerries113317913kerries
kraits104912203_kraits
legits71313003le_gits
limits82514143_limits
marmite112413993marmite
marmites122212793marmites
marmots11311513marmots
mercies113817563mercies
merit7339183mer_it_
merlins93015813merlins
merlots92710123merlots
mermaids1355753mermaids
nereids838743nereids
nereis6315343nerei_s
nerts55924983ner__ts
omits75018263__omits
orbits84211443_orbits
peewits12105873peewits
pelmets11309693pelmets
perils84121853per_ils
peris75537073per_i_s
periti8319953per_iti
peritus9311803per_itus
perlite9317323perlite
perlites10316363perlites
permian112612283permian
perming123416093perming
perms95524513perm__s
permute1138793permute
permutes1238713permutes
perries93226603perries
persist9315853persist
persists1049183persists
pewits112810683pe_wits
premies113823063premies
premiss113513813premiss
readmits1136653readmits
rebaits9312573rebaits
recits83621353re_cits
recruits1036563recruits
reedits8511743reedits
reemit8717223reemit_
refits94017653re_fits
reknits1137073reknits
remints95117293re_mints
remiss84216353re_miss
remit75737223re_mit_
rerents73319423rerents
rerigs74014793rer_igs
resits64725563re_sits
semis74623533se_mi_s
sennits73811283sennits
serails73318363serails
serais64326133serai_s
sereins73716123sereins
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
sermons9311783sermons
serries73925353serries
sherbets1335213sherbets
sherifs13299683sher_ifs
sheroots1137863sheroots
sherries111812903sherries
sherris10168803sherri_s
sprits85122533spr_its
straits74916323straits
submits1139753submits
summits1137983summits
tempts10439453te_mpts
terais64023513terai_s
terbias9310743terbias
tercets93512443tercets
tergite8311003tergite
tergites9310543tergites
termers95414503termers
terming104016003terming
termini93410813termini
terminus1037393terminus
termitic1249283termitic
termors94712773termors
terms75523473term__s
terrets72913583terrets
terries73425633terries
territ63421383territ_
theremins14106053theremins
thermals13518533thermals
thermels13607763thermels
thermes126214613therm_es
thermic1439333thermi_c
thermion1345933thermion
thermions1445333thermions
thermos124610753therm_os
therms115914873therm__s
traits65121983_traits
turbits969233turbits
uremias9249503uremias
varmints1335643varmints
verbids13259203verbids
verdicts1446013verdicts
verdins112812333verdins
verist93823893ver_ist
verists103613673verists
veritas103012753ver_itas
verite94323443ver_ite
verites103822263ver_ites
verity123714853ver_ity
vermeils1374813vermeils
vermes115019143verm_es
vermian12329713vermian
vermin113414523vermi_n
vermuth1543533vermuth
vermuths1642603vermuths
versets103913103versets
versts93914733ver_sts
verts85724733ver__ts
vervets13419753vervets
vomits112610923_vomits
weskits1434743weskits
wherries14179033wherries
wormils1236733wormils
worrits10258683worrits
writs86624383_wr_its

Search took 9 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.843211970.3
2DLD Change Limit1340274067.53317792.0
3Display Results4064060.1402900.0
 (SQL Overall)1786914068.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.