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

279 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
behold124734(None) 
beheld1236411beheld
beholds1336421beholds
ahold94714252_ahold
behalf14310952behalf
behead1239922behead
behind1238062behind
beholden1443592beholden
beholder1435052beholder
behoof1458682behoof
behove14207202behove
behoved16205562behoved
behowl1445532behowl
behowled1733462behowled
behowls1534442behowls
beyond1237072beyond
bifold1237222bifold
bold75432812b__old
hold86235062__hold
refold103812112refold
remold93412972remold
resold73915362resold
retold73013752retold
toehold1146572toehold
uphold12126902uphold
acold86214923_acold
aholds10469483_aholds
bald76432903b__ald
bead75937923be__ad
beaded104922423beaded
beadle93314683beadle
beagle93612593beagle
beaked135919493beaked
beamed115720733beamed
beaned95621473beaned
beard86024963be_ard
beblood12106083beblood
bebop11410793bebo_p
bebops1237623bebops
becalm1239203becalm
bechalk1845803bechalk
becked155417763becked
beclog1136863beclog
becloud1246293becloud
become123312593become
becrowd1555173becrowd
bed67950623be___d
bedded115114063bedded
bedel84219393bedel_
bedell93610043bedell
bedels94015273bedels
bedrid1039943bedrid
bedroll1055553bedroll
beefed123510873beefed
beeped115313453beeped
beetle8311673beetle
beetled1038213beetled
befall114410643befall
befell11428713befell
befog1159013befo_g
befogs1246453befogs
befool1137713befool
befooled1434803befooled
befools1236433befools
before11410153before
befoul1137253befoul
befouled1434683befouled
befouls1236053befouls
begall92610723begall
begged115013803begged
begird1036823begird
beglad10138463beglad
begone9512133begone
begot84625953bego_t
begulf1238903begulf
behave14209013behave
behaved16176683behaved
beheads1338523beheads
behest11314613behest
behinds1335283behinds
beholders1544933beholders
beholding1634233beholding
behoove1553773behoove
behooved1743133behooved
behoves15177353behoves
bel57148463be__l_
belaud939133belaud
belied95022163belied
bell66237183be__ll
belle75827833be_lle
belled94626183belled
bellow114213353bellow
bells76432163be_lls
belly104625493be_lly
belon73924113belo_n
belong93411043belong
belons84119413belons
beloved13188393beloved
below104617193belo_w
belows114614183belows
bels66142493be__ls
belt65754033be__lt
belted94020633belted
bemoan10310253bemoan
bemock1636173bemock
bend76435263be__nd
bended105521233bended
benzol1756993benzol_
benzole1837133benzole
benzols1836673benzols
bermed115217723bermed
berobed1238233berobed
beryl101211673beryl_
beryls11107883beryls
beshout12311833beshout
beshroud1443803beshroud
besom95716973beso_m
besoms105712733besoms
besot76429713beso_t
besots86415453besots
bested94922753bested
bestud9439303bestud
betel74419903betel_
betels84515063betels
bethel1169643bethel_
bethels1238533bethels
bethorn1238643bethorn
beton76022063beto_n
betons84919553betons
betony114211583betony
betook12439603betook
betted94721163betted
bevel104517043bevel_
beveled133811123beveled
bevels113913983bevels
bevor101510813bevo_r
bevors111610343bevors
beworm1339983beworm
beyonds1335063beyonds
bezel165215173bezel_
bezels173712283bezels
bezil163812883bezil_
bezils1711310603bezils
bezoar1736913bezoar
bhoot104322103b_hoot
bield84614653b_ield
bipod104410823bipo_d
blond85618373b_lond
blood85319523b_lood
bod67055543b__o_d
boho96923323boho__
bohos105618253boho_s
bola66035563b__ola
bolds85825283b__olds
bole66448693b__ole
boll65634753b__oll
bolo65535953b__olo
bolt66254173b__olt
bond75334363b__ond
booed85127273b_ooed
borehole1347623borehole
boyhood1646493boyhood
broad84817693b_road
brood84620243b_rood
buboed113010003buboed
buhl95518223buh_l_
buhls105111803buh_ls
build84413353b_uild
byroad1236623byroad
byword1535053byword
ceboid11310653ceboid
child114516223_child
chola104718033_chola
cholo105217973_cholo
chord115917263_chord
cold77338773__cold
dehorn10439653dehorn
dehort104618103dehort
demoed103713443demoed
devoid1189363devoid
dhole95215363_dhole
echoed125211153echoed
eld46733793_e__ld
enfold10137613enfold
enol45823823_enol_
enols54718403_enols
ephod1139123epho_d
eyefold1443343eyefold
eyehole1346003eyehole
feod815523003fe_o_d
fold86528943__fold
freehold1554683freehold
geld65828433ge__ld
geoid74215763ge_oid
gold65430163__gold
held85330403__held
hemoid12313513hemoid
herald10311343herald
hod76852463__ho_d
hoed87837983__hoed
holds94623243__holds
hole77553393__hole
holed95634133__holed
holk116027943__holk
holm95628113__holm
holp95727553__holp
hols76946293__hols
holt77852583__holt
holy106333433__holy
hood85132333__hood
infold10128163infold
jehad1637683jeh_ad
keloid11812623keloid
ketol95414003ketol_
ketols104210763ketols
keyhole1764433keyhole
kobold1365963kobold
meld75830473me__ld
meloid9616003meloid
method1239023metho_d
metol75917813metol_
metols84115773metols
mold76034333__mold
nerol51017813nerol_
neroli61111153neroli
nerols6914883nerols
nevoid1098793nevoid
old47033463___old
onefold1144493onefold
overhold15219013overhold
piehole12188553piehole
premold1247863premold
presold1059603presold
pretold1049083pretold
record96117423record
refolds11298953refolds
regild8149773regild
reload7413893reload
remolds10299703remolds
repoll8410793repoll
reroll6412683reroll
reshod103012233resho_d
reshoed112212153reshoed
resod64720053reso_d
resole64624183resole
resoled84119283resoled
revolt9316223revolt
reweld103711113reweld
reword106321403reword
scold85414863_scold
second9411153second
sheol84318373sheol_
sheols94614163sheols
shod86225063_sho_d
shoed95723013_shoed
should1038033_should
sold54837413__sold
tenfold1145713tenfold
thole85620843_thole
tholed105113873_tholed
toeholds1245093toeholds
told56132203__told
unfold10179703unfold
unholy1238163unholy
unhood1039233unhood
unmold9148313unmold
unsold71410513unsold
untold7149683untold
upfold12124953upfold
upheld12115563upheld
upholds13135243upholds
veld85323203ve__ld
vetoed10359823vetoed
weald95615023we_ald
weld84727733we__ld
whole114418093_whole
wold85429073__wold
yeld811423873ye__ld
zeroed16409413zeroed

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.1231452772.4
2DLD Change Limit1127162795.45320670.5
3Display Results2792790.0803487.5
 (SQL Overall)1786912795.65631593.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.