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 “pesters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
pesters9382709(None) 
esters64627731_esters
festers104121391festers
jesters144118191jesters
nesters74422791nesters
pasters94531731pasters
pelters93720311pelters
pensters103012121pensters
pester84827591pester_
peters86624591pe_ters
petters93722361petters
pewters124113351pewters
posters93928011posters
presters103419001presters
resters74130401resters
testers74124541testers
westers105221961westers
zesters163517291zesters
asters65631602_asters
basters94930302basters
beaters94925042beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922612bisters
busters94724132busters
casters94729902casters
centers94420602centers
costers94128332costers
deters74724682de_ters
diesters92513602diesters
dopesters1237282dopesters
dusters84918362dusters
easters75125682easters
eaters65535952_eaters
enters64425642_enters
eskers105312222_eskers
ester54727712_ester_
feasters11511562feasters
fester94723512fester_
fetters103517902fetters
fosters104220102fosters
gasters85624292gasters
gestes75721392geste_s
getters84216102getters
heaters104225222heaters
hefters134312002hefters
heisters113413132heisters
jester134319152jester_
justers143815732justers
keesters12319592keesters
keisters123212042keisters
kelters113813752kelters
keysters15326332keysters
kiesters123310152kiesters
lasters75627692lasters
leisters83312822leisters
letters73819852letters
listers74026532listers
lusters73921442lusters
masters94628922masters
meeters94714542meeters
meisters103313842meisters
melters93918312melters
mestees94617752mestees
meters85625832me_ters
misters93927512misters
musters94522512musters
nester64124182nester_
nestlers8359222nestlers
nestors73614972nestors
netters73618582netters
neuters74212272neuters
ousters74122792ousters
oysters103411692oysters
palters94021682palters
passers94717752passers
pastels95215182pastels
paster85734372paster_
pastern94415062pastern
pasterns104112622pasterns
pastes85233912paste_s
pastors94119002pastors
paters84935832p_aters
patters94825192patters
peckers153312672peckers
pectens11189202pectens
pedlers103013272pedlers
peelers93615592peelers
peepers113713672peepers
peers75130272pe__ers
pelter83321622pelter_
penners93414182penners
penster92811952penster_
peppers103311442peppers
perter84422282perter_
pesetas938752pesetas
pestered112814962pestered
pesterer102412702pesterer
pesterers112510452pesterers
pestier94317402pestier_
pestles93217692pestles
pestos84719082pest_os
pests75933272pest__s
peter74427592pe_ter_
petter83924772petter_
pewter114013672pewter_
piasters102912812piasters
pishers123815752pishers
pissers95014752pissers
pistes85325632piste_s
plasters103518132plasters
platers93924092platers
pleaters103613792pleaters
porters93722702porters
posers84223972pos_ers
poster84129172poster_
postern93615612postern
posterns102713722posterns
potters94024342potters
pouters94221872pouters
powters124015662powters
praters94921652praters
pressers103215022pressers
prester93519622prester_
punsters103310582punsters
punters93617042punters
pushers123814502pushers
putters94219192putters
questers17168762questers
rasters74629022rasters
renters74224812renters
rester63832432rester_
rosters73727542rosters
seaters74028942seaters
sestets7911472sestets
setters73822062setters
sisters73721592sisters
specters122811062specters
spelters103912242spelters
tasters74225642tasters
teeters74018302teeters
tenters73921102tenters
testees74215912testees
tester64227152tester_
testes65125822teste_s
tetters74320472tetters
ulsters72711982ulsters
venters103717732venters
vespers1239032vespers
vestees103513172vestees
vetters104016322vetters
wasters104026592wasters
websters1335802websters
welters103516062welters
wester94222892wester_
western102911092western
westerns11328962westerns
wetters103817752wetters
wresters112711732wresters
xysters17307162xysters
yester93417982yester_
yestern10338632yestern
zester153617792zester_
zosters163015412zosters

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit1076711653.45331181.9
3Display Results1651650.0463587.0
 (SQL Overall)1786911653.88945947.8
 
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.