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

264 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
herdics1324952(None) 
herdic123112301herdic_
heroics122912001heroics
hardies114923232hardies
herders113914122herders
herding122915122herding
herds96424682herd__s
heretics13310502heretics
hermits12312142hermits
hernias10310772hernias
heroic113516922heroic_
heroins103518012heroins
herries104025082herries
hurdies114015662hurdies
medics114115352me_dics
verdict1339582verdict
verdicts1446012verdicts
verdins112812332verdins
aeries64737783aer_ies
aerobics1246833aerobics
asdics9439863_asdics
bardic11312923bardic_
bedims1149593be_dims
beedies10314203beedies
berlins93216013berlins
berries94423553berries
beylics1436183beylics
birdies104016213birdies
burdies104117563burdies
cardiacs1376923cardiacs
cardias10715123cardias
cedis84317083ce_di_s
ceramics1446803ceramics
cercis104614493cerci_s
cerias83321983cer_ias
ceric94023093cer_ic_
cervices1537133cervices
chemics16349583che_mics
cherries131812993cherries
chervils1644553chervils
clerics1149333cler_ics
credits1039973credits
cretics112911653cretics
darics94314113dar_ics
derails84216393derails
derbies103016053derbies
derides93420853derides
dermic114511913dermic_
dermis94717163dermi_s
derrick1435803derrick
derricks1544433derricks
derries83124623derries
derris73615273derri_s
dyadics1453473dyadics
eddies83313163_eddies
edict84722283_e_dict
edicts94911703_e_dicts
edits65819033_e_dits
epics95014283_e_pics
erica7316543_er_ica
ericas8315463_er_icas
erotics91914153_erotics
ervils948773_ervils
ethics11169283_ethics
ferias95020393fer_ias
ferlies103216693ferlies
fermis114313503fermi_s
ferric1139993ferric_
ferries103521083ferries
garlics1038013garlics
geodic1048003geodic_
georgics1242873georgics
gerbils1037303gerbils
gherkins1643993gherkins
hardass1139753hardass
hardens113815023hardens
hardier114721543hardier
hardiest123416343hardiest
hardily143310273hardily
hards96435653hard__s
harmins123716723harmins
harpies123818323harpies
harpins123615703harpins
harries103525503harries
headers113819393headers
headier113212953headier
headiest123015553headiest
headily1478623headily
heading122919113heading
headings133510493headings
headpins1436103headpins
heads95127113head__s
hearties11315423hearties
heavies132713873heavies
hectic132311523hectic_
heddles123311623heddles
heders104119763he_ders
hedges115016263he_dges
hedonics1445903hedonics
heeders114213743heeders
heeding123515063heeding
heeds95420423heed__s
heils85222193he__ils
heinies102514543heinies
heirdoms1444353heirdoms
heirs85618563he__irs
helices12313723he_lices
helios94816633he_lios
hematics151712193hematics
hemic125718623he_mic_
hemins113417573he_mins
henbits12177003henbits
henries102718283henries
hepatics15198933hepatics
heraldic1445163heraldic_
heralds1137713heralds
herbals122710613herbals
herbier1239593herbier
herbiest1339993herbiest
herbs105520503her__bs
herd84933063herd___
herded114215643herd_ed
herder104516463herd_er
herdlike1636113herdlike
herdman13238423herdman
herdmen13238453herdmen
heredes11313133heredes
heredity1546493heredity
herein93717793herei_n
heres86245903her__es
heresies11312703heresies
heretic12314833heretic_
heriot9422343her_iot
heriots10312063heriots
herls85226433her__ls
hermit11519443hermi_t
herms105626433her__ms
hernia9312293herni_a
herniae1039043herniae
hernial10310433hernial
herns84825583her__ns
heroes94923833her_oes
heroical13410023heroical
heroin94420593heroi_n
heroine103517493heroine
heroines112916573heroines
heroism12311013heroism
heroisms1338693heroisms
heroize193210973heroize
heroizes202610983heroizes
herons94820543her_ons
heros84930863her__os
herpes115517323her_pes
herried113514473herried
herring113615883herring
herrings12379533herrings
hers75844873her___s
hertzes1938303hertzes
hexadic2045413hexadic_
heydays1734143heydays
heydeys1732863heydeys
hirudins1244933hirudins
hoddins12289373hoddins
hoodies113419833hoodies
hordeins1238323hordeins
hordes104921633hord_es
hording123517053hording
howdies142911953howdies
hurdles113613373hurdles
hurds95219073hurd__s
hurlies103315333hurlies
hurries103919653hurries
hydric15227953hydric_
hydrids15267233hydrids
irenics937833irenics
jerids142810943jer_ids
jerkies183411583jerkies
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
keramics1644823keramics
kermis124012393kermi_s
kerrias11289513kerrias
kerries113317913kerries
lyrics11357943lyr_ics
medias93620783me_dias
medic104619653me_dic_
medick154010133me_dick
medicks16368413me_dicks
medico113711163me_dico
medicos12339833me_dicos
medius93613283me_dius
mercies113817563mercies
mercs96020453mer__cs
merdes94518603merd_es
merits8320873mer_its
merlins93015813merlins
metrics11312363metrics
neddies92710703neddies
nerdier83110363nerdier
nerdiest92511163nerdiest
nerdish1137103nerdish
nerds65719253nerd__s
nereids838743nereids
nereis6315343nerei_s
nordic939473nordic_
pelvics14245643pelvics
peptics132610243peptics
perdie94718513perdi_e
perdues103511333perdues
perdus93711273perd_us
perils84121853per_ils
peris75537073per_i_s
permits11314003permits
perries93226603perries
predict12315323predict
predicts1339613predicts
readies83324713readies
redias74523603re_dias
redips93713843re_dips
redries83721713redries
reedits8511743reedits
relics84517903re_lics
rerigs74014793rer_igs
sardius839553sardius
septics112810433septics
seracs84418573ser_acs
serails73318363serails
serais64326133serai_s
serdabs1035323serdabs
sereins73716123sereins
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
serries73925353serries
service1239093service
services1338573services
sferics1236133sfer_ics
sherds105614723sherd__s
sherifs13299683sher_ifs
sherries111812903sherries
sherris10168803sherri_s
spherics1537073spher_ics
syndics1335703syndics
tardies84225863tardies
teddies92711283teddies
terais64023513terai_s
terbias9310743terbias
terbic10410963terbic_
terries73425633terries
territs72714503territs
theodicy1742773theodicy
theriacs1336543theriacs
thermic1439333thermic_
thermits1338513thermits
torics85118353tor_ics
verbids13259203verbids
verdin103113023verdi_n
veridic1338143veridic_
vermis114214963vermi_s
vertices13612283vertices
weirdies12255783weirdies
wherries14179033wherries
xeric144315663xer_ic_

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.406440125.6
2DLD Change Limit1340272647.92316916.2
3Display Results2642640.1401885.7
 (SQL Overall)1786912648.46921099.4
 
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.