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

161 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
buttress103588(None) 
butterless1244192butterless
butters94521722butt_ers
buttes84822562butt_e_s
butties93217952buttie_s
buttressed1343982buttressed
buttresses1245662buttresses
huntress1144832huntress
mattress1036532mattress
outdress9137322outdress
outpress10118182outpress
tutoress845092tutoress
abutters1056993abutt_ers
actress948533_actress
adultress1042943adultress
authoress1245173authoress
bathless13127383bathless
battens95313263batt_ens
batterers113110713batterers
batters94626013batt_ers
battiest104115553battiest
battiness11239843battiness
battlers104110973battlers
battles94517683battle_s
battues94610193battue_s
beatless103311593beatless
beltless10297713beltless
bestrews1335603bestrews
betters94422093bett_ers
bistres94017213bistre_s
bitterest1147713bitterest
bitterness1245553bitterness
bitterns10428953bitterns
bitters94920363bitt_ers
bittiest103012043bittiest
bittiness11228333bittiness
blotless10347153blotless
bluntness1144343bluntness
boltless10338283boltless
bootless103410983bootless
bottlers103810013bottlers
bottles94216273bottle_s
bourtrees11154013bourtrees
budless1038873bu_dless
bunters94717123bunt_ers
burets84321263bu__rets
burgess10409343bu_rgess
burrers93814493bu_rrers
burses84425513bu__rses
burthens1335383burthens
bushless1335813bushless
business102110693business
busters94724133bust_ers
bustiers103810053bustiers
bustiest102815053bustiest
bustiness111810473bustiness
bustlers104210613bustlers
bustles93816323bustle_s
busyness13264813busyness
butanes9312743butane_s
butchers153710183butchers
butches144315363butche_s
butchness1643453butchness
butenes9313033butene_s
buteos84913413bu_t_eos
butes714535873bu_t_e_s
butlers94518053bu_tlers
butles84423913bu_tle_s
buttals938503butt_als
butte74924293butt_e__
butted94722063butt_e_d
butter84724233butt_e_r
buttered112712623buttered
butteries11711763butteries
butteriest1276883butteriest
buttery124311193butt_ery
butthead1454513butthead
buttheads1553903buttheads
buttocks1645233buttocks
buttoners1145703buttoners
buttonless1242963buttonless
buttons9310333butt_ons
buttressing1453053buttressing
butts75824253butt___s
butyrals1344503butyrals
butyrins1345423butyrins
butyrous1345443butyrous
butyryls1641873butyryls
cateress102311613cateress
curtness1037263curtness
cuteness1039673cuteness
cutgrass1144343cutgrass
cutters94218963cutt_ers
cutties93118843cuttie_s
cuttles93613923cuttle_s
distress9311713distress
dottrels963493dottrels
ductless11196313ductless
duress74712063du__ress
dustless9328353dustless
editress944933editress
fortress1136753fortress
futures10310263future_s
gumtrees1143883gumtrees
gustless9287683gustless
gutless82610713gu_tless
gutters83715513gutt_ers
guttiest92311223guttiest
guttlers9306933guttlers
guttles83011933guttle_s
hotpress1344303hotpress
hurtless11307783hurtless
justness1535323justness
jutties143814003juttie_s
lustres73013233lustre_s
mattrass1045863mattrass
mistress10310703mistress
muteness1039013muteness
mutterers11247373mutterers
mutters94117143mutt_ers
nutgrass943933nutgrass
nutters74215433nutt_ers
nuttiest82312143nuttiest
nuttiness9207563nuttiness
oratress834553oratress
outbless1037963outbless
outcross1036823outcross
outgross936423outgross
outguess944983outguess
outtrots838373outtrots
portress1038323portress
puttees93612913putt_ees
putterers11238363putterers
putters94219193putt_ers
puttiers10288013puttiers
putties94420023puttie_s
puttyless1442013puttyless
quatres163411933quatre_s
restress82511773restress
rustless83510243rustless
ruthless1135413ruthless
ruttiest82712663ruttiest
ruttiness9258793ruttiness
stress66616673__stress
sundress936983sundress
suppress1236443suppress
suttees74114063sutt_ees
sutures7314223suture_s
tress55423163___tress
tutties73216473tuttie_s
undress838893_undress
unstress837373unstress
untruss736553_untruss
utterers8218653_utterers
utterness946223_utterness
utters63817123_utt_ers
victress1344523victress
votaress1144223votaress
votress1035483_votress
waitress1135223waitress
wattless11268723wattless

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.1561145455.1
2DLD Change Limit1461621617.31319986.6
3Display Results1611610.0602683.3
 (SQL Overall)1786911617.52923733.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.