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

282 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
hexyls193343(None) 
hexyl1844461hexyl_
beryls11107882beryls
heals85733452he_als
heels85625532he_els
heils85222192he_ils
hells85032042he_lls
herls85226432he_rls
hexads17468192hexads
hexers165612752hexers
hexes155123042hex_es
hexylic2243032hexylic
phenyls1534322phenyls
vexils1647172vexils
acetyls12285353acetyls
acyls104211523_acyls
adenyls1143923adenyls
alkyls13465723alkyls
allyls9437273allyls
amyls104512683_amyls
aryls87015813_aryls
axels126313633_axels
axils127217503_axils
bedels94015273bedels
bells76432163be_lls
bels66142493be__ls
benzyls2133673benzyls
beryl101211673beryl_
betels84515063betels
bevels113913983bevels
beys913829553be_y_s
bezels173712283bezels
bezils1711310603bezils
butyls1176753butyls
ceils75019403ce_ils
cells75428063ce_lls
cels65534973ce__ls
ceorls848163ceorls
cresyls1234753cresyls
deals65435343de_als
debyes1238103debyes
decals93717713decals
deils65722863de_ils
dells66630943de_lls
dels56745473de__ls
devels104313903devels
devils104412813devils
dexes135224513dex_es
dexies145018343dexies
dexy156118553dexy__
deys85027473de_y_s
earls56127513_earls
eels46536743_e_els
ells46431353_e_lls
els37645723_e__ls
emyds1144923_emyds
enols54718403_enols
ethoxyls2142213ethoxyls
ethyls1235903ethyls
evils84114263_evils
exalt123018533_exalt
exalts13328313_exalts
exams14199083_exams
excels1536663_excels
execs14539723_execs
exes116530813_ex_es
exile126117653_exile
exiles134816403_exiles
exits125515913_exits
exons125813343_exons
expels1547173_expels
expos1449203_expos
extols1337683_extols
exult122814123_exult
exults13257633_exults
eyas76427433_e_yas
eyes75837883_e_yes
feels85223043fe_els
fells85327383fe_lls
ferals94216643ferals
feyly14429513fe_yly
gels56836103ge__ls
hails85231643h_ails
halals95018313halals
halls85633783h_alls
hamals114816813hamals
harls85634503h_arls
hauls86123733h_auls
hays106138073h_ay_s
hazels185710083hazels
heads95127113he_ads
heal75645693he_al_
heaps105223223he_aps
hears86737373he_ars
hearts96218943hearts
heaths126316383heaths
heats85838403he_ats
heaves124120303heaves
hebes105521673he_bes
heckle153112093heckle
heckles163711383heckles
hecks145220653he_cks
heddle114211163heddle
heddles123311623heddles
heders104119763heders
hedges115016243hedges
heeds95420423he_eds
heel75034223he_el_
heezes184211643heezes
hefts116218153he_fts
hehs106723963he__hs
heil76328933he_il_
heirs85618563he_irs
heists96814633heists
held85330403he__ld
helios94816633helios
hell75637893he__ll
hello86522983he_llo
hellos95321683hellos
helm95530023he__lm
helms105619463he_lms
helo75332853he__lo
helos84928063he_los
helots95217703helots
help95328923he__lp
helps105219343he_lps
helves124316063helves
hemal104419803hemal_
hemes105031083he_mes
hemins113417563hemins
hemps126917333he_mps
hems95534943he__ms
henges104516453henges
hennas94211803hennas
henrys12366103henrys
hens75642573he__ns
hents87330743he_nts
herald10311343herald
heralds1137703heralds
herbals122710603herbals
herbs105520503he_rbs
herds96424683he_rds
heres86245903he_res
herl75834553he_rl_
herms105626433he_rms
herns84825583he_rns
heroes94923823heroes
herons94820543herons
heros84930863he_ros
herpes115517323herpes
hers75844873he__rs
hes66654203he___s
hests85829933he_sts
heths116317783he_ths
hets75547203he__ts
heuchs14447923heuchs
heughs13516903heughs
hewers123715273hewers
hews105631573he__ws
hex137436173hex___
hexad164910623hex_ad
hexade17438903hexade
hexades18378703hexades
hexane16379533hexane
hexanes17319463hexanes
hexapla1943343hexapla
hexaplas2043523hexaplas
hexed165615763hex_ed
hexer155116683hex_er
hexing174210513hexing
hexone16289233hexone
hexones17299143hexones
hexose16267843hexose
hexoses17228883hexoses
hey96741063he_y__
hills85431353h_ills
hols76946293h__ols
hosels94218603hosels
hotels94515503hotels
hovels125413333hovels
howls116219223h_owls
hoyas115016163h_oyas
hoyle11314413h_oyle
hoyles12315013h_oyles
hoys107733933h_oy_s
hulls84923563h_ulls
hurls86522713h_urls
hyla106716513h__yla
hylas114815903h__ylas
hyps125418413h__yps
idyls9498803_idyls
jebels15418913jebels
jells125522163je_lls
jewels16508613jewels
keels94622413ke_els
ketols104210763ketols
kevels134410713kevels
kevils13358333kevils
kexes166216813kex_es
keys116322163ke_y_s
legals73412733legals
levels94113283levels
lexes127225263lex_es
lexis125916033lex_is
leys76430183le_y_s
meals75933373me_als
medals94218043medals
mells75031333me_lls
mels65941533me__ls
merls77423903me_rls
metals84520883metals
methyls1535453methyls
metols84115773metols
mewls105813233me_wls
nerols6914883nerols
newels93710823newels
nexus124710663nex_us
nonyls957853nonyls
octyls11135323octyls
odyls9428653_odyls
oxeyes1635893oxeyes
peals75235493pe_als
pearls84715383pearls
pedals94316033pedals
peels75226423pe_els
pentyls1236523pentyls
perils84121853perils
petals84719813petals
phenols1238103phenols
phenyl1435323phenyl_
pixels15478533pixels
reals55038653re_als
rebels84518133rebels
redyes104214083redyes
reels55333263re_els
refels94618053refels
reoils64516873reoils
repels84318763repels
revels94220573revels
rexes124526953rex_es
seals54839693se_als
seels55632823se_els
sells55134433se_lls
sels46345983se__ls
sepals85217373sepals
sexes126126223sex_es
sexily1638853sexily
sextos134012163sextos
sexts125118383sex_ts
sexy146418023sexy__
sheals94420643she_als
shekels1436043shekels
shells94319523she_lls
sheols94614153she_ols
sheqels1934753sheqels
sibyls1135303sibyls
taxols13328633taxols
teals56234133te_als
teels55726373te_els
tells55828943te_lls
tellys9348843tellys
tels46841693te__ls
tepals85415043tepals
tetryls1034643tetryls
texas126514933tex_as
texts125515043tex_ts
tolyls9436963tolyls
veals84926193ve_als
veils84918803ve_ils
vexers165210403vexers
vexes155719123vex_es
vexil1538963vexil_
vinyls12467003vinyls
weals85428743we_als
wedels103811033wedels
wells85426193we_lls
wheals124512523whe_als
wheels123811713whe_els
wheys145911553whe_y_s
xylyls1931833xylyls
yells85821943ye_lls
zeals145320853ze_als

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 Filter1786911127160.233766914.2
2DLD Change Limit1127162827.48615056.9
3Display Results2822820.0763710.5
 (SQL Overall)1786912827.79522923.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.