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

427 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
boccies13331151(None) 
bocces123912021bocc_es
boccias13307191boccias
boccie123311451boccie_
boccis123911131bocci_s
bobbies103714562bobbies
bocce114313112bocc_e_
bocci113512712bocci__
boccia12338792bocci_a
boches134618522bo_ches
bodices12710592bodices
bodies94524142bo_dies
bogies94724312bo_gies
boobies113718202boobies
boodies103721442boodies
boogies103719012boogies
bookies133819402bookies
boonies93422482boonies
booties94124612booties
bossies94116832bossies
botches143716022botches
bothies12414782bothies
boucles113113002boucles
bougies103715182bougies
coccids11277212coccids
abbacies1445483abbacies
abbotcies1542623abbotcies
babies106123653b_abies
baccae12119703baccae_
bacchius1744713bacchius
baches135426943b_aches
baddies114017873baddies
baffies153612943baffies
baggies113814853baggies
bailies94120203bailies
baldies105317703baldies
ballies93725743ballies
bandies104124863bandies
banties94324763banties
barbies114519593barbies
batches144019613batches
bawdies134613393bawdies
bawties124214313bawties
beaches144120653beaches
beanies93821093beanies
becomes132911963becomes
becrimes1467073becrimes
beeches143413883beeches
beedies10314203beedies
belches143514343belches
belies84631053b_elies
bellies94023723bellies
benches143918603benches
bennies93917313bennies
berries94423553berries
bevies114017303b_evies
bialies93618413bialies
bices95029963b_ic_es
bicycles1743883bicycles
biddies113514493biddies
biffies152710853biffies
biggies113813523biggies
bikies124515163b_ikies
bilbies114712343bilbies
billies93923503billies
biochips1744843biochips
biocides1336933biocides
biocycles1843523biocycles
biopsies1237383biopsies
birches143412323birches
birdies104016213birdies
birkies133712433birkies
bitches144117063bitches
blockier1666133blockier
blockiest1736363blockiest
bloodies11310163bloodies
blotches1537433blotches
bobbins103410343bobbins
bobbles104514913bobbles
bobcats1335993bobcats
bobeches1744483bobeches
bocaccios1451763bocaccios
boche124216953bo_che_
bocks134526573bo_c_ks
bodes84935103bo__des
bodice11711423bodice_
bodied103814583bo_died
bodkins1438313bodkins
boffins15329073boffins
boggier113711583boggier
boggiest123110933boggiest
boggles113411823boggles
bogie89524103bo_gie_
bogles95020833bo_gles
boils75427193bo__ils
boites84322703bo_ites
bolases93315003bolases
boles75448603bo__les
boletes9316063boletes
bolides10515073bolides
bollixes1747203bollixes
bolshies1338693bolshies
boluses94113833boluses
bombes124916823bo_mbes
bonacis11310323bonaci_s
bones76446533bo__nes
bonfires1367383bonfires
bongoes104314113bongoes
bonier84321993bo_nier
boniest93318993bo_niest
bonnes85621453bo_nnes
bonnie85314853bonnie_
bonnier94711313bonnier
bonniest10310773bonniest
bonuses94212953bonuses
bonzes175116103bo_nzes
boobie104015293boobie_
boocoos1137753boocoos
boodles103416043boodles
boogie93515993boogie_
boogied11379283boogied
bookie123516003bookie_
boomier113312183boomier
boomiest122711843boomiest
bootees94114473bootees
bootie85421163bootie_
boozes174916523bo_ozes
boozier18349013boozier
booziest19379263booziest
boraces113716853boraces
boracites1347953boracites
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
bores76448253bo__res
borides10515153borides
bornites10310983bornites
borsches1536003borsches
bortzes1838223bortzes
boscages1366643boscages
boshes114721883bo_shes
boskier13309173boskier
boskiest14289733boskiest
bosques18217973bosques
bosses85925403bo_sses
bossier93712423bossier
bossiest103112213bossiest
botanies10312853botanies
botched153611903botched
botcher143613223botcher
botchers153511543botchers
botchier15287143botchier
botchiest1636153botchiest
botflies1336733botflies
bottles94216273bottles
bouchee143313543bouchee
bouchees15339533bouchees
boucle103712783boucle_
boudins10311313boudins
bouffes15388633bouffes
bougie93613273bougie_
boules84925973bo_ules
boulles93114123boulles
bounces113813683bounces
bouncier1236033bouncier
bounciest1346433bounciest
bounties10311403bounties
bournes93615023bournes
bourses94014303bourses
bouses84931783bo_uses
bouvier1277433bouvier
bouviers1375003bouviers
bovids1287973bo_vids
bovines12412663bovines
boweries13312293boweries
bowfins15267703bowfins
bowlines133211623bowlines
bowses115718863bo_wses
boxcars1834773boxcars
boxes145625073bo__xes
boxier154311743bo_xier
boxiest163711983bo_xiest
boychiks2242933boychiks
braces108427773brac_es
braches144621223braches
braxies16711463braxies
breccias1444143breccias
bries74942153b__ries
brinies93317913brinies
broaches153211623broaches
brocades1358713brocades
brollies1039533brollies
brooches15288193brooches
brookies1459143brookies
brownies13189613brownies
brucines1237763brucines
brucins1158003brucins
bubbies103913513bubbies
buckles153416093buckles
buckoes153810393buckoes
buddies113914353buddies
budgies115312513budgies
buggies114613813buggies
bullies94121893bullies
bunches144116033bunches
bunnies94415003bunnies
buppies133011063buppies
burdies104117563burdies
buries84633273b_uries
burnies94017823burnies
busbies113011693busbies
busies85525263b_usies
butches144315363butches
butties93217953butties
byrnies12378573byrnies
coaches144018693coaches
cocaines121314443cocaines
cocains111313923cocains
cocci82812673cocci__
coccic8298943cocci_c
coccid102910743cocci_d
coccoids12176793coccoids
coccous1039003coccous
coccus979283cocc_us
coccyges1542333coccyges
coccyxes2142013coccyxes
cochins141413103cochins
cockier154013623cockier
cockiest163013293cockiest
cockles153414643cockles
codices12512583codices
colies84837053co_lies
collies94326583collies
commies133718453commies
conches144019813conches
conchies153214853conchies
concise11314473concise
conies84338593co_nies
cooches143515833cooches
cookies133719273cookies
coolies93824963coolies
cooties93725733cooties
copies104130303co_pies
corbies113520123corbies
corries94026793corries
cosies84932153co_sies
couches144020473couches
cowpies143314283cowpies
cowries124218013cowries
cozies174521413co_zies
cries75438403__cries
decries103319803decries
dickies143416343dickies
dioecies1138933dioecies
dobbies124113063dobbies
dobies94422093do_bies
doggies103613023doggies
dogies85022253do_gies
doilies84017363doilies
dollies83620983dollies
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dories75232363do_ries
douches134315233douches
dowdies123412733dowdies
dowries114413983dowries
doxies143917853do_xies
doylies114512573doylies
duchies133312313duchies
duckies143613813duckies
ebonies9312883ebo_nies
ecocides1346583ecocides
facies113921593_facies
fancies124018783fancies
farcies125317883farcies
focuses12159653focuses
fogies104118063fo_gies
folkies143612253folkies
follies103618943follies
foodies113416753foodies
footies103721543footies
forces114422133forc_es
forcipes1535943forcipes
forties104323863forties
goalies8316023goalies
gobies95418063go_bies
goodies93516993goodies
goonies83618333goonies
hackies163418243hackies
hickies163614743hickies
hoagies112811993hoagies
hobbies143813343hobbies
hocuses121710423hocuses
hogties112813993hogties
holies94630033ho_lies
hollies103420813hollies
homies114524723ho_mies
hongies112716473hongies
honkies143015143honkies
hooches153812523hooches
hoochies1639603hoochies
hoodies113419833hoodies
hookies144017443hookies
hotches153814363hotches
hotties103016963hotties
howdies142911953howdies
jackies202912623jackies
jollies143516273jollies
koppies153210013koppies
loaches123613983loaches
lobbies113612463lobbies
locales93715093locales
locates93218813locates
locoes85516583lo_coes
locules92812603locules
lollies73116923lollies
longies82916553longies
loobies93814103loobies
looies65025833lo_oies
loonies73919543loonies
lories64933043lo_ries
lorries74518343lorries
louies64525103lo_uies
luckies133313683luckies
mercies113817563mercies
moggies113111723moggies
molies84429513mo_lies
mollies93420233mollies
mommies103912273mommies
monies83233163mo_nies
mooches143714453mooches
mouches143815963mouches
movies115118453mo_vies
moxies154317403mo_xies
nancies93516843nancies
noddies93512043noddies
nonces84418833nonc_es
noogies82814583noogies
nookies113414963nookies
notches123513653notches
notices9312283notices
novices1238223novices
occupies1444223_occupies
occurs10136553_occurs
ochres113510833_ochres
oldies7314423_oldies
oocytes1246063oocytes
orcins83313433_orcins
orgies72316093_orgies
oscines9310363_oscines
ouches114322183_ouches
poaches144416943poaches
pockier153911603pockier
pockiest163412053pockiest
poesies93217403poesies
pogies94123543po_gies
pokies125921333po_kies
polices113118053polices
policies122415663policies
polies84034583po_lies
pommies133712843pommies
ponces104720843ponc_es
ponies84833463po_nies
pooches143214163pooches
poppies102816193poppies
popsies112816463popsies
porches143815673porches
porgies103017003porgies
porkies133416493porkies
posies84431433po_sies
posties93128813posties
potpies113116173potpies
potsies93019483potsies
potties93723543potties
pouches144116743pouches
recces10614913recc_es
roaches123616213roaches
roadies83317443roadies
rockier134911883rockier
rockiest142912223rockiest
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
roscoes9310923roscoes
rotches123515703rotches
rouches124217893rouches
rowdies113112693rowdies
scries85226823_scries
sickies133717503sickies
socages101012053socages
soccages1336383soccages
soccer1038543socc_er
soccers1138393soccers
socles8418453so_cles
soddies92312853soddies
softies103414613softies
sonnies7315223sonnies
sophies12314613sophies
sorties74126403sorties
species11314133species
techies12513603techies
toadies82914863toadies
tobies84521023to_bies
tocsins939963tocsins
toddies93011993toddies
todies74223553to_dies
toffies133210213toffies
tommies113812983tommies
toonies73719883toonies
torches123715433torches
tories65435883to_ries
touches125118343touches
towies93521193to_wies
townies103113623townies
vaccines1536503vaccines
vichies15310623vichies
voces105918053vo_c_es
voices114414013voic_es
vouches153914113vouches
woodies113517153woodies
woolies104117363woolies
worries104117133worries
yowies123913733yo_wies
zombies2037993zombies

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274276.78319759.3
3Display Results4274270.1403050.0
 (SQL Overall)1786914277.07925242.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.