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

281 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
heroics12291200(None) 
herdics13249521herdics
heroic113516921heroic_
heroins103518011heroins
aerobics1246832aerobics
erotics91914152_erotics
hedonics1445902hedonics
herdic123112302herdic_
heretics13310502heretics
heriots10312062heriots
hermits12312142hermits
hernias10310772hernias
heroes94923822hero_es
heroical13410022heroical
heroin94420592heroi_n
heroine103517482heroine
heroines112916572heroines
heroism12311012heroism
heroisms1338692heroisms
heroize193210962heroize
heroizes202610982heroizes
herons94820542hero_ns
heros84930862hero__s
herries104025072herries
aeries64737783aer_ies
aerobes9311493aerobes
aerobic11310213aerobic_
aneroids9310203aneroids
aroids75118223_aroids
berlins93216013berlins
berries94423553berries
beylics1436183beylics
broils84114173_broils
broncs101611153_broncs
ceboids1237653ceboids
ceramics1446803ceramics
cercis104614493cerci_s
cerias83321983cer_ias
ceric94023093cer_ic_
ceros74726073cero__s
cerotic11415063cerotic_
cerous85821203cero_us
cervices1537133cervices
cheloids1438033cheloids
chemics16349583che_mics
cheroots1348193cheroots
cherries131812983cherries
chervils1644553chervils
choroids1438693choroids
chronics1538683chronics
clerics1149333cler_ics
cretics112911653cretics
crocs95722433_cro_cs
darics94314113dar_ics
demotics1338753demotics
derails84216393derails
derbies103016053derbies
dermic114511913dermic_
dermis94717163dermi_s
dermoids1246163dermoids
derrick1435803derrick
derricks1544433derricks
derries83124623derries
derris73615273derri_s
devoice13347343devoice
devoices14307413devoices
devoirs1175783devoirs
droids84712583_droids
droits74314313_droits
durocs9569703duro_cs
ebonics1137193_ebonics
eloins65419383_eloins
emeroids11147723emeroids
epics95014283_e_pics
erica7316543_er_ica
ericas8315463_er_icas
erodes74819883_erodes
eros45238453_ero__s
eroses65327053_eroses
erotic82620273_erotic_
erotica92811513_erotica
ervils948773_ervils
ethics11169283_ethics
exotics16229193_exotics
ferias95020393fer_ias
ferlies103216693ferlies
fermis114313503fermi_s
ferric1139993ferric_
ferries103521083ferries
frolics1236833_frolics
garlics1038013garlics
genomics1345713genomics
geoids8369843ge_oids
georgics1242873georgics
gerbils1037303gerbils
gherkins1643993gherkins
groins73917203_groins
haloids113012553haloids
hardies114923233hardies
harmins123716723harmins
harmonics16107403harmonics
harpies123818323harpies
harpins123615703harpins
harries103525493harries
havocs1435653havo_cs
hearties11315413hearties
heavies132713873heavies
hectic132311523hectic_
hedonic1339043hedonic_
heils85222193he__ils
heinies102514543heinies
heirs85618563he__irs
helices12313723he_lices
helios94816633he_lios
helos84928063helo__s
helots95217703helo_ts
hematics151712193hematics
hemic125718623he_mic_
hemins113417573he_mins
hemoid12313513hemoi_d
henbits12177003henbits
henries102718283henries
hepatics15198933hepatics
heralds1137713heralds
herbals122710603herbals
herbier1239593herbier
herbiest1339993herbiest
herbs105520503her__bs
herders113914123herders
herding122915123herding
herds96424683her__ds
heredes11313133heredes
herein93717793herei_n
heres86245903her__es
heresies11312693heresies
heretic12314833heretic_
heriot9422343her_iot
herls85226433her__ls
hermit11519443hermi_t
herms105626433her__ms
hernia9312293herni_a
herniae1039043herniae
hernial10310433hernial
herns84825583her__ns
hero74635783hero___
heroicize2345363heroicize
heroicizes2445293heroicizes
heroinism1446873heroinism
heroized21298453heroized
heron85025503hero__n
heronries1248483heronries
heronry1346043heronry
herpes115517323her_pes
herried113514453herried
herring113615883herring
herrings12379533herrings
hers75844873her___s
hertzes1938303hertzes
hexones17299143hexones
hexoses17228883hexoses
hidrotics1544513hidrotics
hoick145210683h__oick
hoicks15378283h__oicks
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
hydroids1647763hydroids
hyoids1377673h_yoids
irenics937833irenics
jerids142810943jer_ids
jerkies183411583jerkies
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
keloids1288663keloids
keramics1644823keramics
kermis124012393kermi_s
kerrias11289513kerrias
kerries113317913kerries
lyrics11357943lyr_ics
medics114115353me_dics
meloids10911453meloids
memoirs1136803memoirs
mercies113817563mercies
mercs96020453mer__cs
merits8320873mer_its
merlins93015813merlins
meropias1249963meropias
meropic13310263meropic_
metrics11312363metrics
negroids10116323negroids
nereids838743nereids
nereis6315343nerei_s
nerolis71012773nerolis
nerols6914883nero_ls
neurotics1147363neurotics
pelvics14245643pelvics
peptics132610243peptics
percoids1339663percoids
perils84121853per_ils
periods10312243periods
peris75537073per_i_s
permits11314003permits
peroxids1837453peroxids
perries93226603perries
phenolics1645053phenolics
reboils94111723reboils
recoils93814873recoils
recoins94019243recoins
rejoice16287453rejoice
rejoices17287663rejoices
rejoins143111383rejoins
relics84517903re_lics
reoils64516873re_oils
rerigs74014793rer_igs
rerolls739943rerolls
reroofs1037943reroofs
revoice12319183revoice
revoices13278993revoices
rhetorics1443753rhetorics
rocs65533663__ro_cs
roils54826793__roils
septics112810433septics
seracs84418573ser_acs
serails73318363serails
serais64326133serai_s
sereins73716123sereins
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
serious73616283serious
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
serries73925353serries
service1239093service
services1338573services
sferics1236133sfer_ics
sherifs13299683sher_ifs
sheroots1137863sheroots
sherries111812893sherries
sherris10168803sherri_s
spherics1537073spher_ics
spheroids1545543spheroids
steroids9911443steroids
stoics8311113_stoics
tarocs84615663taro_cs
terais64023513terai_s
terbias9310743terbias
terbic10410963terbic_
terries73425633terries
territs72714503territs
theories11311593theories
theriacs1336543theriacs
thermic1439333thermic_
thermits1338513thermits
theroid11313403theroi_d
thyroids1546003thyroids
torics85118353tor_ics
toroids8310643toroids
trois57226093_troi_s
tropics113610653_tropics
unheroic1345263unheroic_
verbids13259203verbids
verdict1339583verdict
verdicts1446013verdicts
verdins112812333verdins
vermis114214963vermi_s
veronica1346733veronica
veronicas1446393veronicas
vertices13612283vertices
viroids1137923viroids
wherries14179023wherries
xeric144315663xer_ic_
xeroses143612823xeroses
xerosis14249663xerosis
xerotic16410863xerotic_
xeroxes13246443xeroxes
zeroes154314343zero_es
zeroing1738343zeroing
zeros144918113zero__s

Search took 8 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.403443402.0
2DLD Change Limit1340272816.89319443.9
3Display Results2812810.1062650.9
 (SQL Overall)1786912817.40224140.9
 
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.