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

204 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
beworms143792(None) 
beworm1339981beworm_
deworms1338021deworms
bagworms1645212bagworms
berms95323662be__rms
besoms105712732beso_ms
beswarms1544322beswarms
bevors111610342bevor_s
bewares12313372bewares
bewormed16235442bewormed
beworry1543742beworry
budworms1644322budworms
bywords1634282bywords
byworks1944542byworks
deforms1337802deforms
deworm1249522deworm_
eelworms1344552eelworms
reforms1239812reforms
rewarms12439592rewarms
rewords115413972rewords
reworks145113592reworks
tubeworms1643492tubeworms
webworms1843752webworms
worms105320762__worms
bagworm1566343bagworm_
barms96128463b__arms
bazooms20285383bazooms
beadworks1945723beadworks
beams95328173be__ams
beards94116673be_ards
bears75739043be_ar_s
bebops1237623bebo_ps
becalms1335743becalms
becharms1745343becharms
become123312593beco_me
becomes132911963becomes
bedims1149593be_dims
bedlams1237053bedlams
bedrooms1345713bedrooms
bedsores1157633bedsores
bedwards1596393bedwards
bedwarfs17113583bedwarfs
beers75628393be_er_s
befogs1246453befo_gs
befools1236433befools
before11410153befor_e
befouls1236053befouls
begirds1134883begirds
beglooms1344273beglooms
begorah1355593begorah
begorra1043543begorra
begrims1276763begrims
begums11429493be_gums
beholds1336423beholds
behoves15177353behoves
behowls1534443behowls
beldams1237053beldams
bellworts1445373bellworts
belongs10408223belongs
belons84119413belo_ns
belows114614183belo_ws
bemires113212833bemires
bemoans1138253bemoans
bemocks1735373bemocks
bergs84718043be__rgs
berks115423123be__rks
berm86732753be__rm_
berme96022943be__rme
bermes106023003be__rmes
beseems1175913beseems
besom95716973beso_m_
besots86415453beso_ts
beswarm1445773beswarm_
bethorns1337323bethorns
betons84919553beto_ns
bettors93312473bettor_s
bevor101510813bevor__
bewails1277553bewails
beware11313713bewar_e
bewared13310113bewared
beweeps1494563beweeps
bewigs1246533bew_igs
beworming1734553beworming
beworries1444843beworries
bewrap13157053bew_rap
bewraps14135403bewraps
bewray14147733bew_ray
bewrays15145113bewrays
beyonds1335063beyonds
bezoars1836793bezoars
bicorns11338763bicorns
biform1368123biform_
blooms104613173b_looms
bollworms1643863bollworms
bookworms2044083bookworms
booms95427123b__ooms
boors74325013b_oor_s
boras75938303b__oras
bores76448253b__ores
borks115727703b__orks
borts76735453b__orts
bosoms104913053boso_ms
bowers115523703bower_s
brewers123811053brewer_s
brooms104915873b_rooms
budworm1545263budworm_
byword1535053bywor_d
bywork1834863bywor_k
caseworms1645063caseworms
celoms10412123celo_ms
ceorls848163ce_orls
corms95626223__corms
cutworms15184973cutworms
decors94017773decor_s
decorums1344993decorums
defoams1336193defoams
deform1259613deform_
degerms1135623degerms
dehorns11428363dehorns
dehorts11379773dehorts
deperms1236603deperms
deports105012883deports
derms85022893de__rms
desorbs10437713desorbs
dewars105117073dewar_s
dewools1145593dewools
dewormed15236223dewormed
dewormer14256323dewormer
dewormers15255193dewormers
dorms85723843__dorms
earworms1346773earworms
eelworm1245513eelworm_
enorm74415633_enorm_
ewers86018823_ewer_s
fedoras1137923fedoras
felworts1445953felworts
fetors91014473fetor_s
fireworms1745593fireworms
forms105327053__forms
gapeworms1743373gapeworms
genoms94412483geno_ms
germs85118873ge__rms
gorms85619593__gorms
herms105626433he__rms
hewers123715273hewer_s
informs1248073informs
keywords1944323keywords
leafworms1753613leafworms
legworks1645373legworks
lobworms1544483lobworms
lugworms1443893lugworms
mealworms1644443mealworms
megohms1592863megohms
networks1546143networks
newborns1343403newborns
norms76019313__norms
pelorus939273pelorus
performs1547483performs
perms95524513pe__rms
pinworms15115783pinworms
preforms1537393preforms
prewarms15406723prewarms
preworks17599003preworks
rearms85114653re_arms
rebores95319163rebores
records105213923records
recorks134813023recorks
reform11312703reform_
remoras9314073remoras
reports94916213reports
resorbs95010523resorbs
resorts74817193resorts
retorts76016513retorts
rewards114813993rewards
rewarm115913483rewarm_
rewires104717113rewires
reword106321403rewor_d
rewore938030153rewor_e
rework136619783rewor_k
reworn98122193rewor_n
senoras72714953senoras
senores73218113senores
senors63620783senor_s
sewars94018623sewar_s
sewers94719713sewer_s
storms85814633_storms
swarms116112173_swarms
swords104510803_swords
tapeworms1644233tapeworms
tenors63217753tenor_s
terms75523473te__rms
tubeworks1844233tubeworks
tubeworm1544203tubeworm_
venoms114211213veno_ms
warms107726853__warms
waxworms2393673waxworms
webworks2044663webworks
webworm1744303webworm_
wireworms1745023wireworms
words95425073__words
works125621903__works
worm96129483__worm_
wormy137514253__wormy
worts88631183__worts

Search took 9 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.1561145455.1
2DLD Change Limit1340272048.18616372.7
3Display Results2042040.250816.0
 (SQL Overall)1786912048.59220797.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.