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

419 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
behead123992(None) 
beheads1338521beheads
beheld1236411beheld
ahead96817052_ahead
barehead1446602barehead
bead75937922b__ead
beglad10138462beglad
beheadal1442812beheadal
beheaded1536372beheaded
beheader1436042beheader
behest11314612behest
behind1238062behind
behold1247342behold
beleap10410282beleap
bemean10410682bemean
bestead10389112bestead
bighead14126652bighead
bluehead1444602bluehead
bohea105013732bohea_
boheas114013212boheas
bonehead1445932bonehead
bowhead1636432bowhead
bread85523112b_read
cohead123811122cohead
delead84112342delead
head87137172__head
jehad1637682jeh_ad
redhead1257052redhead
rehear93713222rehear
reheard11309022reheard
reheat94423942reheat
reread71715432reread
aahed917816443aahe_d
ached119227833ache_d
ahed89536253_ahe_d
airhead1136993airhead
ashed97829773ashe_d
baaed85218163baae_d
bached145519893bache_d
bad67763153b___ad
baked126130773bake_d
baldhead1544273baldhead
baled85436443bale_d
ballad94315323ballad
baned85436353bane_d
bared85144483bare_d
based85331583base_d
bashed126225703bashe_d
bateau8810563bateau
bated85935533bate_d
bathed125518743bathe_d
bayed115423023baye_d
beached154516553beache_d
beachhead2042583beachhead
beaded104922423beaded
beads85429503b__eads
beady114719923b__eady
beak106534383b__eak
beaked135919493beaked
beam86939233b__eam
beamed115720733beamed
bean66443863b__ean
beaned95621473beaned
bear66844643b__ear
beard86024963be_ard
beat66168303b__eat
beau66137273b__eau
becap114315053be_cap
becked155417763becked
bed67950623b__e_d
bedded115114073bedded
bedeck1536213bedeck
bedel84219403bede_l
bedell93610043bedell
bedels94015273bedels
bedeman12168843bedeman
bedew114513043bede_w
bedewed1437153bedewed
bedews12398943bedews
bedlam1149273bedlam
bedpan1137583bedpan
bedrid1039943bedrid
bedstead1253403bedstead
bedward1497473bedward
bee56262403be_e__
beebread1343243beebread
beech124315503be_ech
beedi8711663be_edi
beef96233683be_e_f
beefed123510873beefed
beefs105618563be_efs
beefy135313833be_efy
been65335783be_e_n
beep85931213be_e_p
beeped115313453beeped
beeps95320973be_eps
beer65635993be_e_r
beers75628393be_ers
beery105220123be_ery
bees65453383be_e_s
beet66457543be_e_t
beets76131443be_ets
beeyard1335523beeyard
befell11428713befell
beflag1265883beflag
beflea1147123beflea_
befleaed1454663befleaed
befleas1236973befleas
began86319573be_gan
begat86629723be_gat
beget85632563bege_t
begets96215523begets
beggar10328223beggar
begged115013813begged
begird1036823begird
beglads11127263beglads
behalf14310953behalf
behave14209013behave
behaved16176683behaved
beheadals1542093beheadals
beheaders1545153beheaders
beheading1636163beheading
behests1235953behests
behinds1335283behinds
beholds1336423beholds
behoof1458683behoof
behove14207203behove
behoved16205563behoved
behowl1445533behowl
belady12489933be_lady
belaud939133belaud
belay105021523be_lay
belched154011843belche_d
beldam11410113beldam
beleaped1336103beleaped
beleaps1138053beleaps
beleapt11310253beleapt
belga8313233belga_
belgas9311713belgas
belied95022163belied
belled94626183belled
belted94020633belted
bema85825253be_ma_
bemas96424283be_mas
bemeaned1335783bemeaned
bemeans1148733bemeans
bemoan10310253bemoan
benched154713943benche_d
bend76435263b__end
benday123810813benday
bended105521233bended
bene66439493bene__
beneath1236973beneath
benes75536233bene_s
benzal1739643benzal
bereave1258353bereave
bereaved1446403bereaved
bereft114317303bereft
beret74946363bere_t
berets85822523berets
bermed115217723bermed
berthed13259123berthe_d
beseem1069083beseem
beses75830723bese_s
beset76739133bese_t
besets85718803besets
besmear1134833besmear
bespeak1544573bespeak
bespread1344183bespread
besteads11307113besteads
bested94922753bested
bestud9439303bestud
beta66234133be_ta_
betas75528763be_tas
betel74419903bete_l
betels84515063betels
bethel1169643bethe_l
bethels1238533bethels
bethesda1441953bethesda
betray111511443betray
betta74916843betta_
bettas84913923bettas
betted94721163betted
bevel104517043beve_l
beveled133811123beveled
bevels113913983bevels
beweary1536223beweary
beweep13147253beweep
bewept13410323bewept
bewrap13157053bewrap
bewray14147733bewray
beyond1237073beyond
bezel165215173beze_l
bezels173712283bezels
bezoar1736913bezoar
bided95424963bide_d
bield84614653b_ield
bigheads15145653bigheads
biked125320033bike_d
billhead1464433billhead
biped104718833bipe_d
bleak115915383b_leak
blear75918683b_lear
bleat75737003b_leat
bled75729313b_le_d
bleed85019803b_leed
blend85317453b_lend
blued84520323blue_d
blueheads1544063blueheads
boded95124963bode_d
bolthead1445903bolthead
boned85133243bone_d
boneheads1545203boneheads
booed85127273booe_d
boreal84817213boreal
boreas85421733boreas
bored85034303bore_d
bowed114533423bowe_d
bowheads1745373bowheads
boxed154318613boxe_d
brad75234343b__rad
breads95419203b_reads
bready124511183b_ready
break115319403b_reak
bream95121813b_ream
bred75130973b_re_d
breed85526693b_reed
brewed125411873brewe_d
broad84817693b_road
bulkhead1863673bulkhead
bullhead1464783bullhead
bureau8712523bureau
bused85624493buse_d
bushed124822383bushe_d
butthead1454513butthead
byroad1236623byroad
cathead1338753cathead
ceded96118563cede_d
cepheid1545433cepheid
cereal8315833cereal
cered85227443cere_d
chad105525503_ch_ad
cheap126915943_cheap
cheat105732453_cheat
coheads13289233coheads
cokehead1845063cokehead
colead94114643colead
dead65434243__dead
deadhead1444433deadhead
debeak1336763debeak
debeard1137353debeard
deed65340903de_e_d
defeat103817163defeat
defend113910493defend
deked115718533deke_d
deleads9379703deleads
deled75326543dele_d
demean9510563demean
depend103510923depend
dewed105020303dewe_d
dopehead1544073dopehead
dread74419023_dread
ebbed104111003ebbe_d
eched116919223eche_d
egad64215413_e_gad
egghead1343433egghead
eked96718023_eke_d
emend86214893_emend
ennead736253ennead
exed125420593_exe_d
eyed86623233_eye_d
fathead1437863fathead
feed84538903fe_e_d
feted94420933fete_d
feued94715663feue_d
forehead1537893forehead
gearhead1344433gearhead
geed65435503ge_e_d
godhead1334763godhead
had77658763__h_ad
haed86338583__haed
heads95127113__heads
heady125117263__heady
heal75645693__heal
heap96432893__heap
hear76143883__hear
heard95222753__heard
heat77061423__heat
heed86437603__heed
heehaw1543933heehaw
held85330403__held
heptad1237273heptad
herd84933063__herd
hereat93527413hereat
hewed125619433hewe_d
hexad164910623he_xad
hexed165615763hexe_d
hophead16337923hophead
hothead14349293hothead
jarhead1835173jarhead
jeed125428503je_e_d
jehads1735833jeh_ads
jereed144012073jereed
jetbead1742983jetbead
jewed165114833jewe_d
jihad1635913jih_ad
jughead1933643jughead
keyed1369393keye_d
keypad1633823keypad
kheda1346533_kheda
knead10429663_knead
lead56038853__lead
leched123716003leche_d
legend837693legend
lehua837953lehua_
lehuas935943lehuas
lethean1037093lethean
leveed104111373leveed
mead75531603__mead
meathead1436793meathead
mediad104313713mediad
meed74934703me_e_d
menad85918983me_nad
meshed124415933meshe_d
meted85424433mete_d
mewed115218013mewe_d
need54934153ne_e_d
nereid7312923nereid
obeyed1235823obeye_d
ohed87825183_ohe_d
oohed94214213oohe_d
oread64619603_oread
overhead152110363overhead
peched144915343peche_d
peed76239183pe_e_d
pentad9313763pentad
perea75026443perea_
pinhead13347073pinhead
pithead13419593pithead
plead85818463_plead
pothead133810393pothead
preheat12413893preheat
read55942533__read
recheat12415933recheat
reclad9311873reclad
redear73515173redear
reded74829123rede_d
redheads1336173redheads
reed55549623re_e_d
refed93921923refe_d
refeed104717623refeed
regear73512743regear
rehab10312443reh_ab
rehears103312773rehears
reheated122415003reheated
reheats104513523reheats
reheel93610823reheel
rehem103815353rehe_m
rehems113410983rehems
relend76116453relend
reload7413893reload
remend95216553remend
repeal84718283repeal
repeat85127213repeat
replead10399013replead
rereads81512293rereads
reseal64819643reseal
reseat64131493reseat
reseau64216213reseau
reseda739703reseda
reseed74823293reseed
resend75016773resend
reteam83214533reteam
retear63115483retear
rethread1245353rethread
retread849003retread
reveal94115053reveal
rewear93012003rewear
rewed95425453rewe_d
reweld103711113reweld
rhea75017433_rhea_
rheas84816953_rheas
saphead1357773saphead
seed55549483se_e_d
sered65737293sere_d
sewed95325163sewe_d
sexed136618543sexe_d
shad86230913_sh_ad
shea76031573_shea_
sheaf115424123_sheaf
sheal84927703_sheal
shear85424833_shear
sheas86331793_sheas
shed86536153_she_d
shend94719973_shend
sherd96321153_sherd
sorehead1246973sorehead
spread9312533spread
stead65520273_stead
subhead1387693subhead
teched124014433teche_d
teed55439263te_e_d
tetrad73612053tetrad
tewed94718533tewe_d
thread105011093thread
towhead1435223towhead
tread64821703_tread
undead82711903undead
unheard1136943unheard
unlead73312373unlead
unread73412673unread
upheap13105213upheap
upheld12115563upheld
vexed165713113vexe_d
warhead1436603warhead
weed85637513we_e_d
wellhead1543503wellhead
wheal115716183_wheal
wheat114924573_wheat

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.390458182.1
2DLD Change Limit1127164195.92319030.2
3Display Results4194190.1402992.9
 (SQL Overall)1786914196.45327691.2
 
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.