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

351 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
hyalin12221003(None) 
hyaline132310721hyaline
hyalins13229271hyalins
cyanin113911452cyanin
cyclin1339272cyclin
cymlin1337312cymlin
halid94424972h_alid
haling104229782h_aling
halon86124862h_alon
healing113922962healing
hyalines14169322hyalines
hyalite13229472hyalite
hyaloid1439062hyaloid
myelin1138962myelin
ptyalin1274772ptyalin
aalii5316123_aalii
again65218113aga_in
agin56132713__agin
ain37579093__a_in
akin86328033__akin
alan46844083__alan
alanin6317273alanin
algin65718763__algin
alien56425583__alien
alif76242133__alif
align65016503__align
aline57243153__aline
alit46155693__alit
alkalin11178173alkalin
aloin55227413__aloin
amain74922883ama_in
amin66042243__amin
anilin6417793anilin
ayin76331743__ayin
baalim1038473baalim
baling94829693_baling
basin75026923_basin
berlin83116373berlin
biali73419073biali_
bialis83617163bialis
blain75421793bla_in
blin67228173__blin
brain76229383bra_in
byline11311643by_line
byrling13337373byrling
cabin94820933_cabin
cain65643913_ca_in
calif104929093_calif
calix145317343_calix
calkin123515493_calkin
caplin103216303caplin
carlin84421823carlin
catlin83819073catlin
chain105723673cha_in
chitlin12269273chitlin
coalbin1137523coalbin
coaling103722823coaling
codlin94516433codlin
colin76231693_colin
cyan96419623cya__n
cyanic133110773cyanic
cyanid123912033cyanid
cyanine122911513cyanine
cyanins122910013cyanins
cycasin1445903cycasin
cyclic1238033cyclic
cycling1537213cycling
cyclins1438303cyclins
cylix17448623cy_lix
cymling1536273cymling
cymlins1436693cymlins
daylit10512493daylit
dealing94323233dealing
dialing94318173dialing
diamin9312513diamin
diazin1639163diazin
drain65222893dra_in
dunlin739723dunlin
dyadic1336093dyadic
dynein1035563dynein
elain55324703ela_in
etalon648973etalon
etamin81311853etamin
eyelid1038433eyelid
fagin9216573_fagin
fain75840563_fa_in
flavin1239303flavin
foaling113515843foaling
gain56042163_ga_in
gamin84422993_gamin
goalie7413153goalie
goaling93515333goaling
goblin939503goblin
gradin83517483gradin
grain65126253gra_in
graplin1058443graplin
gratin74520583gratin
guanin7610803guanin
habit103027013h_abit
hading113922943h_ading
haeing104118923h_aeing
haemin113412663haemin
haen76229453h_a_en
hafiz20611213h_afiz
haik115526983h_a_ik
hail74839063h_a_il
hailing113820693hailing
hails85231643h_ails
haint85436323h_a_int
hair76330143h_a_ir
haji148520183h_aji_
hajis156716273h_ajis
hakim14311823h_akim
halal85623593h_alal
hale76052833h_al_e
haled95335823h_aled
haler85033523h_aler
hales85449843h_ales
half106238453h_al_f
halide103417993h_alide
halids104016133h_alids
halite93624233h_alite
hall75741163h_al_l
hallo85127553h_allo
halls85633783h_alls
halm95834973h_al_m
halma108219253h_alma
halms105225213h_alms
halo76437323h_al_o
haloid104317753h_aloid
haloing113814133h_aloing
halons95720713h_alons
halos85230253h_alos
halt76056303h_al_t
halting114419073h_alting
halts85230103h_alts
halva115414433h_alva
halve114818923h_alve
halving143511543h_alving
haring104233003h_aring
harmin113117393harmin
harpin113614383harpin
hating104929713h_ating
hatpin112610603hatpin
hauling113714433hauling
haven114718533h_aven
having134220373h_aving
hawing134322353h_awing
haying134420613h_aying
hazan173813613h_azan
hazing194218553h_azing
heading122919113heading
headline12129613headline
headpin1336003headpin
heal75645693heal__
healed105121443healed
healer94221803healer
heals85733453heal_s
health124712143health
heaping133015853heaping
hearing113324163hearing
heating114024323heating
heaven123912603heaven
heaving144114763heaving
heeling113618513heeling
heiling113616363heiling
helio85321193h_elio
helix154413013h_elix
helling114623223helling
hellion10311133hellion
hematin121516013hematin
hemin103620933h_emin
hemline12311073hemline
heparin12410433heparin
herein93717793herein
heroin94420593heroin
hili75626633h_ili_
hilling113821773hilling
hin67559563h___in
hipline12311423hipline
hoagie102310003hoagie
hoatzin1943913hoatzin
hoaxing18307763hoaxing
hoddin11369933hoddin
holing104025073h_oling
hoolie93217773hoolie
hotline10712343hotline
hotlink1476753hotlink
howling143413163howling
hulling113619013hulling
hurling113616413hurling
hwan105716893hwa__n
hyacinth1962613hyacinth
hyaena1235363hyaena
hyaenic1545993hyaenic
hyalites14208833hyalites
hyalogen1544053hyalogen
hyaloids1545983hyaloids
hybrid15237813hybrid
hybris14247003hybris
hydatid1546513hydatid
hydria13227903hydria
hydric15227953hydric
hydrid14248963hydrid
hyenic1438723hyenic
hyenine1336953hyenine
hying126514743hy__ing
hyla106716513hy_l_a
hylas114815903hy_las
hymen13311043hy_men
hymn12311313hy__mn
hymning1635183hymning
hyoid12612423hy_oid
hyphen1736393hyphen
hyping15408483hy_ping
hypnic1637263hypnic
hypoing1636503hypoing
hyson1138693hy_son
inulin6311733inulin
isatin6412213isatin
italic839903italic
kain85334293_ka_in
kalian10312163_kalian
kalif125021353_kalif
kaolin1039583kaolin
khalif1657833khalif
kylix19416323ky_lix
lain46146283_la_in
lapin75222923_lapin
layin84720333_layin
lin37967373___lin
lysin84512783ly_sin
main65345503_ma_in
malic94525653_malic
malign939853_malign
maline84529083_maline
malkin122913143_malkin
marlin84220903marlin
matin75132853_matin
mavin105722953_mavin
mayvin1436523mayvin
mealie82519803mealie
merlin83916683merlin
moulin8313283moulin
muslin8312213muslin
myalgia13124283myalgia
myalgic15134213myalgic
myasis114010463myasis
myeline1238253myeline
myelins1237353myelins
myosin113410763myosin
niacin8310223niacin
nyala836823nyal_a
nyalas936903nyalas
nylon82910513ny_lon
opaline9412483opaline
oxalic1537093oxalic
oxalis1339223oxalis
ozalid1696673ozalid
pain65647243_pa_in
paling93530133_paling
patin76832853_patin
paulin8312983paulin
pavin105623203_pavin
pealing104123203pealing
phthalin1655853phthalin
phylic16279553phy_lic
phylon14318033phy_lon
phytin14459003phy_tin
plain74823303pla_in
poplin10413483poplin
praline93019743praline
ptyalins1364693ptyalins
purlin83615863purlin
pyin96823233py__in
pylon103614003py_lon
pyralid1347973pyralid
qualia1559563qualia
rain46251733_ra_in
ratlin64116523ratlin
ravin85624653_ravin
rawin85521473_rawin
reagin74915533reagin
realia6314593realia
realign838763realign
sabin74924943_sabin
sain45551293_sa_in
salic73424713_salic
salina64221123_salina
saline65132703_saline
salon55228553_salon
sarin55239253_sarin
sasin54626573_sasin
satin55935213_satin
savin84625083_savin
scaling103519373scaling
sealing83528563sealing
shealing123415463shealing
shoaling123111743shoaling
sialic8313633sialic
sialid7314933sialid
simlin8311723simlin
slain54923573sla_in
spavin114210653spavin
stain55727933sta_in
staling83925423staling
statin63921463statin
swain84919053swa_in
syli74318983sy_li_
sylis84316023sy_lis
sylvin12247303sylvin
tain45548073_ta_in
takin94921303_takin
tali46837163_tali_
talion6317713_talion
talon55824113_talon
theelin1038003theelin
thiamin1236913thiamin
thiazin1945453thiazin
train56529113tra_in
twain86313623twa_in
tyin76424003ty__in
unakin10310963unakin
vain75233003_va_in
valid94618383_valid
valine94623093_valine
vealing114217423vealing
vialing113614163vialing
violin9311983violin
wain75840193_wa_in
waling104525303_waling
whaling143910773whaling
wyling13368553wy_ling
xylan1537463xy_lan
yagi86922243_yagi_
yagis95416573_yagis
yald86920603_yal_d
yamen104115183_yamen
yamun10419273_yamun
yapon104613583_yapon
yarn75230043_ya_rn
yawing134215613_yawing
yawling14369183_yawling
yawn106219093_ya_wn
yealing112716383yealing
yeelin939343yeelin
yin67648733_y__in
yogin98317743_yogin
yulan8411493_yulan
zayin174512043_zayin
zeatin15412823zeatin

Search took 6 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.1401276364.3
2DLD Change Limit1127163515.34321096.0
3Display Results3513510.2201595.5
 (SQL Overall)1786913515.70331332.8
 
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.