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

253 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
behalf1431095(None) 
becalm1239202becalm
bechalk1845802bechalk
befall114410642befall
begall92610722begall
begulf1238902begulf
behave14209012behave
beheld1236412beheld
behold1247342behold
behoof1458682behoof
half106238452__half
baal67033113b_aal_
baals76122703b_aals
baff124632273b__aff
bal56662723b__al_
bald76432903b__ald
bale66353843b__ale
balk105132223b__alk
ball66043323b__all
balm85534203b__alm
bals66354043b__als
banal75925993banal_
barf95844413b__arf
basal75722283basal_
basalt83519583basalt
beach124623893be_ach
bead75937923be_a_d
beadle93314683beadle
beads85429503be_ads
beady114719923be_ady
beagle93612593beagle
beak106534383be_a_k
beaks115326623be_aks
beaky146118023be_aky
beam86939233be_a_m
beams95328173be_ams
beamy126218573be_amy
bean66443863be_a_n
beano75421553be_ano
beans75734693be_ans
bear66844643be_a_r
beard86024963be_ard
bears75739043be_ars
beast76338643be_ast
beat66168303be_a_t
beats76042243be_ats
beau66137273be_a_u
beaus75127113be_aus
beaut75135213be_aut
beaux146513213be_aux
becalms1335743becalms
became123213163became
becap114315053beca_p
becaps123811403becaps
bechalks1944793bechalks
becharm1636843becharm
bedamn1137813bedamn
bedaub1146033bedaub
bedel84219393bedel_
bedell93610043bedell
bedels94015273bedels
bedlam1149273bedlam
bedwarf16106463bedwarf
beef96233683be__ef
beefalo1244083beefalo
beetle8311673beetle
befalls12349123befalls
befell11428713befell
beflag1265883beflag
begalls10319163begalls
began86319573bega_n
begat86629723bega_t
begaze1838333begaze
beglad10138463beglad
begulfs1333753begulfs
behalves1644083behalves
behaved16176683behaved
behaver15206723behaver
behaves15198523behaves
behead1239923behead
beheads1338523beheads
behest11314613behest
behind1238063behind
beholds1336423beholds
behove14207203behove
behowl1445533behowl
behowls1534443behowls
bel57148463be__l_
belady12489933belady
belaud939133belaud
belay105021523bela_y
belays114313853belays
belief115018603belief
bell66237183be__ll
belle75827833be_lle
bells76432163be_lls
belly104625493be_lly
bels66142493be__ls
belt65754033be__lt
bema85825253bema__
bemas96424283bema_s
bemata10411693bemata
bename103316073bename
benthal1247953benthal_
benzal1739643benzal_
berake124216083berake
berate84729023berate
beryl101211673beryl_
beryls11107883beryls
beshame1447483beshame
beta66234133beta__
betake124512703betake
betas75528763beta_s
betel74419903betel_
betels84515063betels
bethank1666273bethank
bethel1169643bethel_
bethels1238533bethels
bevel104517043bevel_
bevels113913983bevels
bewail1189583bewail
bewails1277553bewails
beware11313713beware
bezant17814543bezant
bezazz1543983bezazz
bezel165215173bezel_
bezels173712283bezels
bezil163812883bezil_
bezils1711310603bezils
bhang115512923b_hang
biali73419073b_iali
bialy105119323b_ialy
binal75323823binal_
blaff135216483b_laff
boral75831703boral_
borals86721913borals
bubal94218213bubal_
bubale104014623bubale
bubals103513843bubals
buhl95518223buh_l_
buhls105111803buh_ls
bytalk1533473bytalk
calf96339563__calf
cecal94619113cecal_
chaff165016283_chaff
chalk144814603_chalk
deaf85838403de_a_f
deal56347413de_al_
deals65435343de_als
dealt65234283de_alt
decaf114919443deca_f
decal85523233decal_
decals93717713decals
dedal75719023dedal_
delf85436573de__lf
desalt7518313desalt
dhal86719283_dhal_
dhals95415443_dhals
egal55119433_egal_
elf66138523_e__lf
enhalo987563enhalo
exalt123018533_exalt
exhale1636873exhale
feal713940423fe_al_
fecal105119213fecal_
female11310553female
feral85424653feral_
ferals94216643ferals
fetal85623373fetal_
haaf106227733__haaf
hale76052833__hale
hall75741163__hall
halm95834973__halm
halo76437323__halo
halt76056303__halt
heal75645693he_al_
heals85733453he_als
hemal104419803hemal_
herald10311343herald
inhale9411513inhale
jehad1637683jeha_d
jehads1735833jehads
kenaf12316033kena_f
khaf145319603_kha_f
khalif1657833_khalif
leaf76441033le_a_f
leal46043273le_al_
legal65715943legal_
legals73412733legals
lethal939803lethal_
lethals1038113lethals
meal65643173me_al_
meals75933373me_als
mealy104422183me_aly
medal86221333medal_
medals94218053medals
metal75427383metal_
metals84520883metals
peal68648103pe_al_
peals75235493pe_als
pedal86022503pedal_
pedalo93811153pedalo
pedals94316033pedals
pelf97031453pe__lf
penal75228373penal_
petal76526893petal_
petals84719813petals
real45750293re_al_
realm75621623re_alm
reals55038653re_als
recall83815723recall
refall94314393refall
regal65023793regal_
regale74821453regale
rehab10312443reha_b
rehabs1139023rehabs
rehang1039823rehang
rehash1237433rehash
renal55929503renal_
resale64025543resale
seal45654373se_al_
seals54839693se_als
self75138293se__lf
sepal77723003sepal_
sepals85217373sepals
seral56336383seral_
setal56430903setal_
shale85332833_shale
shall85024053_shall
shalt85534493_shalt
shaly114322863_shaly
sheaf115424123shea_f
sheal84927703sheal_
sheals94420643sheals
shelf115221113_shelf
teal45546503te_al_
teals56234133te_als
tepal76319583tepal_
tepals85415043tepals
trehala1045953trehala
veal76936813ve_al_
veals84926193ve_als
vealy115817773ve_aly
venal85523213venal_
weal75838683we_al_
weald95615023we_ald
weals85428743we_als
whale115517433_whale
wharf14315823_wharf
wheal115716183wheal_
wheals124512523wheals
zeal135530333ze_al_
zeals145320853ze_als

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 Limit1127162535.79619447.2
3Display Results2532530.0803162.5
 (SQL Overall)1786912535.99929786.8
 
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.