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

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
esters6462773(None) 
asters65631601asters
easters75125681easters
eaters65535951eaters
enters64425641enters
eskers105312221eskers
ester54727711ester_
festers104121391festers
jesters144118191jesters
nesters74422791nesters
pesters93827091pesters
resters74130401resters
testers74124541testers
westers105221961westers
zesters163517291zesters
afters94717072afters
alters64924222alters
askers105915402askers
aspers86220312aspers
aster55434892aster_
astern64815812astern
basters94930312basters
beaters94925042beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922612bisters
biters83925242biters
busters94724132busters
casters94729902casters
caters85336502caters
centers94420602centers
citers85022982citers
costers94128342costers
daters74827372daters
deters74724682deters
diesters92513602diesters
doters74423912doters
dusters84918362dusters
eagers74523682eagers
easter65027982easter_
eastern74412532eastern
eater54639842eater_
eatery95316352eatery
edgers84413922edgers
egers65120372e_gers
eggers84612582eggers
eiders74321362eiders
elaters74420192elaters
elders74817302elders
elvers93814982elvers
embers104116182embers
emeers83314182emeers
emmers104013222emmers
emoters94712872emoters
enders74324052enders
enter54726382enter_
entera64216832entera
escars83913132escars
eses45336102es_e_s
eskars10357592eskars
esker94412982esker_
esnes54817362esne_s
esses56422972esse_s
esteem838812esteem
esteems935242esteems
esterase849482esterase
estops84011222estops
estovers1136452estovers
estrus61912112estrus
ethers94518412ethers
ewers86018822e_wers
extern1348472extern
externs1438232externs
eyers86521332e_yers
feasters11511562feasters
fester94723512fester_
fetters103517902fetters
fosters104220102fosters
gasters85624302gasters
gaters74728642gaters
gestes75721392geste_s
getters84216102getters
haters94930402haters
heaters104225222heaters
hefters134312002hefters
heisters113413132heisters
inters64328052inters
jester134319152jester_
justers143815732justers
keesters12319592keesters
keisters123212042keisters
kelters113813752kelters
keysters15326332keysters
kiesters123310152kiesters
kiters105218592kiters
lasters75627692lasters
leisters83312822leisters
letters73819852letters
listers74026532listers
liters65429882liters
lusters73921442lusters
masters94628922masters
maters85032392maters
meeters94714542meeters
meisters103313842meisters
melters93918312melters
mestees94617752mestees
meters85625832meters
misters93927512misters
miters84328782miters
musters94522512musters
nester64124182nester_
nestlers8359232nestlers
nestors73614972nestors
netters73618582netters
neuters74212272neuters
niters64624212niters
noters64021002noters
oaters65029792oaters
osiers63412792osiers
ostlers72911202ostlers
otters64021512otters
ousters74122792ousters
outers64230172outers
oxters134813272oxters
oysters103411692oysters
pasters94531732pasters
paters84935842paters
pelters93720312pelters
pensters103012122pensters
pester84827592pester_
peters86624592peters
petters93722362petters
pewters124113352pewters
posters93928012posters
presters103419002presters
questers17168772questers
rasters74629022rasters
raters63936582raters
renters74224822renters
rester63832432rester_
rosters73727552rosters
seaters74028942seaters
seders74420282seders
seers55136382_seers
sers45746652_s_ers
sestets7911472sestets
setters73822062setters
severs94121122severs
sewers94719722sewers
sisters73721592sisters
stars55836572_stars
steers63820982_steers
stems75219952_stems
steps76619882_steps
stere55328542_stere
steres63929532_steres
stern55319122_stern
sterns64616762_sterns
stets55423912_stets
stews85519142_stews
stirs55921622_stirs
suers55128482_suers
tasters74225642tasters
taters64932202taters
teeters74018302teeters
tenters73921112tenters
testees74215912testees
tester64227152tester_
testes65125822teste_s
tetters74320472tetters
titers64526412titers
toters65026362toters
ulsters72711982ulsters
users55817572us_ers
ushers94415532ushers
utters63817122utters
venters103717732venters
vespers1239032vespers
vestees103513172vestees
vetters104016322vetters
voters95017442voters
wasters104026592wasters
waters95030642waters
websters1335802websters
welters103516062welters
wester94222892wester_
western102911102western
westerns11328962westerns
wetters103817752wetters
wresters112711732wresters
xysters17307162xysters
yester93417982yester_
yestern10338642yestern
zester153617792zester_
zosters163015412zosters

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511972.20337472.1
3Display Results1971970.0633127.0
 (SQL Overall)1786911972.60968490.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.