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

252 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
beworm133999(None) 
beworms1437931beworms
deworm1249531deworm
bagworm1566352bagworm
before11410152before
berm86732752be__rm
besom95716972beso_m
beswarm1445782beswarm
bevor101510812bevor_
bevors111610342bevors
beware11313712beware
bewormed16235442bewormed
beworry1543742beworry
biform1368122biform
budworm1545272budworm
byword1535052byword
bywork1834862bywork
deform1259622deform
deworms1338032deworms
eelworm1245522eelworm
enorm74415642_enorm
reform11312712reform
rewarm115913492rewarm
reword106321412reword
rewore938030162rewore
rework136619792rework
reworn98122202reworn
tubeworm1544212tubeworm
webworm1744312webworm
worm96129492__worm
aswarm11107913aswarm
bagworms1645213bagworms
barm86739603b__arm
bawdry15516463bawdry
beadwork1846033beadwork
beam86939233be__am
bear66844643be_ar_
beard86024963be_ard
bears75739043be_ars
bebop11410793bebo_p
bebops1237623bebops
becalm1239203becalm
becharm1636843becharm
become123312593become
bedim10313833be_dim
bedlam1149273bedlam
bedroom1247083bedroom
bedsore1057803bedsore
bedward1497473bedward
bedwarf16106463bedwarf
beer65635993be_er_
beers75628393be_ers
beery105220123be_ery
befog1159013befo_g
befogs1246453befogs
befool1137713befool
befoul1137253befoul
begird1036823begird
begirt9412683begirt
begloom1255243begloom
begone9512133begone
begorah1355593begorah
begorra1043543begorra
begot84625953bego_t
begrim11118333begrim
begum105213923be_gum
behold1247343behold
behoof1458683behoof
behove14207203behove
behowl1445533behowl
beldam11410113beldam
belfry1435073belfry
bellwort1348773bellwort
belon73924113belo_n
belong93411043belong
belons84119413belons
below104617193belo_w
belows114614183belows
bemire103312803bemire
bemoan10310253bemoan
bemock1636173bemock
berg75425543be__rg
berk105929843be__rk
berme96022943be__rme
berms95323663be__rms
berry104521773be_rry
beseem1069083beseem
besoms105712733besoms
besot76429713beso_t
besots86415453besots
beswarms1544323beswarms
bethorn1238643bethorn
beton76022063beto_n
betons84919553betons
betony114211583betony
betook12439603betook
bettor83612223bettor_
bettors93312473bettors
bewail1189583bewail
bewared13310113bewared
bewares12313373bewares
beweary1536223beweary
beweep13147253beweep
bewept13410323bewept
bewig1138903bew_ig
bewigs1246533bewigs
beworming1734553beworming
bewrap13157053bewrap
bewray14147733bewray
beyond1237073beyond
bezoar1736913bezoar
bezoars1836793bezoars
bicorn103610103bicorn
bloom95918973b_loom
bollworm1544813bollworm
bookworm1944543bookworm
boom87435673b__oom
boor66130683b_oor_
boors74325013b_oors
bora66141633b__ora
bore66051333b__ore
bork106933823b__ork
born67338413b__orn
bort65960963b__ort
bosom95516923boso_m
bower107328183bower_
bowers115523703bowers
bowery146012113bowery
brewer114812553brewer_
brewers123811063brewers
brewery15376963brewery
broom95022213b_room
budworms1644323budworms
buxom1647153buxo_m
bywords1634283bywords
byworks1944543byworks
caseworm1546163caseworm
celom9515693celo_m
ceorl7410923ce_orl
corm85735383__corm
cutworm14186353cutworm
decor84717573decor_
decors94017773decors
decorum1246943decorum
defoam1238563defoam
deforms1337803deforms
degerm1037893degerm
dehorn10439653dehorn
dehort104618103dehort
deiform1336693deiform
deperm1139363deperm
deport94922393deport
derm76031893de__rm
desorb95210203desorb
dewar95817733dewar_
dewars105117073dewars
dewool1047403dewool
dewormed15236223dewormed
dewormer14256323dewormer
dorm76834633__dorm
earworm1238743earworm
eelworms1344563eelworms
ewer77523983_ewer_
ewers86018823_ewers
fedora1038593fedora
felwort13410583felwort
femora1149583femora
fetor81214533fetor_
fetors91014473fetors
fewer115216123fewer_
fireworm1646693fireworm
form95836873__form
gapeworm1644003gapeworm
genom83716843geno_m
germ75428963ge__rm
gorm75529393__gorm
herm95636153he__rm
hewer115719933hewer_
hewers123715273hewers
inform11310153inform
keyword1844563keyword
leafworm1653913leafworm
legwork1545663legwork
lobworm1445253lobworm
lugworm1344903lugworm
mealworm1544623mealworm
megohm14124193megohm
memory1338803memory
network1446803network
newborn1244283newborn
newer85717463newer_
norm66429813__norm
perform1439283perform
perm85834633pe__rm
pinworm1467183pinworm
preform1439613preform
prewarm14479613prewarm
prework164210913prework
preworn124711223preworn
rearm75923573re_arm
rebore86625653rebore
reborn810016963reborn
record96117433record
recork126315493recork
reforms1239823reforms
remora8414593remora
report85326023report
resorb84914353resorb
resort65728623resort
retore67630773retore
retorn610923433retorn
retort66831153retort
reward106017643reward
rewarms12439603rewarms
rewire95421413rewire
rewoke1339521223rewoke
rewon86920583rewo_n
rewords115413983rewords
reworks145113603reworks
rewove126420083rewove
senor53822803senor_
senora63216163senora
senors63620793senors
sewar85421103sewar_
sewars94018633sewars
sewer84426223sewer_
sewers94719723sewers
storm76520403_storm
swarm106218843_swarm
sword95214123_sword
swore84920823_swore
sworn86115313_sworn
tapeworm1545103tapeworm
tenor53620253tenor_
tenors63217753tenors
term66233153te__rm
tubework1744743tubework
tubeworms1643503tubeworms
unworn93411333unworn
venom103914863veno_m
warm95935673__warm
waxworm2264573waxworm
webwork1944843webwork
webworms1843763webworms
wireworm1645893wireworm
word89832003__word
wore77144673__wore
work115528843__work
worms105320763__worms
wormy137514253__wormy
worn75631753__worn
wort76654753__wort

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.373479064.3
2DLD Change Limit1127162525.01622471.3
3Display Results2522520.0763315.8
 (SQL Overall)1786912525.46532697.3
 
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.