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

186 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
befoul113725(None) 
befool1137711befool
befouls1236051befouls
afoul8510192_afoul
befall114410642befall
befell11428712befell
befog1159012befo_g
befogs1246452befogs
befools1236432befools
before11410152before
befouled1434682befouled
befouler1343922befouler
behowl1445532behowl
foul77027582__foul
awful1178143awf_ul
babool103012153babool
babul96317713b_abul
bagful1237213bagful
baleful1238003balef_ul
baneful1237893banef_ul
batfowl1543593batfowl
bayou10512363bayou_
bayous11411153bayous
beau66137273be_au_
beaus75127113be_aus
beaut75135213be_aut
beaux146513213be_aux
bebop11410793bebo_p
bebops1237623bebops
becloud1246293becloud
become123312593become
bedaub1146033bedaub
bedbug12193973bedbug
bedel84219403be_del
bedell93610043bedell
bedouin1046043bedouin
bedroll1055553bedroll
bedrug10164953bedrug
bedu75923693be_du_
befalls12349123befalls
befit105222663bef_it
befits114711503befits
beflag1265883beflag
beflea1147123beflea
befooled1434803befooled
befoulers1443123befoulers
befouling1534983befouling
befret11315963befret
begall92610723begall
begone9512133begone
begot84625953bego_t
begulf1238903be_gulf
begum105213923be_gum
begun85113443be_gun
behold1247343behold
behoof1458683behoof
behove14207203behove
behowls1534443behowls
bel57148463be___l
belaud939133belaud
bell66237183be__ll
belon73924113belo_n
belong93411043belong
belons84119413belons
below104617193belo_w
belows114614183belows
bemoan10310253bemoan
bemock1636173bemock
benomyl1443453benomyl
benzal1739643benzal
benzol1756993benzol
benzoyl2143363benzoyl
benzyl2034163benzyl
beryl101211673be_ryl
bescour1145203bescour
beshout12311843beshout
besmut10310653besmut
besom95716973beso_m
besoms105712733besoms
besot76429713beso_t
besots86415453besots
bestud9439303bestud
betel74419903be_tel
bethel1169643bethel
beton76022063beto_n
betons84919553betons
betony114211583betony
betook12439603betook
bevel104517043be_vel
bevor101510813bevo_r
bevors111610343bevors
bewail1189583bewail
beworm1339993beworm
beyond1237073beyond
bezel165215173be_zel
bezil163812883be_zil
bezoar1736913bezoar
bifocal1445373bifocal
bifold1237223bifold
biform1368123biform
bijou1458793bijou_
bijous1548043bijous
bijoux2253453bijoux
biofuel1243293biofuel
boil66335183b__oil
boll65634753b__oll
boule74828043b__oule
bout66353293b__out
bowl96827703b__owl
boxful18145273boxful
broil74918223b_roil
bugout9311863bugout
bulbul10348073bulbul
buyout11310103buyout
ceorl7410923ce_orl
cerous85821203cerous
default1147893default
defoam1238563defoam
defocus1335283defocus
defog1048523defo_g
defogs1156683defogs
deform1259623deform
defuel10348933defuel
detour778193detour
devour1076703devour
devout10712993devout
dewool1047403dewool
enol45823823_eno_l
ensoul638253ensoul
eyeful1235903eyef_ul
foal76630923__foal
foil76433913__foil
fool75330593__fool
fou66743783__fou_
fouls87221433__fouls
four76226863__four
fowl105723633__fowl
ghoul959053_ghoul
insoul638463insoul
ireful948713iref_ul
jetfoil1742913jetfoil
ketol95414003keto_l
meou65325863me_ou_
meous76120063me_ous
metol75917813meto_l
nerol51017813nero_l
overfoul1446223overfoul
peafowl1543193peafowl
peepul1035783peepul
peyotl1146233peyotl
reboil83814683reboil
recoal84117973recoal
recoil84016723recoil
recoup10810373recoup
redout71820253redout
refall94314393refall
refeel93913243refeel
refel84920813ref_el
refell94214443refell
refill94514053refill
reflux16315413reflux
refocus1236973refocus
refold103812113refold
reform11312713reform
refound1157413refound
refuel93912623refuel
reoil55321183re_oil
repoll8410793repoll
repour8310993repour
reroll6412683reroll
retool63914483retool
rueful948203ruef_ul
rufous948273rufous
seafowl1343913seafowl
serous65023563serous
setous64917373setous
setout64719473setout
soul46435713__soul
tenour62610733tenour
trefoil1066063trefoil
useful947013usef_ul
velour9328763velour
venous93713193venous
waeful1238123waef_ul
woeful1236363woef_ul
woful1158173wof_ul

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.376475242.0
2DLD Change Limit1127161864.92322895.8
3Display Results1861860.0603100.0
 (SQL Overall)1786911865.35933344.1
 
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.