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

129 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
nesters7442279(None) 
esters64627731_esters
festers104121391festers
jesters144118191jesters
nester64124181nester_
nestlers8359231nestlers
nestors73614971nestors
netters73618581netters
neuters74212271neuters
pesters93827091pesters
resters74130401resters
testers74124541testers
westers105221961westers
zesters163517291zesters
asters65631602_asters
basters94930302basters
beaters94925042beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922612bisters
busters94724132busters
casters94729902casters
centers94420602centers
costers94128332costers
deters74724682de_ters
diesters92513602diesters
dusters84918362dusters
easters75125682easters
eaters65535952_eaters
enters64425642_enters
eskers105312222_eskers
ester54727712_ester_
feasters11511562feasters
fester94723512fester_
fetters103517902fetters
fosters104220102fosters
gasters85624292gasters
gestes75721392geste_s
getters84216102getters
heaters104225222heaters
hefters134312002hefters
heisters113413132heisters
infesters12237712infesters
jester134319152jester_
justers143815732justers
keesters12319592keesters
keisters123212042keisters
kelters113813752kelters
keysters15326332keysters
kiesters123310152kiesters
lasters75627692lasters
leisters83312822leisters
letters73819852letters
listers74026532listers
lusters73921442lusters
masters94628922masters
meeters94714542meeters
meisters103313842meisters
melters93918312melters
mestees94617752mestees
meters85625832me_ters
misters93927512misters
musters94522512musters
natters73718062natters
neatens73310402neatens
neater64424312neater_
neckers134210462neckers
nectars938462nectars
needers84111902needers
negaters9349782negaters
nesses64718322nesse_s
nested74720062neste_d
nestler73510452nestler_
nestles73015462nestles
nestor63713422nestor_
nests55728002nest__s
netter63722022netter_
nettlers8307512nettlers
neuter63713792neuter_
niters64624212n_iters
noshers103614332noshers
noters64021002n_oters
nutters74215432nutters
ousters74122792ousters
oysters103411692oysters
pasters94531732pasters
pelters93720312pelters
pensters103012122pensters
pester84827592pester_
peters86624592pe_ters
petters93722362petters
pewters124113352pewters
posters93928012posters
presters103419002presters
questers17168762questers
rasters74629022rasters
renters74224812renters
rester63832432rester_
rosters73727542rosters
seaters74028942seaters
sestets7911472sestets
setters73822062setters
sisters73721592sisters
tasters74225642tasters
teeters74018302teeters
tenters73921102tenters
testees74215912testees
tester64227152tester_
testes65125822teste_s
tetters74320472tetters
ulsters72711982ulsters
venters103717732venters
vespers1239032vespers
vestees103513172vestees
vetters104016322vetters
wasters104026592wasters
websters1335802websters
welters103516062welters
wester94222892wester_
western102911102western
westerns11328962westerns
wetters103817752wetters
wresters112711732wresters
xysters17307162xysters
yester93417982yester_
yestern10338642yestern
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.360496363.9
2DLD Change Limit1076711293.23333303.7
3Display Results1291290.0462804.3
 (SQL Overall)1786911293.63949104.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.