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 “buttoners” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
buttoners114570(None) 
buttoner1036971buttoner_
batteners11238162batteners
bottomers1344352bottomers
butters94521722butt__ers
buttoned1137502buttone_d
buttonless1242962buttonless
buttons9310332button__s
outtowers1244762outtowers
abutters1056993abutt__ers
actioners1147723actioners
atoners75013953__atoners
battener10369393battener_
batterers113110713batterers
batters94626013batt__ers
battiness11239843battiness
battlers104110973batt_lers
beckoners1744063beckoners
bestowers14135323bestowers
betters94422093bett__ers
bettors93312473betto__rs
bitters94920363bitt__ers
bittiness11228333bittiness
blazoners2043863blazoners
boners84825433b___oners
bottlers103810013bott_lers
bottomer1245103bottomer_
bunters94717123bunt__ers
burdeners1245063burdeners
burgonets1243513burgonets
burners94115673bu__rners
burrowers1483493burrowers
burstones1187153burstone_s
burtons9310853burton__s
busters94724133bust__ers
bustiers103810053bust_iers
bustiness111810473bustiness
bustlers104210613bust_lers
butanes9312743bu_tane_s
butanones1144713butanone_s
butchers153710183bu_tchers
butchness1643453butchness
butenes9313033bu_tene_s
butlers94518053bu_t_lers
butter84724233butt__er_
buttery124311193butt__ery
buttes84822563butt__e_s
butties93217953butt_ie_s
buttocks1645233butto_cks
button8310273button___
buttonbush1751563buttonbush
buttonholers1761353buttonholers
buttoning1246463buttoning
buttony1236173button__y
buttress1035883butt_ress
cautioners1244713cautioners
customers1344783customers
cutovers1335123cu_tovers
cutters94218963cutt__ers
duotones937643duotone_s
fatteners12236873fatteners
gutters83715513gutt__ers
guttlers9306933gutt_lers
intoners889933_intoners
motioners1146573motioners
mutterers11247373mutterers
mutters94117143mutt__ers
muttons949283mutton__s
nutters74215433nutt__ers
nuttiness9207563nuttiness
outdoers937513outdo_ers
outhomers1446063outhomers
outliners9228363outliners
outpowers1445193outpowers
outtower1136193outtower_
putterers11238363putterers
putters94219193putt__ers
puttiers10288013putt_iers
ratooners965833ratooners
ratteners9237263ratteners
ruttiness9258793ruttiness
stoners74817953__stoners
subtones10311383subtone_s
summoners1344733summoners
tattooers943633tattooers
toners64128003___toners
tutoyers1133303tu_toyers
uptowners1441933_uptowners
utterers8218653_utterers
utters63817123_utt__ers
wantoners12116673wantoners

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit148641916.00024773.5
3Display Results91910.0332757.6
 (SQL Overall)178691916.45327691.2
 
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.