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

353 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
hertzes193829(None) 
bortzes1838222bortzes
certes84623082cert_es
hearties11315412hearties
heezes184211642he_ezes
heredes11313132heredes
heres86245902her__es
heroes94923822her_oes
heroizes202610982heroizes
herpes115517322her_pes
herries104025072herries
hertz174919032hertz__
hurtles103913752hurtles
aerates74627483aerates
aeries64737783aer_ies
aerobes9311493aerobes
aretes64425353aret_es
beetles9312083beetles
begazes1937963begazes
berakes134815773berakes
berates94126853berates
berimes115216643berimes
bermes106023003ber_mes
berries94423553berries
berthas12398763berthas
berthed13259123berthed
berths114712423bert_hs
blitzes18408703blitzes
brazes175522193_brazes
breezes18318693breezes
cartes86239473cart_es
centres93817123centres
cerates95428233cerates
ceres75540013cer__es
cerises94722253cerises
cerites94823433cerites
ceruses93716233ceruses
cetes75731103ce_t_es
cherries131812973cherries
chertier1387873chertier
chertiest1438793chertiest
cherts115617233chert__s
chintzes2235963chintzes
chortles133611323chortles
crazes174720133_crazes
crozes174417663_crozes
dartles84014133dartles
defuzes20398303defuzes
deities82621923deities
derates84028883derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
dirties83119383dirties
ditzes163212423_ditzes
erases64425403_erases
ernes55224813_er_nes
erodes74819883_erodes
eroses65327053_eroses
erotizes17311213_erotizes
ersatzes1743063_ersatzes
erses55826803_er_ses
etherizes2149313etherizes
exahertzes2991813exahertzes
feazes184514173fe_azes
feezes184412613fe_ezes
feres86038183fer__es
ferities111416713ferities
ferlies103216693ferlies
ferries103521083ferries
ferules103112723ferules
fetes85630143fe_t_es
fettles103912733fettles
fezes175220023fe__zes
fezzes174910403fe_zzes
fortes95327183fort_es
forties104323863forties
freezes193310353freezes
fritzes19329453fritzes
frizes184015463_frizes
furzes186613693fur_zes
futzes184313113_futzes
gentes75324163gent_es
gentles83714343gentles
gestes75721393gest_es
gheraoes1244813gheraoes
ghettoes1243493ghettoes
glitzes17367563glitzes
grazes164519643_grazes
haeredes1246333haeredes
haeres94017033haer__es
hafizes2235983hafizes
hantles104117513hantles
hardies114923233hardies
hares86255543har__es
harpies123818313harpies
harries103525493harries
hartals10313023hartals
harts88441593hart__s
hastes95727073hast_es
hates86742573h_at_es
hazes174928323h__azes
hearses104414533hearses
hearted113314023heart_ed
hearten102411753heart_en
heartens113010153heartens
hearths135311073heart_hs
heartier1139093heartier
heartiest12311103heartiest
heartless1236393heartless
hearts96218943heart__s
heated104525593heat_ed
heater94828303heat_er
heaters104225213heaters
heathen133410893heathen
heathens143210153heathens
heather133914853heather
heathers143914733heathers
heaths126316383heat_hs
heatless113011463heatless
heats85838403heat__s
heaumes1237423heaumes
heaves124120303he_aves
heavies132713873heavies
hebes105521673he__bes
hebraizes2344103hebraizes
heckles163711383heckles
hectares1338853hectares
hectors123513263hectors
heddles123311623heddles
hedges115016243he_dges
heeze175313483he_eze_
heezed194210513he_ezed
hefted134911423heft_ed
hefter124313923heft_er
hefters134312003hefters
heftier1337203heftier
heftiest1439183heftiest
hefts116218153heft__s
heinies102514543heinies
hektares1535813hektares
helices12313723helices
helixes1739133helixes
helloes103717463helloes
helves124316063he_lves
hemes105031083he__mes
henges104516453he_nges
henries102718283henries
hented104218753hent_ed
hents87330743hent__s
hepatizes2347823hepatizes
heptads1335873heptads
heptanes1339003heptanes
heptose1237493heptose
heptoses1338373heptoses
heralds1137703heralds
herbages1437083herbages
herbals122710603herbals
herbed123513453her_bed
herbier1239593herbier
herbiest1339993herbiest
herbless1336663herbless
herbs105520503her__bs
hercules1337633hercules
herded114215643her_ded
herder104516463her_der
herders113914123herders
herdics13249523herdics
herdmen13238453herdmen
herds96424683her__ds
here76447103her__e_
heresies11312693heresies
heresy125011233her__esy
heretics13310503heretics
heriots10312063heriots
heritages1346713heritages
heritors11310903heritors
herls85226433her__ls
hermae115314473hermae_
hermits12312133hermits
herms105626433her__ms
hernias10310773hernias
herns84825583her__ns
heroics122912003heroics
heroines112916573heroines
heroins103518013heroins
heroize193210963heroize_
heroized21298443heroized
herons94820543her_ons
heros84930863her__os
herried113514453herried
hers75844873her___s
hests85829933hest__s
heths116317783he_t_hs
hets75547203he_t__s
hexades18378703hexades
hexanes17319463hexanes
hexes155123043he__xes
hexones17299143hexones
hexoses17228883hexoses
hirees95117293hir_ees
hires86134343hir__es
hirples12149643hirples
hirsles101510073hirsles
hogties112813993hogties
hordes104921633hor_des
horses94729343hor_ses
horstes104516113horstes
hotties103016953hotties
hurdies114015663hurdies
hurdles113613373hurdles
hurlies103315333hurlies
hurries103919653hurries
hurter93915853hurt_er
hurters103413633hurters
hurtle93512943hurtle_
hurtled11339593hurtled
hurtless11307783hurtless
hurts86922823hurt__s
hustles103414173hustles
hyraces1537913hyraces
hyraxes2045703hyraxes
jerkies183411583jerkies
jerries143817513jerries
jetes124922843je_t_es
jetties143613123jetties
kentes105118643kent_es
kermes124616123ker_mes
kernes104717523ker_nes
kerries113317913kerries
kettles113411613kettles
kirtles11309663kirtles
klutzes2064113klutzes
lefties10312073lefties
lethes94818083le_thes
lezzes14387833le_zzes
lutzes153711923_lutzes
mentees93214503mentees
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122483mer_ges
merises93421423merises
merles85322763mer_les
mestees94617753mestees
metes74736213me_t_es
metres85121563me_tres
mettles94115023mettles
mezes167719263me__zes
myrtles1235733myrtles
nerts55924983nert__s
nertz145117453nertz__
nerves94216193ner_ves
nestles73015463nestles
nettles73214083nettles
parties93230863parties
pectizes21229783pectizes
peptizes21269853peptizes
perches143717953perches
perdues103511333perdues
peres76246643per__es
perries93226603perries
perses85428063per_ses
perter84422283pert_er
pertest9317043pert_est
pertness10310093pertness
perukes133210113perukes
peruses94018163peruses
pestles93217693pestles
pettles93916483pettles
phereses1348093phereses
plotzes18317693plotzes
pretzel1835143pretzel
pretzels1934033pretzels
prezes173614693_prezes
prizes173819813_prizes
putzes174212523_putzes
quartzes2645453quartzes
razes145032703__razes
rentes65431193rent_es
rerises73525883rerises
resizes164216843resizes
reties65436193re_ties
retries74129073retries
ritzes154812943_ritzes
seethes103613743seethes
seizes154317533se_izes
seltzer1635203seltzer
seltzers1735063seltzers
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225963ser_ges
series64540973ser_ies
serines74229543serines
serries73925353serries
serves94423653ser_ves
settees73513633settees
settles73916003settles
sheathes14610183sheathes
shelties111111373shelties
sherries111812893sherries
shorties11414573shorties
shvartzes2442093shvartzes
sorties74126403sorties
speltzes1943993speltzes
spitzes1849173spitzes
spritzes1946933spritzes
teethes103611653teethes
terces83921413ter_ces
ternes65422903ter_nes
terries73425613terries
testees74215913testees
testes65125823test_es
theatres11298633theatres
theorizes2147063theorizes
theres96525473ther__es
thermes126214613ther_mes
thirties1139723thirties
tortes64826053tort_es
turtles72914343turtles
tzetzes1532673tzetzes
verges104320173ver_ges
verites103822253verites
verities111418043verities
vermes115019143ver_mes
verses94223763ver_ses
verstes104014273verstes
vertex1637373vert_ex
vertexes18105613vertexes
vertices13612273vertices
verts85724733vert__s
vertus94613603vert_us
verves124617883ver_ves
vestees103513163vestees
vetoes92914083ve_toes
virtues10338023virtues
waltzes1935953waltzes
wheezes22306803whe_ezes
wheres125917433wher__es
wherries14179023wherries
wherves16548053wher_ves
whortles14306743whortles
xeroses143612823xeroses
xeroxes13246443xeroxes
xeruses143010753xeruses
yentes95517603yent_es
yutzes18408413_yutzes
zeroes154314343zer_oes

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.190940478.9
2DLD Change Limit1340273538.25016245.7
3Display Results3533530.1861897.8
 (SQL Overall)1786913538.62620715.4
 
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.