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

253 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
hypha163738(None) 
hyphae1746431hyphae
hyphal1736421hyphal
alpha1049652alpha
epha9310052_epha
haha107821062h_aha
hydra12249222hydra
hyena11810252hyena
hyla106716512hy_la
hyp117822462hyp__
hype125519812hyp_e
hyped145313332hyped
hyper135213902hyper
hypes135818672hypes
hyphen1736392hyphen
hypo127516352hyp_o
hypos1312014742hypos
hyps125418412hyp_s
nympha1643572nympha
syph125413272syph_
syphs13519452syphs
agha87417303_agha
aha611246643__aha
aloha8513623aloha
alphas1139513alphas
ayah108022993ayah_
ayahs116813523ayahs
byplay1634193byplay
caph116623293caph_
caphs124515373caphs
chuppa1543973chuppa
copra98115463copra
cuppa11398523cuppa
cyma116715843cy_ma
cypher16306593cypher
dacha114812573dacha
dopa77220903dop_a
ephah1337063_ephah
ephas10311543_ephas
eyra76217553ey_ra
glyph1456473glyph_
glyphs1534303glyphs
gyoza1836113gyoza
gyp98319013gyp__
gyps105115023gyp_s
gypsy14636993gypsy
ha510259943___ha
hah910655223h_ah_
hahas117118443h_ahas
hahs108333363h_ahs
haika125313793haika
halma108219253halma
halva115414433halva
hamza19139773hamza
hansa85416783hansa
hap87360053hap__
hapax1739323hapax
haply135915063haply
happy155813533happy
haps96443463hap_s
hash106936503hash_
hath105933913hath_
heehaw1543953heehaw
heh96039623h_eh_
hehs106723963h_ehs
henna84414043henna
hep86644143hep__
hepcat13611823hepcat
heptad1237273heptad
herma105318883herma
heth107028023heth_
heths116317783heths
high116619933high_
highs125412523highs
hight125327233hight
hijra1535643hijra
hila76228363h_ila
hip86750443hip__
hiply134113613hiply
hippo12369063hippo
hippy155112793hippy
hips96433713hip_s
holla84918493holla
honda9414983honda
hooka125513903hooka
hoopla1147633hoopla
hop87554593hop__
hope96639673hop_e
hoped115628183hoped
hoper105829143hoper
hopes105835643hopes
hophead16337923hophead
hoppy154912353hoppy
hops97942633hop_s
hora76136563h_ora
horah117922053horah
hosta85917833hosta
hoya107418373h_oya
hryvna1541573hryvna
huh96432013h_uh_
hula74923753h_ula
humph155712213humph_
humphs16528163humphs
hunh106323733hunh_
hup86437813hup__
huppah1644183huppah
hush105224113hush_
huzza1646093huzza
hyaena1235363hyaena
hydrae13258573hydrae
hydras13239313hydras
hydria13227903hydria
hydro12259423hydro
hyenas1288953hyenas
hyetal1236543hyetal
hying126514743hying
hylas114815903hylas
hymen13311043hymen
hymn12311313hy_mn
hymnal1434913hymnal
hymns1337523hymns
hyoid12612443hyoid
hypers144811913hypers
hyphemia2146133hyphemia
hyphens1836043hyphens
hyping15408483hyping
hypnic1637263hypnic
hypoed1547923hypoed
hypogea1645473hypogea
hyponea1546453hyponea
hypoxia2246373hypoxia
hyrax1838033hyrax
hyson1138693hyson
hyte109018943hy_te
kapa106021303kap_a
kaph135815763kaph_
kaphs144911503kaphs
kappa13469743kappa
kasha124710723kasha
khaph17395963khaph_
khaphs18394323khaphs
koph135816553koph_
kophs145010933kophs
koppa13397293koppa
kythe15509673kythe
lepta75714393lepta
lipa68425933lip_a
lycea10418943lycea
lych126015763lych_
lycra10317973lycra
lymph1547043lymph_
lymphs1635053lymphs
lyssa835713lyssa
lytta888063lytta
mocha1249923mocha
myna95815303my_na
mynah13569563mynah
myoma1239273myoma
myopia13318443myopia
myth126715433myth_
myths135911603myths
mythy16568673mythy
napa66927263nap_a
nappa98511863nappa
nipa69421643nip_a
nucha10229793nucha
nyala836823nyala
nymph1555213nymph_
nymphae1743833nymphae
nymphal1744043nymphal
nympho1643583nympho
nymphs1633503nymphs
opah96218403_opah
orphan1137733orphan
ouph95618373ouph_
ouphe104413263ouphe
ouphs104311273ouphs
pa410456483__p_a
pacha126518063pacha
pah88853593__pah
papa85827143pap_a
pasha105417183pasha
pea56657243__pea
pepla9312863pepla
phat95837863__phat
phi86524203__phi
phpht1538063phpht
pht86030523__pht
phyla13469183phy_la
pia56848043__pia
poppa8409893poppa
pupa85422813pup_a
pya87023753__pya
qoph185911943qoph_
qophs19507813qophs
raphae114311733raphae
raphe104916423raphe
raphia113511263raphia
rhaphae1543203rhaphae
rhaphe1433423rhaphe
rhyta1135083rhy_ta
rhythm1742883rhythm
rya67622013ry__a
scyphi1643173scyphi
sepia75318673sepia
septa75518083septa
sha69837783__sha
shophar1555463shophar
soph97024203soph_
sophs104916023sophs
sophy136611763sophy
spa55730813_sp_a
sulpha1135403sulpha
supra73614253supra
sylph1347793sylph_
sylphs1435543sylphs
sylphy1744153sylphy
sylva11268443sylva
sypher14317083sypher
syphon1436853syphon
tapa65129153tap_a
tepa66021683tep_a
tephra1136483tephra
toph96326873toph_
tophe106718973tophe
tophi105215303tophi
tophs105220053tophs
typal105311153typal
type96223743typ_e
typed115815453typed
types105721063types
typey135511883typey
typhon1436673typhon
typhus14395713typhus
typic124511963typic
typo95418123typ_o
typos106015813typos
typp115812783typ_p
typps12549303typps
typy126013043typ_y
tythe115210453tythe
wha96422073__wha
whydah1942953whydah
wisha114910853wisha
wych154011883wych_
ya510251503_y__a
yah99046353_yah_
yea66445753_y_ea
yeah106725413_yeah
yeh97135773_yeh_
yoga87418053_yoga
yuca95716723_yuca
yuga85615423_yuga

Search took 5 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 Filter178691836670.343520965.0
2DLD Change Limit836672533.84321771.3
3Display Results2532530.0763328.9
 (SQL Overall)1786912534.26241926.6
 
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.