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

227 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
pottering12261200(None) 
pattering122314421pattering
portering122012301portering
pothering151911281pothering
puttering122611641puttering
tottering10229611tottering
battering122715142battering
bettering122212752bettering
bittering122511992bittering
bothering152210202bothering
buttering122312522buttering
fettering132310512fettering
fostering132411262fostering
gettering112310032gettering
guttering112410442guttering
jittering17218422jittering
lettering102112072lettering
littering102411982littering
loitering1039682loitering
mattering122314052mattering
mothering152110182mothering
muttering122611322muttering
nattering102212212nattering
paltering122612892paltering
patterning1346072patterning
peltering122011672peltering
pestering122315662pestering
petering112516812p_etering
pondering132411332pondering
posturing1238992posturing
potteries11313592potteries
potteringly1762942potteringly
potting103720892pott__ing
powdering16246502powdering
powering142210802po_wering
spattering13107792spattering
sputtering13106462sputtering
tattering102212322tattering
tittering102310312tittering
uttering91613082_uttering
yattering132410442yattering
altering91917113_altering
attiring939483_attiring
bantering122414233bantering
bartering122313643bartering
battening12268853battening
blattering13108713blattering
bolstering1346883bolstering
bordering1338833bordering
bottling11279143bott_ling
bottoming1444433bottoming
bowering142911713bo_wering
brothering1646033brothering
cantering122417373cantering
catering112019903_catering
centering122915143centering
chattering16108643chattering
chittering16107183chittering
clattering13109233clattering
cluttering13106833cluttering
cockering1839693cockering
coffering1838043coffering
cohering142413833co_hering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
cornering12311893cornering
coshering15510023coshering
cottoning1237343cottoning
countering13314473countering
covering142215723co_vering
cowering142514033co_wering
cratering12312653cratering
dithering1499853dithering
doctoring1346183doctoring
doddering1335183doddering
dotting93314483dott__ing
dowering132510613do_wering
entering91920053_entering
faltering132211113faltering
fathering161010093fathering
fattening13287833fattening
festering132413173festering
filtering13199723filtering
flattering1498743flattering
flittering1486503flittering
fluttering14106293fluttering
foddering1535163foddering
fosterling1445173fosterling
frittering14105623frittering
gartering112111573gartering
gathering1499463gathering
glittering1296003glittering
goffering1744483goffering
gutterings12224913gutterings
haltering132212003haltering
hollering1337743hollering
holstering1447083holstering
homering141512073ho_mering
hoovering1635753hoovering
hosteling1337893hosteling
hotting113116523hott__ing
hovering151911143ho_vering
jotting152912773jott__ing
kittening1434593kittening
koshering1735363koshering
lathering13912253lathering
letterings11226003letterings
lobstering1345123lobstering
loppering14237283loppering
lotteries9311073lotteries
lotting82917753lott__ing
lowering122210913lo_wering
lustering102711203lustering
mastering122315303mastering
metering112915633_metering
mitering113015403_mitering
moldering1367863moldering
mongering13310353mongering
mortaring1237943mortaring
motherings16255643motherings
motoring11410953mo_toring
mottling11197753mott_ling
mustering122212333mustering
neutering1038963neutering
ochering14219393_ochering
offering1536393_offering
ordering1039353_ordering
outring84021023_out_ring
overing111918053_o_vering
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
pioneering1354393pioneering
pitting103618873pitt__ing
plastering1339243plastering
plotting113011013plott__ing
pocketing1875853pocketing
poetising1238713poetising
poetizing2148683poetizing
pollening1236923pollening
pommeling1643873pommeling
poring94227273po___ring
portaging1346843portaging
portending1446193portending
porting103021783port__ing
posterior1147833posterior
posterity1448693posterity
postern93615613poster_n_
posterns102713723poster_ns
posting105622243post__ing
potteen9319673potte_en_
potteens10256793potte_ens
potter83926983potter___
pottered112311663potter_ed
potterer102310263potter_er
potterers11218663potterers
potters94024343potter__s
pottery123011073potter__y
pouring103115863po__uring
pouting103519943pout__ing
proctoring1546673proctoring
proffering1943773proffering
prospering1547173prospering
pterin81014153p__terin_
pterins9812993p__terins
puckering1835883puckering
putting103218573putt__ing
puttying1434953putt_ying
rattening10288763rattening
reuttering1137573reuttering
rogering10310273ro_gering
roistering1148583roistering
rotting82919683rott__ing
roystering1445413roystering
scattering1398013scattering
scuttering1386633scuttering
shattering1498283shattering
shuttering1496563shuttering
sintering101014803sintering
sistering101213753sistering
skittering1535393skittering
smattering1397583smattering
smothering1646013smothering
sobering111912783so_bering
softening1365493softening
soldering1169033soldering
splattering1454543splattering
spluttering1463363spluttering
spotting112812093spott__ing
steering93916793_steering
stuttering1196353stuttering
teetering10239893teetering
tentering102313203tentering
tethering1339133tethering
tiering8315253__tiering
tochering1537153tochering
torturing1036253torturing
totteringly1552553totteringly
totting82816843tott__ing
towering122610873to_wering
twittering1444583twittering
waitering13310713waitering
watering122316313_watering
weltering13219493weltering
westering132112643westering
wintering13412363wintering
withering16108813withering
wondering142110463wondering
wotting112913843wott__ing
wuthering1697803wuthering

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.1731032896.0
2DLD Change Limit1486412277.37620152.0
3Display Results2272270.1102063.6
 (SQL Overall)1786912277.65923330.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.