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

470 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
heliac111010891heliac
helipad1344721helipad
belied95022162belied
celiac101910432celiac
chiliad1337562chiliad
delead84112342delead
felid94717172feli_d
gelid74916982geli_d
halid94424982hali_d
head87137172he__ad
heiled104415612heiled
held85330402hel__d
heliast10312072heliast
helical12311152helical
helio85321192heli_o
helios94816632helios
helipads1443872helipads
helium112311252helium
helix154413012heli_x
helled104024702helled
helmed124513692helmed
helped124714152helped
helved134313702helved
heptad1237272heptad
hexad164910622he_xad
iliad64613462_iliad
mediad104313712mediad
pleiad947832pleiad
relaid75518442relaid
relied74926232relied
reload7413892reload
telia55821142telia_
telial65815362telial
abelia83114403abelia_
abelian92810643abelian
abelias93213563abelias
aecia73819283aecia_
aecial84817313aecial
aeolian738623aeolian
aerial64625713aerial
aeried74221863aeried
ahead96817053ahe__ad
alias55834603_alias
alidad838883_alidad
allied74217153allied
aphelia1249423aphelia_
aphelian1376963aphelian
ballad94315323ballad
bead75937923be__ad
begird1036823begird
beglad10138463beglad
behead1239923behead
behind1238063behind
belady12489933bel_ady
belaud939133belaud
belay105021523bel_ay
beldam11410113beldam
beleap10410283beleap
belga8313233belga_
belgas9311713belgas
belie75630383beli_e
belief115018603belief
belier84423563belier
belies84631053belies
belike124616283belike
belive115415303belive
belled94626183belled
bellied104314073bellied
belted94020633belted
blind86319323_blind
cebid104314073cebi_d
ceiled94114953ceiled
celiacs11157893celiacs
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
celled94420323celled
ceria75125353ceria_
cerias83321983cerias
chela103916803chel_a_
chelae113614603chel_ae
chelas113817203chel_as
cheliped1635043cheliped
cheloid13310833cheloid
chevied16357483chevied
chiliads1445853chiliads
cilia73016763cilia_
clad76225823_cl_ad
coeliac1138233coeliac
colead94114643colead
dead65434243de__ad
defied115016383defied
delay94820633del_ay
deleads9379703deleads
deled75326543del_ed
deli55631293deli__
delict94320333delict
delime9314043delime
delimed11310723delimed
delis64928543deli_s
delish105215613delish
delist74625053delist
delta66117773delta_
deltas74414823deltas
delved114112753delved
denial74720513denial
denied84318633denied
dulia61014983dulia_
dulias71212743dulias
eelier64216463eelier
egad64215413_e_gad
elain55324703_elain
elan46734243_el_an
eland65820393_eland
eld46733793_el__d
elide64922643_elide
elided84814673_elided
elint55436473_elint
elite56230183_elite
eolian6312593eolian
eyelid1038443eyeli_d
fecial114714623fecial
felids103111623felids
feline94820143feline
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
felled103720303felled
felted103714653felted
feria85922713feria_
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
fetial95716193fetial
fetid93715983feti_d
filial93013253filial
flied96519433_flied
folia83618933folia_
foliar93210973foliar
gelada837623gel_ada
gelcap1136213gelcap
geld65828433gel__d
gelded94512113gelded
gelled84718893gelled
genial74917613genial
geoid74215763geoi_d
glad65624013_gl_ad
glia56423153_glia_
glial66715433_glial
glias64618493_glias
goliard936073goliard
had77658763h___ad
hailed104122743hailed
halal85623593hal_al
haled95335823hal_ed
halide103417993halide
halids104016133halids
haling104229783haling
halite93624233halite
hallah124115403hallah
hallal94415563hallal
halliard12125963halliard
halma108219253halma_
halmas117017893halmas
haloed104717603haloed
haloid104317763haloid
halted105019603halted
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
halved134813903halved
halyard1476973halyard
headed114020473headed
heads95127113he__ads
heady125117263he__ady
heal75645693he__al
healed105121443healed
healing113922963healing
heap96432893he__ap
heaped124516903heaped
hear76143883he__ar
heard95222753he_ard
heat77061423he__at
heated104525593heated
heaved134717863heaved
hedged125211793hedged
heed86437603he__ed
heeded114215763heeded
heehaw1543933heehaw
heeled104018413heeled
heeling113618513heeling
heeltap1243723heeltap
heezed194210513heezed
hefted134911423hefted
hegira1036523hegira
hegiras1136103hegiras
heigh124812543he_igh
heil76328933he_i_l
heiling113616363heiling
heils85222193he_ils
heir77523803he_i_r
heired103813043heired
heirs85618563he_irs
heist87030913he_ist
hejira1644803hejira
hejiras1744233hejiras
heliacal1344723heliacal
heliasts1136103heliasts
helices12313723helices
helicoid1446753helicoid
helicon1237643helicon
heliums12188303heliums
helixes1739133helixes
hell75637893hel__l
hellcat12410173hellcat
heller93322513heller
helling114623223helling
hellion10311133hellion
hellish13310723hellish
hello86522983hel_lo
helloed113512423helloed
hellos95321683hellos
hells85032043hel_ls
helm95530023hel__m
helmet113718933helmet
helming133712003helming
helms105619463hel_ms
helo75332853hel__o
helos84928063hel_os
helot85332683hel_ot
helots95217703helots
help95328923hel__p
helper114313093helper
helping133512223helping
helps105219343hel_ps
helve115018093hel_ve
helves124316063helves
helving144011133helving
hemal104419803he_mal
hemic125718623hemi_c
hemin103620933hemi_n
hemins113417563hemins
hemline12311073hemline
hemmed144211463hemmed
hemoid12313513hemoid
henlike1448693henlike
henna84414043henna_
hennaed1135103hennaed
hennas94211803hennas
hented104218753hented
hepcat13611823hepcat
heptads1335873heptads
herald10311343herald
herbal112513493herbal
herbed123513453herbed
herd84933063he__rd
herded114215643herded
hereat93527413hereat
heriot9422343heriot
herma105318883herma_
hermae115314473hermae
hermai118912863hermai
hernia9312293hernia_
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
herried113514453herried
hessian1035853hessian
hetman112510603hetman
hewed125619433he_wed
hewing134514243hewing
hexade17438903he_xade
hexads17468193he_xads
hexed165615763he_xed
hexing174210513hexing
heyday1635143heyday
hid76248373h__i_d
hied85434043h__ied
hila76228353hil_a_
hilar85418143hil_ar
hili75626633hili__
hilled104022223hilled
hilted104016043hilted
hind85529753h__ind
hodad10311353h_odad
hoelike141411163hoelike
holard10410573holard
hold86235063hol__d
holed95634133hol_ed
holiday1436143holiday
holier94921623holier
holies94630033holies
holily123612953holily
holing104025073holing
holism113713753holism
holist94723213holist
holked144913663holked
holla84918493holla_
hollaed11359853hollaed
holland11349473holland
hollas94616903hollas
honied104818393honied
hula74923753hul_a_
hulas84920883hul_as
hulked144611303hulked
hulled103920013hulled
humid114213763humi_d
hyla106716513hyl_a_
hylas114815903hyl_as
hyoid12612443hyoi_d
ilia46026823_ilia_
iliac75013493_iliac
iliads7448673_iliads
ilial55317843_ilial
inlaid7310143inlaid
jehad1637683je_had
jelled144916063jelled
jellied15419223jellied
jerid132316423jeri_d
kalian10312163kalian
kelim11912553keli_m
kelims1278913kelims
keloid11812623keloid
kelped13449543kelped
keypad1633823keypad
lad48165703__l_ad
laid56439143__laid
lead56038853__lead
levied104111433levied
liar47229683__liar
liard65418593__liard
lid47453513__li_d
lied55838093__lied
lilied73913213lilied
load56730603__load
mead75531603me__ad
media84721713media_
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
meld75830473mel__d
melded104714713melded
melic94722333meli_c
melled95023023melled
meloid9616003meloid
melted94219063melted
menad85918983me_nad
menial84223033menial
mesial84818083mesial
mesian84315503mesian
milia72719573milia_
myriad1235913myriad
naiad6313403_naiad
obelia8329453obelia_
obelias9279033obelias
onload7268633onload
pelican1139433pelican
pelite84323003pelite
pelted94617753pelted
penial84120893penial
pentad9313763pentad
period9314983period
plaid85118303_plaid
plead85818463_plead
pleiads1045223pleiads
plied85118593_plied
preload1049813preload
read55942533re__ad
realia6314593realia_
rebid85121363rebi_d
rebind94416933rebind
reclad9311873reclad
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393redi_d
refind104717073refind
regild8149773regild
reland75920433reland
relax124817803rel_ax
relay84424673rel_ay
relend76116453relend
reliant7319243reliant
relic74623363reli_c
relics84517903relics
relict83623903relict
relief94419683relief
relier65826183relier
relies65036423relies
reline65434353reline
relined85321933relined
relink104415923relink
relish93916953relish
relist64628413relist
relit55340683reli_t
relive95120783relive
relived115114683relived
reloads8911313reloads
reloan6415693reloan
remind94819793remind
repaid94716323repaid
replead10399003replead
replied103914443replied
reread71715433reread
resaid74517083resaid
resid64124093resi_d
retia55326113retia_
retial64724993retial
retied75924983retied
rewind104715883rewind
salad65321833sal_ad
selah8319613sel_ah
selfed10310913selfed
selva83014273selva_
selvas93812913selvas
sepia75318673sepia_
sepias83616103sepias
serial64625863serial
sheila969843sheila_
sheilas1059403sheilas
shellac1236693shellac
shelled113815083shelled
shelta93111793shelta_
sheltas10279673sheltas
shelved14379933shelved
slid55828983_sli_d
solid65025083soli_d
teiid6312533te_iid
teind6213613te_ind
tela45532973tel_a_
telae54323293tel_ae
telic76019823teli_c
telium82611393telium
tenia55324483tenia_
teniae64517353teniae
tenias64720073tenias
tepid8314313tepi_d
tetrad73612053tetrad
theriac1239143theriac
therian10311293therian
thulia936113thulia_
thulias1035743thulias
triad65217723_triad
ulnad65611453_ulnad
unlaid7311753unlaid
unlead73312373unlead
unload73010803unload
upload9257783upload
valid94618393vali_d
veiled103714543veiled
vela75725543vel_a_
velar85817633vel_ar
veld85323203vel__d
venial94218283venial
weird95111283we_ird
weld84727733wel__d
welded114013383welded
welled103820213welled
welted103715823welted
whelmed16375153whelmed
whelped16355633whelped
xenia124814773xenia_
xenial133414903xenial
xenias133712973xenias
yclad11246383ycl_ad
yeld811423873yel__d
yelled104116253yelled
yelped12439363yelped

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.1231452772.4
2DLD Change Limit1127164705.95318934.3
3Display Results4704700.1403357.1
 (SQL Overall)1786914706.21628746.9
 
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.