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

245 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
hyetal123654(None) 
acetal84314902acetal
chaetal1238282chaetal
fetal85623372_fetal
foetal9311882foetal
haemal113811642haemal
hartal9415472hartal
heal75645692h_e_al
hemal104419802h_emal
hiatal9310202hiatal
hiemal11339502hiemal
hyena11810252hyena_
hyenas1288952hyenas
hymenal1545182hymenal
hymnal1434912hymnal
hyphal1736412hyphal
metal75427382_metal
petal76526892_petal
setal56430902_setal
abettal946073abettal
aceta74017353aceta_
acetals93411353acetals
acetyl11396553acetyl
aortal65217513aortal
apetaly1237253apetaly
areal55928733are_al
artal55525473_artal
beta66234133_beta_
betas75528763_betas
betel74419903_betel
bimetal1138433bimetal
brutal859383brutal
byelaw1444253byelaw
byssal1134993byssal
bytalk1533473by_talk
caecal103713733caecal
cantal84122033cantal
cecal94619113_cecal
cental84420963cental
chaeta11310683chaeta_
chaetae1238603chaetae
cheetah1545453cheetah
chetah14399583chetah
chital114313883chital
coeval1138893coeval
coital84117053coital
costal85419513costal
credal9311673credal
crestal9312133crestal
cryptal1445683cryptal
crystal1237433crystal
curtal83914543curtal
cymbal15236913cymbal
daedal849083daedal
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
dental74319173dental
detail74516433_detail
distal73615773distal
dotal64919623_dotal
ductal938993ductal
egal55119433__egal
eta35834193__eta_
etas46432273__etas
eyeball1245063eyeball
eyebar1135323eyebar
eyeful1235903eyeful
eyestalk15123173eyestalk
faecal11359813faecal
fatal84819373_fatal
feal713940423_fe_al
fecal105119213_fecal
feral85424653_feral
festal94213563festal
feta76528903_feta_
fetas85624403_fetas
fetial95716193_fetial
fontal9313143fontal
gametal1037603gametal
geta56627443_geta_
getas65421483_getas
gyral94412783gy_ral
hadal95518123h_adal
haematal1345143haematal
haet75659503haet__
haets86525123haet_s
halal85623593h_alal
hallal94415563hallal
hamal104623113h_amal
hammal134512063hammal
hartals10313023hartals
head87137173h_e_ad
heals85733453h_e_als
heap96432893h_e_ap
hear76143883h_e_ar
heat77061423h_e_at
heath115724283h_eath
heats85838403h_eats
heehaw1543933heehaw
heel75034223h_e_el
heeltap1243723heeltap
heil76328933h_e_il
hell75637893h_e_ll
hematal1238953hematal
heptad1237273heptad
herald10311343h_erald
herbal112513493herbal
herl75834553h_e_rl
het67674313h_et__
heth107028023h_et_h
heths116317783h_eths
hetman112510603h_etman
hets75547203h_et_s
hexad164910623h_exad
hexyl1844463h_exyl
heyday1635143heyday
horal86328683h_oral
hosta85917833hosta_
hostas94515823hostas
hostel93914153hostel
hotel85520753h_otel
humeral1238563humeral
hyaena1235363hyaena_
hyaenas1334983hyaenas
hydra12249223hydra_
hydrae13258573hydrae
hydras13239313hydras
hyenic1438723hyenic
hyla106716513hy_la_
hylas114815903hy_las
hymeneal1643473hymeneal
hymenial1645293hymenial
hymnals1543523hymnals
hyoidal1444803hyoidal
hypethral2053093hypethral
hypha1637383hypha_
hyphae1746433hyphae
hyrax1838033hy_rax
hyte109018943hy_t_e
ideal65716393ide_al
ileal56118083ile_al
instal6712193instal
isohyetal1551473isohyetal
ketol95414003_ketol
keypal1534893keypal
leal46043273_le_al
legal65715943_legal
lethal939803_lethal
lienal63912783lienal
luteal64411483luteal
lytta888063lytta_
lyttae994713lyttae
lyttas985073lyttas
meal65643173_me_al
meatal84114733meatal
medal86221333_medal
mental84521603mental
meta65932413_meta_
metals84520883_metals
metol75917813_metol
mortal84616853mortal
natal53921493_natal
notal55221353_notal
octal71214723_octal
omental93210413omental
osteal6312963osteal
peal68648103_pe_al
pedal86022503_pedal
penal75228373_penal
petals84719813_petals
peytral1287503peytral
phytol14366563phy_tol
pieta75421753pieta_
pietas84516503pietas
plexal1536843plexal
portal84218463portal
postal84317533postal
pretax152310193pretax
quetzal2543013quetzal
quezal2435143quezal
ratal55025113_ratal
real45750293_re_al
rectal84418133rectal
regal65023793_regal
renal55929503_renal
rental63922023rental
retag63618413_retag
retail65522073_retail
retax124517973_retax
retial64724993_retial
retral64419743_retral
rhyta1135083rhy_ta_
rictal83113183rictal
seal45654373_se_al
segetal868383segetal
sepal77723003_sepal
septal84513383septal
seral56336383_seral
seta45637313_seta_
setae56026223_setae
sheal84927703she_al
shtetel1033943shtetel
shtetl936443shtet_l
spital83813873spital
statal61613223statal
steal56125473ste_al
syntax1634303syntax
tapetal938273tapetal
teal45546503_te_al
tectal83713253tectal
tepal76319583_tepal
thecal113310303thecal
thenal92712423thenal
theta83414573theta_
thetas93011573thetas
total55321823_total
tymbal13236823tymbal
typal105311153ty_pal
ureal56722683ure_al
uveal84411073uve_al
veal76936813_ve_al
vegetal1156303vegetal
venal85523213_venal
vestal94615573vestal
vital84819673_vital
weal75838683_we_al
wheal115716183whe_al
yea66445753_ye_a_
yeah106725413_ye_ah
yean75834583_ye_an
year76534253_ye_ar
yeas78638423_ye_as
yell76028323_ye_ll
yenta83917043_yenta_
yentas94614213_yentas
yet66960693_yet__
yeti75823213_yet_i
yetis85418393_yetis
yett76434493_yet_t
yetts86715133_yetts
zeal135530333_ze_al
zeta135121643_zeta_
zetas145018163_zetas
zoeal144813783zoe_al

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.406440125.6
2DLD Change Limit1127162455.95318934.3
3Display Results2452450.0763223.7
 (SQL Overall)1786912456.43527768.6
 
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.