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

241 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
buttering12231252(None) 
battering122715141battering
bettering122212751bettering
bittering122511991bittering
guttering112410441guttering
muttering122611321muttering
puttering122611641puttering
uttering91613081_uttering
bantering122414232bantering
bartering122313642bartering
battening12268852battening
blattering13108712blattering
blustering13106182blustering
bothering152210202bothering
buffering1835222buffering
buggering1435192buggering
bumpering1636592bumpering
bunkering16207102bunkering
butchering1844502butchering
butterier1177452butterier
butteries11711762butteries
butting103519282butt__ing
buttoning1246462buttoning
cluttering13106832cluttering
fettering132310512fettering
fluttering14106292fluttering
gettering112310032gettering
gutterings12224912gutterings
jittering17218422jittering
lettering102112072lettering
littering102411982littering
lustering102711202lustering
mattering122314052mattering
mustering122212332mustering
nattering102212212nattering
pattering122314422pattering
pottering122612002pottering
reuttering1137572reuttering
scuttering1386632scuttering
shuttering1496562shuttering
sputtering13106462sputtering
stuttering1196352stuttering
tattering102212322tattering
tittering102310312tittering
tottering10229612tottering
wuthering1697802wuthering
yattering132410442yattering
abutting1137003abutt__ing
altering91917113_altering
attiring939483_attiring
authoring1348583authoring
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436963badgering
bannering12208803bannering
barbering14229683barbering
batterie10711533batteri_e
batteries11615113batteries
batting104422273batt__ing
battling113110493batt_ling
beavering1538703beavering
betattering1444143betattering
betting103921403bett__ing
bickering1837663bickering
bitewing1435293b_itewing
bitterish1446133bitterish
bittern94810683bitter_n_
bitterns10428953bitter_ns
bitting103717293bitt__ing
blathering16107583blathering
blethering16115933blethering
blistering13107063blistering
blithering16116123blithering
blubbering14103443blubbering
blundering1444823blundering
bolstering1346883bolstering
bordering1338833bordering
bottling11279143bott_ling
bottoming1444433bottoming
bouldering1464763bouldering
bowering142911713b_owering
brokering1636283brokering
brothering1646033brothering
bucketing1835713bucketing
bucklering1944043bucklering
budgeting1444023budgeting
buffeting1843783buffeting
bulleting1236643bulleting
bullring11388423bu_llring
bunting103718833bunt__ing
burdening1335543burdening
burring104016993bu__rring
burthening1643463burthening
busheling1535503busheling
busting104221793bust__ing
bustling112110063bust_ling
butleries11710073butleries
butling103516813bu_t_ling
butter84724233butter___
butterbur1342923butterbur
buttercup1542263buttercup
buttered112712623butter_ed
butterfat1444093butterfat
butterfish1853273butterfish
butterfly1742953butterfly
butterflying2151143butterflying
butteriest1276883butteriest
buttermilk1851963buttermilk
butternut1144743butternut
butters94521723butter__s
buttery124311193butter__y
buttressing1453053buttressing
butyrin1245813bu_tyrin_
butyrins1345423bu_tyrins
cantering122417373cantering
catering112019903_catering
centering122915143centering
chattering16108643chattering
chittering16107183chittering
chuntering1647803chuntering
clattering13109233clattering
clustering13116813clustering
countering13314473countering
cratering12312653cratering
culturing1236553culturing
cumbering16108203cumbering
cutting103817493cutt__ing
cuttling1138203cutt_ling
dithering1499853dithering
embittering1642943embittering
entering91920053_entering
faltering132211113faltering
fathering161010093fathering
fattening13287833fattening
festering132413173festering
filtering13199723filtering
flattering1498743flattering
flittering1486503flittering
flustering14105933flustering
fostering132411263fostering
frittering14105623frittering
fullering1336653fullering
furthering1744353furthering
gartering112111573gartering
gathering1499463gathering
glittering1296003glittering
gutting93415923gutt__ing
guttling1037293gutt_ling
haltering132212003haltering
hungering14187683hungering
hunkering17227123hunkering
hutting113016033hutt__ing
imbittering1642353imbittering
juddering1933763juddering
jutting153313713jutt__ing
juttying1933573jutt_ying
kittening1434593kittening
lathering13912253lathering
letterings11226003letterings
loitering1039683loitering
lumbering14117933lumbering
lustring9269723lust_ring
mastering122315303mastering
metering112915633_metering
mitering113015403_mitering
mothering152110183mothering
murdering1357133murdering
murthering1644473murthering
neutering1038963neutering
numbering14107003numbering
nurturing1045013nurturing
nutting83316233nutt__ing
outdaring1179723outdaring
outfiring1338163outfiring
outhearing1438443outhearing
outring84021023ou_t_ring
outseeing1038333outseeing
outserving1446743outserving
outspring1238903outspring
outstaring1137803outstaring
outsteering1244553outsteering
outtelling11107133outtelling
outtowering1542853outtowering
outwearing1437183outwearing
oystering1337563oystering
paltering122612893paltering
patterning1346073patterning
peltering122011673peltering
pestering122315663pestering
petering112516813_petering
portering122012303portering
pothering151911283pothering
puckering1835883puckering
putting103218573putt__ing
puttying1434953putt_ying
quartering2045843quartering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rattening10288763rattening
rubbering1435703rubbering
rupturing1244353rupturing
rutting82718043rutt__ing
sauntering1137223sauntering
scattering1398013scattering
shattering1498283shattering
sintering101014803sintering
sistering101213753sistering
skittering1535393skittering
smattering1397583smattering
spattering13107793spattering
spluttering1463363spluttering
squattering2143803squattering
steering93916793_steering
suckering1638103suckering
suffering1637293suffering
summering1458753summering
sundering11312323sundering
supering11317683su_pering
suturing9310373su_turing
teetering10239893teetering
tentering102313203tentering
tethering1339133tethering
tiering8315253__tiering
tuckering1635693tuckering
tutoring938433tu_toring
tutoyering1442253tutoyering
tutting83515913tutt__ing
twittering1444583twittering
ulcering1139333_ulcering
umbering1399433_umbering
untiring9312003_untiring
uptearing1236103_uptearing
ushering1258923_ushering
uterine7315193_u_terine
waitering13310713waitering
watering122316313_watering
weltering13219493weltering
westering132112643westering
wintering13412363wintering
withering16108813withering

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.1561145455.1
2DLD Change Limit1486412416.65622331.9
3Display Results2412410.1102190.9
 (SQL Overall)1786912416.92225814.9
 
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.