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

133 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
buttony123617(None) 
button8310271button_
buttons9310331buttons
muttony1235321muttony
betony114211582b_etony
burton8311272burton_
burtons9310852burtons
buttery124311192buttery
butting103519282butting
buttock1545562buttock
buttoned1137502buttoned
buttoner1036972buttoner
butty104020112butt__y
cottony1237252cottony
gluttony1242512gluttony
mutton8510452mutton_
muttons949282muttons
abutting1137003abutting
astony9510523_astony
atony87218853__atony
autonym1246633au_tonym
autotomy1345993autotomy
balcony1435853balcony
barony115915303b_arony
batboy1387533batbo_y
baton75822423b_aton_
batons85519423b_atons
batten85217123batten_
battens95313263battens
battery124911823battery
batting104422273batting
batty105422243batt__y
beton76022063b_eton_
betons84919553b_etons
betting103921403betting
bettor83612223betto_r
bettors93312473bettors
biltong1034683biltong
bitten84715123bitten_
bitting103717293bitting
bittock1544433bittock
bitty106119173bitt__y
bony96732083b___ony
boston8513043boston_
bostons9312903bostons
botany1139263b_otany
bottom1048723botto_m
bottomry1542043bottomry
bottoms1136993bottoms
bouton8311533bouton_
boutons9310783boutons
briony1149043b_riony
bryony1435833b_ryony
bunion83111313bunion_
bunions92210473bunions
bunny104715803bu__nny
bunting103718833bunting
buoy95921783bu__o_y
burstone1057133burstone
busboy13307443busbo_y
busting104221793busting
busty105621013bust__y
butane8313653bu_tane
butanol945433butanol
butanone1044963butanone
butene8312623bu_tene
buteo75419893buteo__
buteos84913413buteo_s
butlery12369423butlery
butling103516813butling
butt65143743butt___
buttals938503buttals
butte74924293butt__e
butted94722063butt_ed
butter84724233butt_er
butters94521723butters
buttes84822563butt_es
butties93217953butties
buttinsky1841133buttinsky
buttocks1645233buttocks
buttoners1145703buttoners
buttoning1246463buttoning
butts75824253butt__s
cotton8312993cotton_
cottons9312193cottons
custody1334093custody
cutting103817493cutting
cutty105417223cutt__y
dittany1135653dittany
duotone836893duotone
euphony1545403euphony
futon83113773fu_ton_
futons93911513fu_tons
futtock1644153futtock
glutton844893glutton_
gluttons944273gluttons
guttery11427763guttery
gutting93415923gutting
gutty94516993gutt__y
hutting113016033hutting
jetton1338033jetton_
jettons1437273jettons
jutting153313713jutting
jutty154914643jutt__y
mutiny113612683mu_tiny
muton73817003mu_ton_
mutons84314363mu_tons
nuttily10308633nuttily
nutting83316233nutting
nutty84816873nutt__y
outdone8311643outdone
outgone8311463outgone
outtold8107603outtold
puton73617913pu_ton_
putons83515153pu_tons
putting103218573putting
putto75617663putto__
putty104721403putt__y
ratton64116123ratton_
rattons73815323rattons
rebutton1043833rebutton_
rebuttons1143503rebuttons
ruttily10338613ruttily
rutting82718043rutting
rutty85617803rutt__y
stony85818643__stony
subtone9310343subtone
syntony1344523syntony
tony75635153___tony
tutting83515913tutting
tutty85217023tutt__y
unbutton1042463unbutton_
unbuttons1142133unbuttons

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.406440125.6
2DLD Change Limit1340271336.62320236.6
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.07525256.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.