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

456 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
nestors7361495(None) 
nesters74422781nesters
nestor63713411nestor_
ancestors1147212ancestors
bestirs9311132bestirs
bestows1248862bestows
bettors93312472bettors
castors94919432castors
cestos84718092cesto_s
debtors1038532debtors
esters64627732_esters
estops84011222_estops
festers104121392festers
fetors91014472fe_tors
hectors123513262hectors
investors12227692investors
jesters144118192jesters
lectors93415762lectors
lessors73610522lessors
mentors9314992mentors
nectars938462nectars
negators92411152negators
nektons1136392nektons
nester64124182nester_
nestlers8359222nestlers
nestles73015462nestles
nests55728002nest__s
netops839212ne_tops
netters73618582netters
neustons836822neustons
neuters74212262neuters
newtons1036802newtons
nostocs947532nostocs
pastors94118992pastors
pesters93827092pesters
pestos84719082pesto_s
questors17147002questors
rectors93520512rectors
resters74130402resters
restore75822972restore
restores85222982restores
sectors93116432sectors
testers74124542testers
testons7313552testons
vectors123212592vectors
westers105221962westers
zesters163517292zesters
abators94413073abators
abettors1056133abettors
actors81016753_actors
aerators8315613aerators
alastors8311193alastors
ancestor1046843ancestor_
anestri746923anest_ri
anestrous946593anestrous
anestrus856303anestrus
arrestors958013arrestors
asters65631603_asters
attestors945743attestors
basters94930303basters
beaters94925033beaters
belters93819413belters
bentos86218303bento_s
bescours1245093bescours
besnows1245153besnows
besoms105712733bes_oms
besots86415453bes_ots
bestir8311163bestir_
bestow1149463besto_w
bestowers14135323bestowers
bestrow1237243bestrow
bestrows1337043bestrows
bests75932613best__s
bestuds10326753bestuds
betons84919553be_tons
betters94422093betters
bettor83612223bettor_
bevors111610343be_vors
bisters93922603bisters
bistort91216523bistort
bistorts10118803bistorts
bistros92810983bistros
bostons9312893bostons
busters94724123busters
cantors94620753cantors
captors113914983captors
casters94729893casters
castor84418533castor_
censors93611833censors
centers94420593centers
centos85920463cento_s
cestas85018543cest_as
cestode1037963cestode
cestodes1138203cestodes
cestoi84511953cesto_i
cestoid104011673cestoid
cestoids11308273cestoids
cestus84412913cest_us
costars94217993costars
costers94128303costers
creators102814383creators
customs11348253customs
custos84014313custo_s
debtor938333debtor_
decors94017773de_cors
delators92314823delators
desktops1542463desktops
desorb95210203des_orb
desorbs10437713des_orbs
despots10319683despots
destroy1138153destroy
destroys1236693destroys
deters74724683de_ters
detours858033de_tours
diesters92513593diesters
digestors11257253digestors
distort81120333distort
distorts91112343distorts
doctors1039983doctors
dusters84918353dusters
easters75125683easters
eaters65535943_eaters
editors839423editors
ejectors17328663ejectors
electors103013843electors
enactors1038443enactors
enamors939123enamors
enters64425643_enters
ephors11311403_ephors
erectors103514253erectors
errors63311313_errors
escars83913133_escars
escort84616483_escort
escorts9418403_escorts
escots84211743_escots
eskars10357593_eskars
eskers105312223_eskers
ester54727713_ester_
estop74312103_esto_p
estovers1136453_estovers
estrous7712533_estrous
estrus61912113_estrus
evertors1138953evertors
extols1337683_extols
extort13513973_extort
extorts1447753_extorts
factors12912123factors
feasters11511563feasters
fervors1336233fervors
fester94723513fester_
festoon1037673festoon
festoons1136433festoons
fests85828043fest__s
fetor81214533fe_tor_
fetters103517903fetters
foetors1039753foetors
fosters104220093fosters
gasters85624283gasters
gators74115823_gators
genitors937423genitors
gentoos838633gentoos
gessoes838293gessoes
gestes75721393gest_es
gests66028813gest__s
gesture839243gesture
gestures9310013gestures
getters84216093getters
gustoes879873gustoes
heaters104225213heaters
hector113312653hector_
hefters134312003hefters
heisters113413133heisters
heritors11310903heritors
herstory1446693herstory
hests85829933hest__s
history1339423history
inceptors1345763inceptors
indentors10278303indentors
infectors14218533infectors
infesters12237703infesters
injectors18216703injectors
instars7411113instars
inventors12288233inventors
invertors12239773invertors
investor11247393investor_
jester134319153jester_
jests125922453jest__s
jetons134512613je_tons
jetsoms16124723jetsoms
jettons1437273jettons
justers143815723justers
keesters12319593keesters
keisters123212043keisters
kelters113813753kelters
ketols104210763ke_tols
keysters15326333keysters
kiesters123310143kiesters
lasters75627693lasters
lector83514983lector_
legators92811023legators
leisters83312823leisters
lentos65317403lento_s
leptons91910413leptons
lesbos837403lesbo_s
lesions73813863lesions
lessons73811013lessons
lessor64010603lessor_
letters73819853letters
levators11249283levators
lictors93212583lictors
listers74026523listers
lusters73921433lusters
maestros1046163maestros
masters94628923masters
meeters94714543meeters
meisters103313843meisters
melters93918313melters
meltons9410923meltons
mentor8414363mentor_
mesons83215843mes_ons
mestees94617753mestees
meteors94610013meteors
meters85625833me_ters
metols84115773me_tols
metros84217803me_tros
misters93927503misters
motors84616593_motors
musters94522493musters
nasions73112383nasions
nasties73520493nasties
natters73718063natters
nears55529423ne__ars
neatens73310403neatens
neater64424313neater_
neats55931903neat__s
neckers134210463neckers
nectar838853nectar_
nectary1246223nectary
needers84111903needers
negaters9349773negaters
negatons9299273negatons
negator83010673negator_
nekton1036583nekto_n
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
nerols6914883ne_rols
nerts55924983nert__s
nervous1037143nervous
ness45526563nes___s
nesses64718323nes_ses
nest45548733nest___
nested74720063nest_ed
nesting84320443nesting
nestle63013953nest_le
nestled8349903nestled
nestler73510443nestler
netop7312343ne_to_p
nets45941533ne_t__s
netter63722023netter_
nettlers8307513nettlers
nettles73214083nettles
netts55320723ne_t_ts
network1446793network
networks1546143networks
neurons7410443neurons
neuston736083neusto_n
neuter63713793neuter_
neutron737763neutron
neutrons838293neutrons
newborn1244273newborn
newborns1343383newborns
newsboys1642303newsboys
newton936983newto_n
newts86015283newt__s
niters64624203n_iters
nitons64614903n_itons
nitros64214123n_itros
nonstops10116853nonstops
nonstory1148073nonstory
noshers103614323noshers
nostoc868183nosto_c
noters64020993n_oters
nutters74215423nutters
oestrous869913oestrous
oestrus7169573oestrus
orators7313803orators
ousters74122773ousters
oysters103411683oysters
pasters94531733pasters
pastor84817483pastor_
pelters93720313pelters
pensters103012123pensters
pesos77221623pes_o_s
pester84827593pester_
pestles93217693pestles
pesto75723723pesto__
pests75933273pest__s
peters86624593pe_ters
petters93722363petters
pewters124113353pewters
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
plessors10278253plessors
posters93927993posters
postops11311703postops
pressors103212673pressors
presters103419003presters
prestore104217343prestore
prestores114716063prestores
prestos93716073presto_s
pretors9316803pretors
quaestors1843603quaestors
questers17168763questers
questor16146633questor_
raptors94213353raptors
rasters74629023rasters
reactors103212283reactors
realtors82811683realtors
rector84019743rector_
rectory123512723rectory
rectos85718783recto_s
redtops1037373redtops
relators83316113relators
renters74224813renters
rescore95616193rescore
rescores105415693rescores
reshoes102316033reshoes
reshows132510453reshows
resistors947973resistors
resods74116303res_ods
resorb84914343res_orb
resorbs95010523res_orbs
resort65728613res_ort
resorts74817193res_orts
resows93915353res_ows
respots92912763respots
restart7320033restart
restarts8310873restarts
rester63832433rester_
restock1338673restock
restocks1437503restocks
restoke116113903restoke
restokes125213043restokes
restoral8810983restoral
restorals978073restorals
restored96417193restored
restorer84813723restorer
restorers95110113restorers
rests54935873rest__s
retore67630763re_tore
retorn610923423re_torn
retort66831143re_tort
retorts76016513re_torts
retros63820193re_tros
rhetors1038513rhetors
rosters73727533rosters
rotors64917933_rotors
sartors7314953sartors
seaters74028933seaters
sector83415923sector_
seisors73212813seisors
seizors16328993seizors
senators8312943senators
senhors103512123senhors
seniors73413613seniors
senors63620783se_nors
sensors73514623sensors
sestets7911473sestets
setons64620173se_tons
setous64917373se_tous
setters73822063setters
settlors8255003settlors
sextons143710413sextons
sextos134012163sexto_s
sisters73721573sisters
stars55836573__stars
stators73915553stators
stentors839713stentors
stertors8310903stertors
stirs55921613__stirs
stoas55126023__stoas
stobs75718233__stobs
stops74827283__stops
store56333813__store
stores65533643__stores
stork96819693__stork
storks106115933__storks
storm76520373__storm
storms85814603__storms
story86723033__story
stoss54316343__stoss
stots54828543__stots
stours65015623__stours
stows86622703__stows
suitors73012473suitors
tasters74225643tasters
teeters74018303teeters
tenors63217753te_nors
tensors72712373tensors
tenters73921103tenters
termors94712773termors
terrors73112203terrors
testators947323testators
testees74215913testees
tester64227153tester_
testes65125823test_es
testis64916713test_is
teston6313303testo_n
testoon748363testoon
testoons837303testoons
tests56530193test__s
tetters74320473tetters
tors46157383___tors
trustors8268893trustors
tussors7388763tussors
tutors6912323_tutors
ulsters72711983ulsters
unstops936983unstops
upstirs935293upstirs
vector113212063vector_
vendors113510223vendors
venters103717723venters
vespers1239033vespers
vestals104612333vestals
vestas95916683vest_as
vestees103513163vestees
vestry1238623vest_ry
vests85325983vest__s
vesture10310373vesture
vestures11311033vestures
vetoers10359473ve_toers
vetoes92914083ve_toes
vetters104016313vetters
viators102712013viators
victors123311173victors
visitors1146433visitors
visors92912223vis_ors
wasters104026593wasters
websters1335803websters
weldors11238003weldors
welters103516063welters
wester94222893wester_
western102911093western
westerns11328963westerns
wests85727003west__s
wetters103817753wetters
wresters112711733wresters
xysters17307163xysters
xystos16356913xysto_s
yester93417983yester_
yestern10338633yestern
zester153617793zester_
zests145419743zest__s
zosters163015403zosters

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274567.54617761.3
3Display Results4564560.1702682.4
 (SQL Overall)1786914567.85622745.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.