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

197 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
guttering11241044(None) 
buttering122312521buttering
gettering112310031gettering
gutterings12224911gutterings
muttering122611321muttering
puttering122611641puttering
uttering91613081_uttering
battering122715142battering
bettering122212752bettering
bittering122511992bittering
cluttering13106832cluttering
fettering132310512fettering
fluttering14106292fluttering
gartering112111572gartering
gathering1499462gathering
glittering1296002glittering
gutting93415922gutt__ing
guttling1037292gutt_ling
jittering17218422jittering
lettering102112072lettering
littering102411982littering
lustering102711202lustering
mattering122314052mattering
mustering122212332mustering
nattering102212212nattering
pattering122314422pattering
pottering122612002pottering
reuttering1137572reuttering
scuttering1386632scuttering
shuttering1496562shuttering
sputtering13106462sputtering
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
gandering122111293gandering
garnering11298083garnering
gatherings15105293gatherings
gauffering1842453gauffering
gendering12249753gendering
gesturing1136653gesturing
getting93316563gett__ing
gibbering1534713gibbering
gingering1238873gingering
gittern8337503gitter_n_
gitterns9326573gitter_ns
gitting93215703gitt__ing
glistering12106423glistering
glowering1435653glowering
glutting10247643glutt__ing
goffering1744483goffering
gusseting1173963gusseting
gusting93917163gust__ing
gutter73817713gutter___
guttered10259163gutter_ed
gutters83715513gutter__s
guttery11427763gutter__y
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
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 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411976.56322648.3
3Display Results1971970.0932118.3
 (SQL Overall)1786911977.07625253.1
 
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.