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

220 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
puttering12261164(None) 
buttering122312521buttering
guttering112410441guttering
muttering122611321muttering
pattering122314421pattering
pottering122612001pottering
sputtering13106461sputtering
uttering91613081_uttering
battering122715142battering
bettering122212752bettering
bittering122511992bittering
cluttering13106832cluttering
fettering132310512fettering
fluttering14106292fluttering
gettering112310032gettering
gutterings12224912gutterings
jittering17218422jittering
lettering102112072lettering
littering102411982littering
lustering102711202lustering
mattering122314052mattering
mustering122212332mustering
nattering102212212nattering
paltering122612892paltering
patterning1346072patterning
peltering122011672peltering
pestering122315662pestering
petering112516812p_etering
portering122012302portering
pothering151911282pothering
puckering1835882puckering
putting103218572putt__ing
puttying1434952putt_ying
reuttering1137572reuttering
scuttering1386632scuttering
shuttering1496562shuttering
spattering13107792spattering
spluttering1463362spluttering
stuttering1196352stuttering
tattering102212322tattering
tittering102310312tittering
tottering10229612tottering
wuthering1697802wuthering
yattering132410442yattering
altering91917113_altering
attiring939483_attiring
authoring1348583authoring
bantering122414233bantering
bartering122313643bartering
battening12268853battening
blattering13108713blattering
blustering13106183blustering
bothering152210203bothering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
butchering1844503butchering
butterier1177453butterier
butteries11711763butteries
butting103519283butt__ing
buttoning1246463buttoning
cantering122417373cantering
catering112019903_catering
centering122915143centering
chattering16108643chattering
chittering16107183chittering
chuntering1647803chuntering
clattering13109233clattering
clustering13116813clustering
countering13314473countering
cratering12312653cratering
culturing1236553culturing
cumbering16108203cumbering
cutting103817493cutt__ing
cuttling1138203cutt_ling
dithering1499853dithering
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
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
pampering1638383pampering
pandering133211963pandering
papering132213313p_apering
partnering1345553partnering
pastoring12310853pastoring
pasturing1238433pasturing
pattern93712053patter_n_
patternings1443183patternings
patterns10439943patter_ns
patting103722343patt__ing
paupering1437273paupering
peering103520353p__eering
peppering1337083peppering
petting103720953pett__ing
pettling1168213pett_ling
philtering1646253philtering
picturing1436033picturing
pilfering1536393pilfering
pitting103618873pitt__ing
plastering1339243plastering
plundering1444173plundering
pondering132411333pondering
posturing1238993posturing
potteries11313593potteries
potteringly1762943potteringly
potting103720893pott__ing
powdering16246503powdering
powering142210803p_owering
pterin81014153p__terin_
pterins9812993p__terins
pummeling1643603pummeling
puncturing1543303puncturing
punting103318443punt__ing
pureeing1137273pu_reeing
purring104515823pu__rring
purveying1843573purveying
putrefying1942953putrefying
putter83921443putter___
puttered112611143putter_ed
putterer10209913putter_er
putterers11238363putterers
putters94219193putter__s
putzing19359123pu_t_zing
quartering2045843quartering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rattening10288763rattening
rubbering1435703rubbering
rupturing1244353rupturing
rutting82718043rutt__ing
sauntering1137223sauntering
scattering1398013scattering
shattering1498283shattering
sintering101014803sintering
sistering101213753sistering
skittering1535393skittering
smattering1397583smattering
splattering1454543splattering
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
upstaring1235963upstaring
uptearing1236103uptearing
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.423422437.4
2DLD Change Limit1486412206.37323323.6
3Display Results2202200.0932365.6
 (SQL Overall)1786912206.88925938.6
 
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.