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

140 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
buttoned113750(None) 
buttoner1036971buttoner
battened11259572battened
bottomed1344672bottomed
butted94722062butt__ed
buttered112712622buttered
button8310272button__
buttoners1145702buttoners
buttons9310332button_s
buttony1236172button_y
cottoned1138032cottoned
rebuttoned1351962rebuttoned
unbuttoned1341992unbuttoned
abutted1056983abutt__ed
atoned75417543__atoned
attorned955363_attorned
attuned835173_attuned
auctioned1244953auctioned
authored1238263authored
autoed7712823au_to_ed
bastioned1246863bastioned
batted95623653batt__ed
battener10369393battener
battered113315053battered
battled104213123batt_led
beaconed1336983beaconed
beckoned1735783beckoned
bestowed14156623bestowed
bethorned1544443bethorned
betted94721163bett__ed
bettered113011843bettered
bitted94418483bitt__ed
bittered112711833bittered
blazoned2044313blazoned
boned85133243b___oned
botonee9311833b_otonee
bottled104611233bott_led
bottomer1245103bottomer
buboed113010003bu_bo_ed
buncoed12378443bunco_ed
bunkoed14356663bunko_ed
bunted95219183bunt__ed
buoyed1236693bu__oyed
burdened1236423burdened
burgeoned1343703burgeoned
burgonet1148103burgonet
burned95818963bu__rned
burrowed1444443burrowed
burstone1057133burstone_
burstones1187153burstones
burthened1543963burthened
burton8311273burton__
burtons9310853burton_s
buskined1534443buskined
busted95123153bust__ed
bustled104011523bust_led
butane8313653bu_tane_
butanes9312743bu_tanes
butanone1044963butanone_
butanones1144713butanones
butene8312623bu_tene_
butenes9313033bu_tenes
butled94818603bu_t_led
butte74924293butt__e_
butter84724233butt__er
buttes84822563butt__es
butthead1454513butthead
butties93217953butt_ies
butting103519283buttin_g
buttock1545563butto_ck
buttocks1645233buttocks
buttonholed1751673buttonholed
buttoning1246463buttoning
buttonless1242963buttonless
buttonwood1652053buttonwood
cantoned111411523cantoned
cartoned111312833cartoned
cautioned1245363cautioned
cuttled10319933cutt_led
dittoed936733ditto_ed
duotone836893duotone_
duotones937643duotones
fattened12268283fattened
guttated10266873guttated
gutted84716363gutt__ed
guttered10259163guttered
guttled9378993gutt_led
hutted104616333hutt__ed
intoned8811993_intoned
jutted144315023jutt__ed
juttied15417863jutt_ied
kittened1334523kittened
misbuttoned1651383misbuttoned
mittened1136363mittened
motioned1137453motioned
mutined103311353mu_tined
muttered112610793muttered
mutton8510453mutton__
muttons949283mutton_s
muttony1235323mutton_y
nutted74316973nutt__ed
optioned1146383optioned
outboxed1836873outboxed
outdone8311643outdone_
outfoxed1936013outfoxed
outgone8311463outgone_
outlined92512953outlined
outloved12248583outloved
outmoded12207703outmoded
outmoved14247283outmoved
outrowed1239433outrowed
outtold8107603outto_ld
outtower1136193outtower
outvoted1237273outvoted
pattened11299393pattened
putted94220253putt__ed
puttered112611143puttered
puttied103811163putt_ied
rationed9410093rationed
ratooned977103ratooned
rattened9218623rattened
rattooned1043843rattooned
rutted74518403rutt__ed
stoned75923143__stoned
subtone9310343subtone_
subtones10311383subtones
suctioned1245283suctioned
summoned1345723summoned
tattooed944573tattooed
toned65435343___toned
tutored837553tu_tored
tutoyed1133943tu_toyed
tutted75117443tutt__ed
unatoned939423unatoned
unboned103014223_unboned
unstoned9311043unstoned
untuned82010823_untuned
unzoned172310653_unzoned
uttered82712433_uttered
wantoned12117223wantoned

Search took 10 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 Limit1461621408.75016704.2
3Display Results1401400.0632222.2
 (SQL Overall)1786911409.23319353.5
 
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.