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

309 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
hydras1323931(None) 
hydra12249221hydra_
hydrae13258571hydrae
hydrase14287661hydrase
hydros13279361hydros
eyras84715922ey_ras
hijras1635772hijras
horas86333102h_oras
hybris14247002hybris
hydrant1489052hydrant
hydrants1585792hydrants
hydrases15227642hydrases
hydrate14239812hydrate
hydrates15229412hydrates
hydria13227902hydria
hydriae14246902hydriae
hydric15227952hydric
hydrid14248972hydrid
hydrids15267232hydrids
hydro12259422hydr_o
hydrops16197412hydrops
hydrous14197882hydrous
hyenas1288952hyenas
hylas114815902hy_las
hyrax1838032hy_rax
lycras11287252lycras
madras94316432madras
mudras94212262mudras
agoras7613343agoras
andros7313303andros
arras55626133_arras
auras55932563_auras
boras75938303_boras
bras65746453__bras
buras74736303_buras
byres104421383by_res
byrls105711233by_rls
cadres94017933cadres
cedars93312833cedars
chadars1338293chadars
chakras16428503chakras
charas114223613charas
cobras104014193cobras
codas84724243cod_as
copras103517153copras
cycas126513823cy_cas
cyders12398833cyders
cymars13599153cymars
cymas126417883cy_mas
cypres1338523cypres
cyprus1335363cyprus
dadas75819863dad_as
dhooras1135943dhooras
dobras94811913dobras
douras75016723douras
drab76226453__drab
drabs85119673__drabs
drag64825053__drag
drags75521113__drags
dram75832003__dram
drams86025833__drams
drat56247833__drat
drats66628373__drats
draw85623013__draw
draws95119373__draws
dray85428093__dray
drays95819773__drays
drys86314803__drys
duras65727733_duras
durras74713373durras
dyers96617133dyer_s
ephedras1444413ephedras
eras45441503__eras
extras13310223extras
eyas76427433ey__as
eyers86521333eyer_s
eyra76217553ey_ra_
eyres84921773ey_res
fedoras1137923fedoras
floras94715693floras
gaydars1235803gaydars
gyozas1933613gyozas
gyral94412783gy_ral
gyrase10508773gy_rase
gyres94820323gy_res
gyros95616483gy_ros
gyrus95310803gy_rus
haars85620473haar_s
hadal95518123had_al
hades96035113had_es
hadjes175210403hadjes
hadjis17439653hadjis
hadron102913753hadron
hadrons113314303hadrons
haeres94017033haeres
hahas117118443h_ahas
hairs86225173hair_s
halmas117017893halmas
halvas124714173halvas
hamzas20119013hamzas
hansas94616043hansas
harass9313943h_arass
hardass1139753hardass
hards96435653h_ards
hares86255543h_ares
harks126333433h_arks
harls85634503h_arls
harms106829013h_arms
harps105926873h_arps
harts88441593h_arts
has67372653h___as
hayers124415943hayer_s
hears86737373hear_s
hearts96218943hearts
heders104119763heders
hedges115016263hedges
hegiras1136103hegiras
heirs85618563heir_s
hejiras1744233hejiras
hennas94211803hennas
henrys12366103henrys
herbs105520503h_erbs
herds96424683h_erds
heres86245903h_eres
herls85226433h_erls
herms105626433h_erms
herns84825583h_erns
heros84930863h_eros
hers75844873h_er_s
heyday1635143heyd_ay
heydays1734143heydays
heydeys1732863heydeys
hiders104919653hiders
hides95129423hid_es
hijra1535643hijra_
hijrah1934283hijrah
hijrahs2043443hijrahs
hires86134343h_ires
hoards104912623hoards
hoars85925553hoar_s
hodad10311353hod_ad
hodads1147963hodads
hods87239863hod__s
hoers85724923hoer_s
hollas94616903hollas
hondas10313353hondas
hookas135312503hookas
hoorah124411113hoorah
hoorahs13399613hoorahs
hooray123011373hooray
hoorays13418383hoorays
hora76136563h_ora_
horah117922053h_orah
horahs126313873h_orahs
horal86328683h_oral
hordes104921633hordes
horns86125333h_orns
hostas94515833hostas
houris94514583houris
hours85422393hour_s
hoyas115016163h_oyas
hoydens14347403hoydens
hryvnas1641493hryvnas
hubris11218973hubris
hulas84920883h_ulas
hurds95219073h_urds
hurls86522713h_urls
hurrah12369183hurrah
hurrahs13336773hurrahs
hurray12459913hurray
hurrays13386153hurrays
hurts86922823h_urts
huzzas1735863huzzas
hyaenas1334983hyaenas
hybrid15237813hybrid
hybrids16236023hybrids
hydracid1844983hydracid
hydracids1943843hydracids
hydragog1743053hydragog
hydragogs1842983hydragogs
hydranth1873893hydranth
hydranths1983163hydranths
hydrastis1644503hydrastis
hydrated16216953hydrated
hydrator1545763hydrator
hydrators1645683hydrators
hydride15257503hydride
hydrides16276943hydrides
hydrillas1643443hydrillas
hydrocast1845803hydrocast
hydroid1539713hydroid
hydroids1647763hydroids
hydrolase1645883hydrolase
hydropsy20184153hydropsy
hydroski1943523hydroski
hydrosol1544473hydrosol
hydroxy2454263hydroxy
hyena11810253hyena_
hyetal1236543hyetal
hyla106716513hy_la_
hymens1437993hymens
hymnal1434913hymnal
hymnals1543533hymnals
hymns1337523hy_mns
hyoids1377673hyoids
hypers144811913hypers
hypes135818673hy_pes
hypha1637383hypha_
hyphae1746433hyphae
hyphal1736423hyphal
hypos1312014743hy_pos
hyps125418413hy__ps
hyraces1537913hy_races
hyraxes2045703hy_raxes
hysons1237633hysons
ideas65919013_ideas
indris7311963indris
ixoras1337193ixoras
jagras1438463jagras
judas134911883jud_as
khedas1446313khed_as
koras95927113_koras
kyars124813963kyar_s
lauras63414333lauras
libras83711703libras
lidars7310783lidars
liras56021983_liras
lycra10317973lycra_
lyres85019963ly_res
lyssas935443lyssas
lyttas985073lyttas
madrasa10387883madrasa
madres93718183madres
maras75443293_maras
mbiras1077153mbiras
medias93620783medias
midrash1335423midrash
moras76438783_moras
mudra83912433mudra_
muras75329583_muras
murras84916013murras
mylars114310443mylars
mynas105815233my_nas
myomas1338303myomas
myrrhs1443603myrrhs
nadas66320813nad_as
nairas6312783nairas
nyalas936903nyalas
odas57230263_od_as
okras94410973_okras
operas8312453operas
oyers87620883oyer_s
padres95016983padres
paras76143043_paras
pedros9312183pedros
purdas92612263purdas
pyas96225703py__as
pyran10514473py_ran
pyrans11411063py_rans
pyres105523883py_res
pyros105718293py_ros
pyurias1236713pyurias
radars71314673radars
ras37575393___ras
redias74523603redias
redraw10269853redraw
redraws11218473redraws
rhodoras1244453rhodoras
ryas77224613ry__as
sabras85116363sabras
shyers124712203shyer_s
sirras63814863sirras
sodas64123543sod_as
soras55041013_soras
suras55336333_suras
surras65919533surras
sutras64818593sutras
sylvas12288173sylvas
syngas10368913syngas
terras63516973terras
tetras63017623tetras
tiaras6314553tiaras
toras55540373_toras
tundras857113tundras
tyers86220053tyer_s
tyres84725233ty_res
tyros85118593ty_ros
ultras6310193ultras
umbras1038643umbras
undraw1037813undraw
undraws1136893undraws
varas86028193_varas
vodkas1443543vodkas
whydah1942953whyd_ah
whydahs2041883whydahs
yards95324613_yards
yarns85621793_yarns
years84527673_years
yeas78638423_y_eas
yerbas11119293_yerbas
yerks125416563_yerks
yirds96612513_yirds
yirrs8469193_yirrs
yogas96615603_yogas
yores85031323_yores
yucas106013913_yucas
yugas95012063_yugas
yurts87216533_yurts
zebras1737853zebras

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.470380193.6
2DLD Change Limit1127163096.06318590.8
3Display Results3093090.1102809.1
 (SQL Overall)1786913096.64326899.1
 
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.