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

408 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
brothers13341083(None) 
bothers124317751b_others
brothels13277071brothels
brother123311331brother_
frothers14279811frothers
bathers124720362b_athers
blathers134713792blathers
blethers13429612blethers
blithers134711232blithers
blotters104110982blotters
botchers153511542b_otchers
bother115218062b_other_
breathers14319102breathers
broachers16328152broachers
broiders114211192broiders
broilers103210092broilers
brokers133111912bro_kers
bronzers19296982bronzers
brooders112610242brooders
brothel12318192brothe_l
brothered1546002brothered
brotherly1743792brotherly
broths115013922broth__s
browsers13449202browsers
brushers134210572brushers
druthers1275792druthers
frother133110152frother_
mothers123717622_mothers
northers1139332northers
others93918002__others
pothers123818622_pothers
rotters74421392_rotters
smothers13349932smothers
soothers113913432soothers
trotters83310242trotters
writhers14398982writhers
aborters1038573abort_ers
aethers103614943_aethers
another10289153another_
anthers103715203_anthers
apothems1544223apothems
archers124414573ar_chers
arousers84810983arousers
baiters94619303bait_ers
banters94623113bant_ers
baratheas1444923baratheas
barters94223033bart_ers
bashers124820833b_ashers
basters94930303bast_ers
batchers153613273batchers
bather115322513b_ather_
bathes116524833b_athe_s
batters94626013b_atters
battlers104110973battlers
beaters94925043beat_ers
beetlers1037393beetlers
belchers153510023belchers
belters93819413belt_ers
benchers153611013benchers
bethels1238533b_ethels
betrotheds1652503betrotheds
betters94422093b_etters
bioherm1434653bio_herm
bioherms1544213bio_herms
bisters93922613bist_ers
biters83925243b_it_ers
bitters94920363b_itters
blather125314203blather_
blatters104414093blatters
blether12459913blether_
blither124812173blither_
blitzers19417153blitzers
bloaters103311023bloaters
blockers16398793blockers
bloggers12397403bloggers
bloomers12348823bloomers
bloopers12397373bloopers
blotches1537433blotche_s
blotless10347153blotless
blotter94612853blotter_
blowers124313593blo_wers
bluchers15359033bluchers
blushers133911293blushers
boaters93419243b_oaters
bobbers103614283b_obbers
boches134618523b_oche_s
boheas114013213b_o_heas
boilers93417063b_oilers
bolters94017803b_olters
bombers134512593b_ombers
bonders104120663b_onders
boners84825433b_o_ners
bonkers134015303b_onkers
boodlers113710743boodlers
boogers104514633b_oogers
bookers134016613b_ookers
boomers114115913b_oomers
boosters104013443boosters
bootees94114473boot_ees
bootery1238983boot_ery
booths115313793booth__s
booties94124613bootie_s
bootlegs11325873bootlegs
bootless103410983bootless
boozers183912443b_oozers
boppers133911923b_oppers
borders104317533b_orders
borers85122683b_o_rers
bortzes1838223bortze_s
boshes114721883b_oshe_s
botcher143613223b_otcher_
botchery18366763b_otchery
botches143716023b_otche_s
botels84815803b_ot_els
bothered142110393b_othered
bothies12414783b_othies
bottlers103810013bottlers
bowers115523703b_o_wers
bowlers123715783b_owlers
bowyers15438733b_owyers
boxers155013483b_o_xers
bracers114616703br_acers
braches144621223brache_s
brachets154311983brachets
braggers12327903braggers
braiders114110573braiders
branders114313093branders
branners104010923branners
brasher124515243brasher_
brashes124518463brashe_s
brasiers103710513brasiers
bravers124715523br_avers
brawlers13408643brawlers
brayers124511903br_ayers
brazers184513943br_azers
braziers19397193braziers
breachers16369853breachers
breakers143810973breakers
breather133610593breather_
breathes134212903breathe_s
breeders11368893breeders
brethren1343783brethren
breviers1335923breviers
brewers123811053br_ewers
bribers114111493br_ibers
bridlers11359183bridlers
briefers1335143briefers
briers85319733br__iers
brimmers14287073brimmers
briners94315633br_iners
bringers112811073bringers
brioches15227253brioche_s
britches15278683britche_s
briths115113863brith__s
broacher15329263broacher_
broaches153211623broache_s
broadens11267243broadens
broader103412613broader_
broche133612103broche__
brochure1544353brochure
brochures1644413brochures
brockets16328123brockets
broguery1443313broguery
brogues10719823brogue_s
broider103912973broider_
broidery14356083broidery
broiler92911753broiler_
broker124314243bro_ker_
bromes104719763bro_me_s
bronzer18348493bronzer_
bronzes183510403bronze_s
brooches15288193brooche_s
brooder103811623brooder_
broses86524403bro_se_s
broth106521093broth___
brothering1646033brothering
brothy14519623broth__y
browless1346653browless
browner124911643browner_
browser124911143browser_
browses124712693browse_s
bruisers10307953bruisers
bruiters10329143bruiters
brunchers16296253brunchers
brusher123813003brusher_
brushes124014663brushe_s
brutes86118683brut_e_s
bunters94717123bunt_ers
burghers1435633burghers
bursters1038983burst_ers
burthens1335383burthens
bushers124018803b_ushers
busters94724133bust_ers
bustiers103810053bustiers
bustlers104210613bustlers
butchers153710183butchers
butlers94518053b_utlers
butters94521723b_utters
cithers124315773_cithers
clothes124513813clothe_s
clothiers1443423clothiers
cooters94525723coot_ers
coshers123618183_coshers
cotters94323443_cotters
crashers134013233crashers
craters95021893crat_ers
critters103511323critters
croakers14288523croakers
crochets15359833crochets
crofters13358903crofters
crooners103911393crooners
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
crotches153411303crotche_s
crotchets16396303crotchets
crowders14398803crowders
crowers124614893cro_wers
crowners133710743crowners
crozers184111083cro_zers
croziers19287003croziers
crushers134010093crushers
diethers1257453diethers
dithers114016153_dithers
doters74423913_dot_ers
dotters83715973_dotters
droners84114383dro_ners
droppers13318603droppers
drovers115212643dro_vers
drowners12428273drowners
emoters94712873emot_ers
ethers94518413__ethers
fathers133916503_fathers
feathers143513243feathers
footers104618333foot_ers
footlers113910793footlers
fraters103517213frat_ers
fretters113410303fretters
fritters113810783fritters
frontiers1254993frontiers
frothed14288783frothe_d
frothier1435953frothier_
froths125411443froth__s
frotteurs1242223frotteurs
frowners14377933frowners
furthers1436493furthers
garotters1055033garotters
gathers114315073_gathers
gophers1338983_gophers
graters85419743grat_ers
gritters94210633gritters
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grossers94410973grossers
groupers11358643groupers
grousers93810733grousers
grouters95910083grouters
growers113612723gro_wers
growlers12327093growlers
heathers143914733heathers
hooters104520473hoot_ers
ironers74813553iro_ners
isothere1145793isothere
isotheres1246333isotheres
isotherm1344283isotherm
isotherms1444083isotherms
joshers174111593_joshers
jotters143413803_jotters
knotters12276153knotters
koshers144811803_koshers
kraters114212343krat_ers
lathers104321883_lathers
leathers114215083leathers
loathers113310443loathers
looters74419163loot_ers
lotters73921063_lotters
mithers123516733_mithers
moochers15369123moochers
mooters93818623moot_ers
moshers124017843_moshers
mother113718643_mother_
mothery153710513_mothery
mouthers133811303mouthers
murthers1336543murthers
norther1039733norther_
northern1145583northern
northerns1244933northerns
noshers103614333_noshers
notchers13279423_notchers
noters64021003_not_ers
nother93815963_nother_
ochers113915303__ochers
other84219103__other_
otters64021513__otters
panthers13510783panthers
plotters104011553plotters
porters93722703port_ers
pother113818853_pother_
potherb14358683_potherb
potherbs15387123_potherbs
potters94024343_potters
potzers184010543_potzers
praters94921653prat_ers
probers113514583pro_bers
prodders1237463prodders
proffers16126593proffers
proggers12258163proggers
proofers13118363proofers
propers113619033pro_pers
prophets1539503prophets
prosers94219643pro_sers
prospers123012263prospers
proteas92015123prot_eas
proteus92511593prot_eus
protheses1449073protheses
prothesis1449433prothesis
provers123817793pro_vers
prowlers13328933prowlers
quoters16369263quot_ers
rashers104020913_rashers
raters63936583_rat_ers
rather94319743_rather_
ratters74422473_ratters
rioters73615513riot_ers
ritters74020623_ritters
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
rochets124213473_rochets
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
rompers113412243_rompers
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
ropers84325903_ro_pers
rosters73727543_rosters
rotches123515703_rotche_s
rotes56143903_rot_e_s
rotifers1136043_rotifers
rotors64917953_rot_ors
rotter64325463_rotter_
rottes64524833_rotte_s
roughers12329183_roughers
rousers75220143_rousers
routers74822873_routers
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
rushers103816103_rushers
scoters93313813scot_ers
scouthers1445993scouthers
slathers113914783slathers
slithers114212953slithers
slotters84012403slotters
smithers13369793smithers
smoothers14206043smoothers
smother123510213smother_
smothery16296063smothery
soother104215043soother_
soothes103917113soothe_s
sorters74221133sort_ers
southers114214453southers
spotters104313383spotters
swathers144512083swathers
swithers144310533swithers
swotters11448483swotters
teethers11328713teethers
tethers103815313_tethers
tithers104216733_tithers
tochers123413093_tochers
tooters73818773toot_ers
tootlers8289503tootlers
toters65026363_tot_ers
tother94117143_tother_
totters74618733_totters
trashers113013643trashers
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
troffers14125433troffers
trollers83211213trollers
troopers10289443troopers
trothed114010973trothe_d
troths95414153troth__s
trotter73312253trotter_
troupers10359443troupers
trousers83910633trousers
trovers103713323tro_vers
trowsers11428003trowsers
ureters7311823uret_ers
voters95017443_vot_ers
weathers143412833weathers
wethers135214693_wethers
withers134417753_withers
wreathers15257493wreathers
writers105513493writ_ers
writher134010853writher_
writhes134811703writhe_s
wrongers12327773wrongers
wuthers133711523_wuthers
zithers193911973_zithers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461624088.40617387.8
3Display Results4084080.3261251.5
 (SQL Overall)1786914088.88820104.7
 
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.