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

235 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
boweries1331229(None) 
doweries12411931doweries
bakeries14312192bakeries
bawdries14136842bawdries
bewearies1447012bewearies
bobberies12107892bobberies
boiseries11411042boiseries
booteries11312772booteries
bowered133113042bower_ed
bowering142911712bowering
bowers115523702bower__s
breweries1447582breweries
coteries10422702coteries
cowries124218012cow_ries
dowries114413982dow_ries
moperies12313872moperies
poperies12316792poperies
roperies10315762roperies
roseries8317312roseries
towerier1137122towerier
toweriest1246532toweriest
voleries11313232voleries
aeries64737783__aeries
amberies122514683amberies
aperies9423203_aperies
arteries8321483arteries
batteries11615113batteries
bawdies134613393baw_dies
bawdrics16153273bawdrics
bawties124214313baw_ties
beaneries11310903beaneries
beedies10314203b_eedies
beerier93613023b_eerier
beeriest104013403b_eeriest
belfries1336983belfries
belies84631053b__elies
berimes115216643b__erimes
bermes106023003b__ermes
berries94423553b_erries
bevies114017303b__evies
bewares12313373bewar_es
bewearied1544203bewearied
beworries1444843beworries
bibberies1297133bibberies
binaries10314183binaries
binderies12311683binderies
biogenies1248513biogenies
biometries1448933biometries
bloomeries1446103bloomeries
blowers124313593blower__s
blowflies1742893blowflies
bobbies103714563bo_bbies
bobeches1744483bobeches
boccies133311513bo_ccies
bodies94524143bo__dies
bogies94724313bo__gies
bohemias1545983bohemias
boiserie1047993boiserie_
boleros9310293boler_os
boletes9316063bole_tes
bolshies1338693bolshies
boners84825433boner__s
bonfires1367383bonfires
boobies113718203bo_obies
boodies103721443bo_odies
boogies103719013bo_ogies
bookies133819403bo_okies
boonies93422483bo_onies
booties94124613bo_oties
boreases10310253boreases
borers85122683borer__s
bores76448253bo__r_es
borides10515153bo__rides
bossies94116833bo_ssies
botanies10312853botanies
botcheries1746053botcheries
botflies1336733botflies
bothies12414783bo_thies
bougies103715183bo_ugies
bounties10311403bounties
bournes93615023bo_urnes
bourrees10127643bourrees
bourrides1244823bourrides
bourses94014303bo_urses
bowdlerise1652603bowdlerise
bowdlerises1752253bowdlerises
bowdlerizes2652353bowdlerizes
boweled132810693bowe_led
boweling143410683boweling
bowelled1446183bowelled
bowelless1443833bowelless
bowels114315593bowe__ls
bower107328183bower___
bowerbird1752083bowerbird
bowerbirds1851453bowerbirds
bowery146012113bower__y
bowfins15267703bow_fins
bowlers123715783bowler__s
bowlines133211623bowlines
bowses115718863bow__ses
bowsprits1642153bowsprits
bowyers15438733bowyer__s
boxberries2143803boxberries
boxers155013483boxer__s
braveries1439103braveries
briberies1348333briberies
bries74942153b___ries
brogueries1344813brogueries
broideries1346353broideries
brownies13189613brow_nies
buggeries1347083buggeries
buries84633273b__uries
butleries11710073butleries
butteries11711763butteries
celeries10316313celeries
clowneries1544743clowneries
coderives1547483coderives
coerces11311943co_erces
coheres122917693coher_es
comedies13311843comedies
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
corries94026793co_rries
coterie9417403coterie_
covaries13413253covaries
cowberries1744623cowberries
cowered133214653cower_ed
cowering142514033cowering
cowers114625533cower__s
cowpies143314283cow_pies
cowrie113814283cow_rie_
cowrites133011593cow_rites
dodgeries1246593dodgeries
doggeries1246673doggeries
dolerites101410893dolerites
dories75232363do__ries
dovekies16115003dovekies
dowdies123412733dow_dies
dowered122811553dower_ed
dowering132510613dowering
dowerless1344013dowerless
dowers104523293dower__s
duperies11312813duperies
eateries8324313eateries
emeries91620023_emeries
emperies12314563emperies
faeries104118993_faeries
fakeries1559833fakeries
fineries112416743fineries
flowerier1544273flowerier
floweriest1644533floweriest
fooleries1248743fooleries
fopperies1666013fopperies
forgeries13310003forgeries
gomerils1146793gomerils
groceries1249503groceries
hosieries1249213hosieries
howdies142911953how_dies
japeries17311463japeries
jewelries1943033jewelries
jobberies20115423jobberies
joineries1648103joineries
liveries11314373liveries
lories64933043lo__ries
lorries74518343lo_rries
lotteries9311073lotteries
lovelies1139893lovelies
lowered112711913lower_ed
lowering122210913lowering
lowers94624923lower__s
miseries10320403miseries
mockeries17128263mockeries
modernes1138423modernes
moieties10311263moieties
monkeries15129913monkeries
mowers113219403mower__s
naboberies1443263naboberies
naperies10313903naperies
niteries8318383niteries
notaries8314933notaries
nowheres1437513nowher_es
observes1346173observes
obverses1335803obverses
onerier7311613_onerier
oneriest8313443_oneriest
oogenies9311583oogenies
orreries8310123orreries
ovaries10312653_ovaries
overlies112417043_overlies
peeries93623023_peeries
pineries102419083pineries
poesies93217403po_esies
poetries10315583poetries
potteries11313593potteries
poverties1439513poverties
powered132911643power_ed
powering142210803powering
powerless1444293powerless
powers113822323power__s
queries16315873_queries
reveries112518513reveries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
rosaries8312783rosaries
rotaries8315693rotaries
rowdies113112693row_dies
rowers94924573rower__s
ruderies9311333ruderies
series64540973__series
soberizes2098963soberizes
sorceries1149933sorceries
sowers94923443sower__s
swerves1377533_swerves
tawdries12136083tawdries
toggeries1146213toggeries
tories65435883to__ries
towered112911403tower_ed
towering122610873towering
towers94423673tower__s
towies93521193tow__ies
townies103113623tow_nies
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
votaries11312013votaries
vowelizes2443933vowelizes
vowers124317183vower__s
wearies103020223__wearies
wineries112316533wineries
worries104117133wo_rries
wries85827743__w_ries
yowies123913733yow__ies

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622356.86021306.4
3Display Results2352350.1102136.4
 (SQL Overall)1786912357.39024180.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.