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

156 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
befouls123605(None) 
befools1236431befools
befoul1137251befoul_
befalls12349122befalls
befogs1246452befo_gs
befool1137712befool_
befouled1434682befouled
befouler1343922befouler
befoulers1443122befoulers
behowls1534442behowls
fouls87221432__fouls
afoul8510193_afoul_
babools11319453babools
babuls105413643b_abuls
bagfuls1334753bagfuls
batfowls1642773batfowls
bayous11411153bayou_s
beaus75127113be_au_s
beauts86015283be_auts
bebops1237623bebo_ps
beclouds1345373beclouds
becomes132911963becomes
bedaubs1233693bedaubs
bedbugs13193503bedbugs
bedells10379363bedells
bedels94015273be_dels
bedouin1046043bedouin
bedouins1145513bedouins
bedrolls1144673bedrolls
bedrugs11194283bedrugs
befall114410643bef_all
befell11428713bef_ell
befits114711503bef_its
beflags1355493beflags
befleas1236973befleas
befog1159013befo__g
befooled1434803befooled
before11410153befo_re
befouling1534983befouling
befrets1237613befrets
begalls10319163begalls
begulf1238903be_gulf
begulfs1333753be_gulfs
begums11429493be_gums
behold1247343beho_ld
beholds1336423beholds
behoves15177353behoves
behowl1445533behowl_
belauds1036643belauds
bells76432163be__lls
belongs10408223belongs
belons84119413belo_ns
belows114614183belo_ws
bels66142493be___ls
bemoans1138253bemoans
bemocks1735373bemocks
benomyls1542983benomyls
benzols1836673benzols
benzoyls2242443benzoyls
benzyls2133673benzyls
beryls11107883be_ryls
bescours1245093bescours
beshouts1346763beshouts
besmuts1134683besmuts
besoms105712733beso_ms
besots86415453beso_ts
bestuds10326753bestuds
betels84515063be_tels
bethels1238533bethels
betons84919553beto_ns
bevels113913983be_vels
bevors111610343bevo_rs
bewails1277553bewails
beworms1437933beworms
beyonds1335063beyonds
bezels173712283be_zels
bezils1711310603be_zils
bezoars1836793bezoars
bifocals1543703bifocals
bifold1237223bifo_ld
bijous1548043bijou_s
biofuels1342923biofuels
boils75427193b__oils
bolls75531313b__olls
bolus79125543b__olus
boule74828043b__oule
boules84925973b__oules
bouts75131313b__outs
bowls106121433b__owls
boxfuls19113603boxfuls
broils84114173b_roils
bugouts1036193bugouts
bulbuls11346783bulbuls
buyouts1235203buyouts
ceorls848163ce_orls
cerous85821203cerou_s
default1147893default
defaults1243333defaults
defoams1336193defoams
defocus1335283defocus
defogs1156683defo_gs
deforms1337803deforms
defuels11296983defuels
detours858043detours
devours1166643devours
dewools1145593dewools
enols54718403_eno_ls
ensouls736033ensouls
eyefuls1343843eyef_uls
foals85721693__foals
foils85025813__foils
fools86824203__fools
foul77027583__foul_
fours85521493__fours
fowls115518893__fowls
ghouls1036043_ghouls
insouls737213insouls
jetfoils1842453jetfoils
ketols104210763keto_ls
meous76120063me_ou_s
metols84115773meto_ls
nerols6914883nero_ls
peafowls1642893peafowls
peepuls1134923peepuls
peyotls1233633peyotls
reboils94111723reboils
recoals94214623recoals
recoils93814873recoils
recoups1188843recoups
redouts81411663redouts
refalls103312243refalls
refeels10379693refeels
refels94618053ref_els
refills103711423refills
refocus1236973refocus
refold103812113refo_ld
refolds11298953refolds
reforms1239823reforms
refound1157413refound
refounds1255733refounds
refuels10399523refuels
reoils64516873re_oils
repolls939053repolls
repours9310233repours
rerolls739943rerolls
retools73411023retools
rufous948273rufou_s
seafowls1443663seafowls
serous65023563serou_s
setous64917373setou_s
setouts74110333setouts
souls55127363__souls
tenours72610073tenours
trefoils1145303trefoils
velours10278083velours
venous93713193venou_s

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 Limit1340271566.50020619.5
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.96925640.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.