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

266 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
pestering12231566(None) 
festering132413171festering
peltering122011671peltering
petering112516811pe_tering
westering132112641westering
bettering122212752bettering
centering122915142centering
entering91920052_entering
fettering132310512fettering
fostering132411262fostering
gesturing1136652gesturing
gettering112310032gettering
leistering1147982leistering
lettering102112072lettering
lustering102711202lustering
mastering122315302mastering
metering112915632me_tering
mustering122212332mustering
neutering1038962neutering
oystering1337562oystering
paltering122612892paltering
pastoring12310852pastoring
pasturing1238432pasturing
pattering122314422pattering
peering103520352pe__ering
peppering1337082peppering
pestling111010252pest_ling
plastering1339242plastering
portering122012302portering
posturing1238992posturing
pottering122612002pottering
prestoring13310302prestoring
puttering122611642puttering
restoring10314612restoring
restring91518782rest_ring
sistering101213752sistering
teetering10239892teetering
tentering102313202tentering
vesturing1337202vesturing
weltering13219492weltering
absterging1453353absterging
altering91917113_altering
answering1345803answering
bantering122414233bantering
bartering122313643bartering
battering122715143battering
beavering1538703beavering
beseeming1435143beseeming
besetting12268423besetting
besieging1344763besieging
besmearing1544323besmearing
besteading1446033besteading
besting104923923best__ing
bestirring1343993bestirring
bestowing1535803bestowing
bestrewing1643773bestrewing
bittering122511993bittering
blistering13107063blistering
blustering13106183blustering
bolstering1346883bolstering
buttering122312523buttering
cantering122417373cantering
catering112019903_catering
centerings13247663centerings
centring112112953cent_ring
clustering13116813clustering
coshering15510023coshering
cratering12312653cratering
delustering1344073delustering
deserting11713143des_erting
deserving1497903des_erving
desexing1736293des_exing
desiring10312143des_iring
destining11311433destining
deterging1237853de_terging
deterring1138623de_terring
dewatering1545773dewatering
eserine7415903_es_erine
estating92614993_estating
esteeming1244703_esteeming
esterify1445623_esterify
estrin6315923_est_rin_
estrins7315853_est_rins
faltering132211113faltering
fastening13268603fastening
feathering17108793feathering
featuring1337323featuring
fevering152510083fe_vering
filtering13199723filtering
flustering14105933flustering
fosterling1445173fosterling
gartering112111573gartering
gendering12249753gendering
gestating11229983gestating
glistering12106423glistering
guttering112410443guttering
haltering132212003haltering
hastening13259483hastening
hectoring1538303hectoring
holstering1447083holstering
hosteling1337893hosteling
jeering153513043je__ering
jesting154317713jest__ing
jittering17218423jittering
kashering1736253kashering
koshering1735363koshering
leathering1488683leathering
lechering1538443lechering
lecturing1237303lecturing
leering83417643le__ering
lessening1045333lessening
letterings11226003letterings
levering122212503le_vering
listening10128953listening
littering102411983littering
lobstering1345123lobstering
loitering1039683loitering
lustring9269723lust_ring
mattering122314053mattering
mentoring1239543mentoring
metring103215293me_t_ring
misterming1538603misterming
mitering113015403_mitering
muttering122611323muttering
nattering102212213nattering
neatening1038353neatening
nesting84320443nest__ing
nestling958893nest_ling
oestrin7312243oest_rin_
oestrins8312673oest_rins
oysterings1443903oysterings
pampering1638383pampering
pandering133211963pandering
papering132213313p_apering
partnering1345553partnering
passerine1147083passerine
pastern94415063paster_n_
pasterns104112623paster_ns
pasting103826553past__ing
patterning1346073patterning
paupering1437273paupering
pectizing2348013pectizing
peeing94618083pe__e_ing
peeking144414953pe__eking
peeling102919873pe__eling
peening103318303pe__ening
peeping123615213pe__eping
peeving135112243pe__eving
pelerine10313013pe_lerine
pelleting1237953pelleting
pelting102917273pelt__ing
peptizing2347113peptizing
perduring1336013perduring
perjuring1944923perjuring
persevering1743253persevering
perspiring1544853perspiring
perturbing1543563perturbing
perverting1646623perverting
pester84827593pester___
pestered112814973pester_ed
pesterer102412713pester_er
pesterers112510463pesterers
pesters93827093pester__s
petting103720953pe_t_ting
pettling1168213pe_ttling
philtering1646253philtering
picturing1436033picturing
pilfering1536393pilfering
pistoling1268493pistoling
plaistering1444603plaistering
plasterings1444743plasterings
pondering132411333pondering
posterior1147833posterior
posterity1448693posterity
postern93615613poster_n_
posterns102713723poster_ns
posting105622243post__ing
pothering151911283pothering
powdering16246503powdering
powering142210803p_owering
prealtering1446173prealtering
premiering1547243premiering
prescoring1547433prescoring
preserving1637363pres_erving
presetting131010833presetting
pressuring1346513pressuring
presterna1145263prester_na
prospering1547173prospering
pterin81014153p__terin_
pterins9812993p__terins
puckering1835883puckering
realtering1139473realtering
reentering1149983reentering
registering1346393registering
remastering1446843remastering
rendering112213183rendering
rescoring12310603rescoring
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reserving131110643res_erving
resetting102816293resetting
resewing122712263res_ewing
respiring12159903respiring
respring111614063res_pring
restaging112410853restaging
restarting11310663restarting
restating102319413restating
resting85031183rest__ing
restoking1438193restoking
restrings10159293rest_rings
restrung9176443rest_rung
restyling1337923restyling
retearing102214253re_tearing
retiring92717413re_tiring
reuttering1137573reuttering
revering122918073re_vering
roistering1148583roistering
roystering1445413roystering
sceptering1545793sceptering
sectoring1239583sectoring
sering74731813__s_ering
severing122013853se_vering
sewering122411093se_wering
sheltering1446493sheltering
sintering101014803sintering
skeltering1545003skeltering
spattering13107793spattering
speering113116323spe__ering
sputtering13106463sputtering
staring84527053__staring
steering93916793__steering
sterling93615553__sterling
stewing113412493__stewing
storing83921123__storing
string75327563__st_ring
sweltering1445233sweltering
tattering102212323tattering
teddering12256303teddering
telfering1336253telfering
tempering1438733tempering
tendering112210813tendering
testing86021053test__ing
tethering1339133tethering
texturing1735223texturing
tittering102310313tittering
tottering10229613tottering
unstring9312093unst_ring
upstaring1235963upstaring
ushering1258923_ushering
uttering91613083_uttering
vectoring1537413vectoring
veering113213683ve__ering
veneering1337663veneering
venturing1337553venturing
vesting114618683vest__ing
waitering13310713waitering
watering122316313_watering
weathering1798353weathering
western102911103wester_n_
westerns11328963wester_ns
westing115020273west__ing
wintering13412363wintering
yattering132410443yattering
yestern10338643yester_n_
zesting174515333zest__ing

Search took 9 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.453394461.4
2DLD Change Limit1486412667.51619776.6
3Display Results2662660.1232162.6
 (SQL Overall)1786912668.09222082.4
 
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.