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

246 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
pesterer10241270(None) 
pestered112814951pestered
pesterers112510451pesterers
pewterer13256311pewterer
austerer838382austerer
enterer72015632_enterer
festered122512102festered
fetterer11207812fetterer
fosterer11239522fosterer
gesturer935982gesturer
letterer8259222letterer
oysterer1136102oysterer
palterer102411272palterer
pasturer1037522pasturer
patterer103112172patterer
peltered112510442peltered
pepperer1145272pepperer
pester84827592pest__er
pesters93827092pester_s
pestier94317402pest_ier
petered103314962pe_tered
pewterers14216042pewterers
plasterer1178102plasterer
posturer1038922posturer
potterer102310262potterer
putterer10209912putterer
restorer84813722restorer
westered122511862westered
westerner1244952westerner
alterer72713993_alterer
answerer1144263answerer
austere7312993austere_
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
besetter10137973besetter
besieger1144673besieger
besmearer1343163besmearer
bestower13126203bestower
bestrew1248003best_rew
bettered113011833bettered
bistered112913323bistered
bitterer10309773bitterer
blusterer11176293blusterer
bolsterer1145483bolsterer
caterer92815943_caterer
centered112513523centered
deserter91211603des_erter
deserver12118383des_erver
desirer8310783des_irer
destrier9311823destrier
deterger10147593de_terger
deterrer9137013de_terrer
dewaterer1343713dewaterer
eagerer8248823_eagerer
easterner945053easterner
entered82718883_entered
enterers82214153_enterers
esteem838813_este_em
ester54727713_est__er
esters64627733_ester_s
falterer11239853falterer
fastener11227833fastener
fester94723513fest__er
festers104121393fester_s
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
fostered122210453fostered
fosterers12238023fosterers
gesture839243gesture_
gestured1036993gestured
gesturers1044283gesturers
gestures9310013gestures
gettered10258613gettered
hastener11259133hastener
hosteler1137273hosteler
jeerer13389933je__erer
jester134319153jest__er
jesters144118193jester_s
kestrel1137113kest_rel
lecturer10136023lecturer
leistered1037043leistered
lettered92910783lettered
letterers9228113letterers
listener8158313listener
litterer82810173litterer
lobsterer1144033lobsterer
loiterer837083loiterer
lustered92510603lustered
mastered112614003mastered
mestee84523883meste_e_
mestees94617753meste_es
metered103514013me_tered
miterer92511333_miterer
mustered112511503mustered
mutterer10218913mutterer
nester64124183nest__er
nesters74422793nester_s
nestler73510443nest_ler
neutered937423neutered
oystered1236923oystered
oysterers1245573oysterers
paltered113012483paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903p_aperer
parterre1036983parterre
paster85734373past__er
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastier94320383past_ier
pastored1139963pastored
pasture9311463pasture_
pastured1138233pastured
pasturers1136393pasturers
pastures10311963pastures
pattered112714203pattered
patterers112410123patterers
peatier94017233peat_ier
peeler83517383pe__eler
peeper103614803pe__eper
peered93819483pe__ered
pelter83321623pelt__er
pelters93720313pelter_s
penster92811953penst__er
pensters103012123penster_s
pentene9313793pentene_
pentenes10315633pentenes
peppered1236123peppered
pepperers1244893pepperers
peptizer21236473peptizer
perjurer17285903perjurer
perter84422283pert__er
perturber1343153perturber
perverter1445563perverter
peskier13319113pes_kier
pestering122315663pestering
pestle83215843pest_le_
pestled102711433pest_led
pestles93217693pest_les
peter74427593pe_t__er
peters86624593pe_ter_s
petrel83111533pe_t_rel
petter83924773pe_t_ter
petters93722363petter_s
pettier94213613pe_ttier
pewter114013673pewt__er
pewters124113353pewter_s
peytrel1264253peyt_rel
pilferer1344923pilferer
plastered1288893plastered
plasterers1286123plasterers
ponderer112410193ponderer
portered112311533portered
posteen93512623poste_en
poster84129173post__er
posterior1147833posterior
postern93615613poster_n
posterns102713723posterns
posters93928013poster_s
posture9313253posture_
postured1139493postured
posturers1137053posturers
postures10313783postures
pottered112311663pottered
potterers11218663potterers
poulterer1145423poulterer
powderer14245593powderer
preserver14127013pres_erver
prester93519623prest__er
presterna1145263presterna
presters103419003prester_s
prestore104217343prestore_
prestored125111673prestored
prestores114716083prestores
properer1259203properer
puckerer1645793puckerer
puttered112611143puttered
putterers11238363putterers
renderer9239743renderer
reserver11119633res_erver
resetter81511833resetter
rester63832433rest__er
resters74130403rester_s
restore75822973restore_
restored96417193restored
restorers95110113restorers
restores85222993restores
retirer74715013re_tirer
reverer103815833re_verer
roisterer946433roisterer
serer55935503__s_erer
sesterce1047113sesterce
sesterces1147873sesterces
severer103511563se_verer
shelterer1245033shelterer
sistered92612803sistered
sputterer11165263sputterer
starer64027363__starer
steer55423863__ste_er
steerer73113633__steerer
stere55328543__stere_
stereo65317913__stereo
steres63929533__steres
sterner7411913__sterner
storer64721673__storer
teetered9258303teetered
temperer12227723temperer
tenderer9228733tenderer
tentered96412103tentered
testee64323303teste_e_
testees74215913teste_es
tester64227153test__er
testers74124543tester_s
testier74015643test_ier
titterer8268523titterer
totterer8217793totterer
utterer71910463_utterer
veneerer1145033veneerer
venturer1137243venturer
verderer1245373verderer
vestee94319153veste_e_
vestees103513173veste_es
vesture10310373vesture_
vestured1237463vestured
vestures11311043vestures
waterer103314073_waterer
weltered12238433weltered
wester94222893west__er
westerly1445553westerly
western102911093wester_n
westerners1344463westerners
westerns11328963westerns
westers105221963wester_s
winterer112110443winterer
yester93417983yest__er
yestereve1543133yestereve
yestern10338633yester_n
yesteryear1651063yesteryear
yestreen1144593yestreen
zester153617793zest__er
zesters163517293zester_s
zestier163010223zest_ier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622467.44019645.4
3Display Results2462460.1102236.4
 (SQL Overall)1786912467.70623188.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.