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

205 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
befool113771(None) 
befools1236431befools
befoul1137251befoul
babool103012152babool
befall114410642befall
befell11428712befell
befog1159012bef_og
befogs1246452befogs
befooled1434802befooled
before11410152before
befouls1236052befouls
behoof1458682behoof
behowl1445532behowl
benzol1756992benzol
betook12439602betook
dewool1047402dewool
fool75330592__fool
retool63914482retool
aerosol747683aerosol
afoot8420113_afoot
afoul8510193_afoul
baboo94319503baboo_
babools11319453babools
baboon103613913baboon
baboos103517013baboos
barefoot1346413barefoot
batfowl1543593batfowl
bazoo163815673bazoo_
bazoos173212623bazoos
beacon10511373beacon
beano75421553beano_
beanos85516513beanos
beblood12106083beblood
bebop11410793be_bop
bebops1237623bebops
beckon14309383beckon
beclog1136863beclog
become123312593become
bedel84219403be_del
bedell93610043bedell
bedroll1055553bedroll
bedroom1247083bedroom
beefalo1244083beefalo
beefwood1743353beefwood
befalls12349123befalls
befit105222663bef_it
befits114711503befits
beflag1265883beflag
beflea1147123beflea
befooling1535053befooling
befouled1434683befouled
befouler1343923befouler
befret11315963befret
begall92610723begall
begloom1255243begloom
begone9512133begone
begot84625953be_got
behold1247343behold
behoove1553773behoove
behove14207203behove
behowls1534443behowls
beknot1239763beknot
bel57148463be___l
bell66237183be__ll
bellow114213353bellow
belon73924113be_lon
belong93411043belong
belons84119413belons
below104617193be_low
belows114614183belows
bemoan10310253bemoan
bemock1636173bemock
benomyl1443453benomyl
bento75922953bento_
bentos86218303bentos
benzal1739643benzal
benzole1837133benzole
benzols1836673benzols
benzoyl2143363benzoyl
benzyl2034163benzyl
beryl101211673be_ryl
besnow1145713besnow
besom95716973be_som
besoms105712733besoms
besot76429713be_sot
besots86415453besots
bestow1149463bestow
betel74419903be_tel
bethel1169643bethel
beton76022063be_ton
betons84919553betons
betony114211583betony
bettor83612223bettor
bevel104517043be_vel
bevor101510813be_vor
bevors111610343bevors
bewail1189583bewail
beworm1339993beworm
beyond1237073beyond
bezel165215173be_zel
bezil163812883be_zil
bezoar1736913bezoar
bhoot104322103b_hoot
bifocal1445373bifocal
bifold1237223bifold
biform1368123biform
bigfoot1355993bigfoot
blood85319523b_lood
bloom95918973b_loom
bloop96116153b_loop
boffo136010373boffo_
boffola1543463boffola
boffos14568193boffos
boil66335183b__oil
boll65634753b__oll
bolo65535953b__olo
boo58163663b__oo_
boob85932583b__oob
book106836333b__ook
boom87435673b__oom
boon67142173b__oon
boor66130683b__oor
boos67955033b__oos
boot67759373b__oot
bowl96827703b__owl
broil74918223b_roil
broo65129823b_roo_
brood84620243b_rood
brook114717763b_rook
broom95022213b_room
broos75126413b_roos
buffo135112183buffo_
buffoon1543713buffoon
buffos14447853buffos
ceorl7410923ce_orl
cool66940493__cool
defoam1238563defoam
defog1048523def_og
defogs1156683defogs
deform1259623deform
defuel10348933defuel
dewools1145593dewools
drool65416103_drool
ebook114510803_ebook
enol45823823_e_nol
enrol51014283_enrol
extol1247893_extol
foal76630923__foal
foil76433913__foil
food86830573__food
fools86824203__fools
foot76248013__foot
foul77027583__foul
fowl105723633__fowl
jetfoil1742913jetfoil
ketol95414003ke_tol
metol75917813me_tol
mool67533863__mool
nerol51017813ne_rol
outfool1037333outfool
peafowl1543193peafowl
petrol82714063petrol
peyotl1146233peyotl
pool65835953__pool
precool1139013precool
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
recoal84117973recoal
recoil84016723recoil
recook125513923recook
refall94314393refall
refeel93913243refeel
refel84920813ref_el
refell94214443refell
refill94514053refill
reflood1136363reflood
reflow12379653reflow
refold103812113refold
reform11312713reform
refuel93912623refuel
regosol844883regosol
relook104813743relook
reoil55321183re_oil
repoll8410793repoll
reroll6412683reroll
reroof9315003reroof
respool937643respool
retook104313443retook
retools73411023retools
safrol937283safrol
school11410723school
seafood1146153seafood
seafowl1343913seafowl
shool84523153_shool
snool55118643_snool
spool75219043_spool
stool55619893_stool
teflon937453teflon
tomfool1254243tomfool
tool46735683__tool
trefoil1066063trefoil
uncool8610113uncool
webfoot1544213webfoot
wool76427373__wool

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.390458182.1
2DLD Change Limit1127162055.26621404.5
3Display Results2052050.0603416.7
 (SQL Overall)1786912055.71631261.5
 
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.