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 “befools” 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
befools123643(None) 
befool1137711befool_
befouls1236051befouls
babools11319452babools
befalls12349122befalls
befogs1246452bef_ogs
befooled1434802befooled
befoul1137252befoul_
behowls1534442behowls
benzols1836672benzols
dewools1145592dewools
fools86824202__fools
retools73411022retools
aerosols847213aerosols
babool103012153babool_
baboons113211083baboons
baboos103517013baboo_s
batfowls1642773batfowls
bazooms20285383bazooms
bazoos173212623bazoo_s
beacons11410733beacons
beanos85516513beano_s
bebloods13115233bebloods
bebops1237623be_bops
beckons15279143beckons
beclogs1237073beclogs
becomes132911963becomes
bedells10379363bedells
bedels94015273be_dels
bedroll1055553bedroll
bedrolls1144673bedrolls
bedrooms1345713bedrooms
beefalos1343653beefalos
beefwoods1843173beefwoods
befall114410643bef_all
befell11428713bef_ell
befits114711503bef_its
beflags1355493beflags
befleas1236973befleas
befog1159013bef_o_g
befooling1535053befooling
before11410153bef_ore
befouled1434683befouled
befouler1343923befouler
befoulers1443123befoulers
befrets1237613befrets
begalls10319163begalls
beglooms1344273beglooms
behold1247343be_hold
beholds1336423beholds
behoof1458683behoo_f
behoove1553773behoove
behooves1653793behooves
behoves15177353behoves
behowl1445533behowl_
beknots1335083beknots
bellows124313303bellows
bells76432163be__lls
belongs10408223belongs
belons84119413be_lons
belows114614183be_lows
bels66142493be___ls
bemoans1138253bemoans
bemocks1735373bemocks
benomyls1542983benomyls
bentos86218303bento_s
benzol1756993benzol_
benzole1837133benzole
benzoles1936993benzoles
benzoyls2242443benzoyls
benzyls2133673benzyls
beryls11107883be_ryls
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bestows1248863bestows
betels84515063be_tels
bethels1238533bethels
betons84919553be_tons
betook12439603betoo_k
bettors93312473bettors
bevels113913983be_vels
bevors111610343be_vors
bewails1277553bewails
beworms1437933beworms
beyonds1335063beyonds
bezels173712283be_zels
bezils1711310603be_zils
bezoars1836793bezoars
bhoots11459913b_hoots
bifocals1543703bifocals
bifold1237223bif_old
bigfoots1443633bigfoots
bloods94614843b_loods
blooms104613173b_looms
bloops106611343b_loops
boffola1543463boffola
boffolas1642833boffolas
boffos14568193boffo_s
boils75427193b__oils
bolls75531313b__olls
bolos75531373b__olos
boobs96221993b__oobs
books115729713b__ooks
booms95427123b__ooms
boons75031913b__oons
boors74325013b__oors
boos67955033b__oo_s
boots75837973b__oots
bowls106121433b__owls
broils84114173b_roils
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_roo_s
buffoons1643093buffoons
buffos14447853buffo_s
ceorls848163ce_orls
cools75632633__cools
defoams1336193defoams
defocus1335283defocus
defogs1156683def_ogs
deforms1337803deforms
defuels11296983defuels
dewool1047403dewool_
drools74412813_drools
ebooks12358333_ebooks
enols54718403_e_nols
enrols61213383_enrols
extols1337683_extols
foals85721693__foals
foils85025813__foils
foods95924163__foods
fool75330593__fool_
foots85528283__foots
fouls87221433__fouls
fowls115518893__fowls
jetfoils1842453jetfoils
ketols104210763ke_tols
metols84115773me_tols
mools76027173__mools
nerols6914883ne_rols
outfools1136533outfools
peafowls1642893peafowls
petrols92913083petrols
peyotls1233633peyotls
pools74427703__pools
precools1237703precools
reboils94111723reboils
rebooks134010513rebooks
reboots93512093reboots
recoals94214623recoals
recoils93814873recoils
recooks134711233recooks
refalls103312243refalls
refeels10379693refeels
refels94618053ref_els
refills103711423refills
refloods1245553refloods
reflows13258983reflows
refocus1236973refocus
refold103812113ref_old
refolds11298953refolds
reforms1239823reforms
refuels10399523refuels
regosols944323regosols
relooks114010723relooks
reoils64516873re_oils
repolls939053repolls
rerolls739943rerolls
reroofs1037943reroofs
respools1036253respools
retool63914483retool_
safrols1036863safrols
schools1249113schools
seafoods1245673seafoods
seafowls1443663seafowls
shools94919013_shools
snools65715883_snools
spools85115913_spools
stools65117023_stools
teflons1036543teflons
tomfools1343543tomfools
tools55325243__tools
trefoils1145303trefoils
wools84421463__wools

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271865.92322628.2
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.39227955.4
 
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.