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

305 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
nectars93846(None) 
nectar838851nectar_
nectary1246221nectary
hectare1238462hectare
hectares1338852hectares
hectors123513262hectors
lectors93415772lectors
nears55529422ne__ars
neckers134210462neckers
nectaries1149812nectaries
nectarous1144712nectarous
nesters74422792nesters
nestors73614972nestors
netters73618582netters
neuters74212272neuters
rectors93520522rectors
secpars1138412secpars
sectary1238272sectary
sectors93116452sectors
vectors123212592vectors
acetals93411353acetals
actors81016773_actors
altars64518153_altars
anears63717183ane__ars
attars64515313_attars
avatars1036443avatars
bears75739043be__ars
beaters94925043beaters
becaps123811403bec_aps
becharm1636843becharm
becharms1745343becharms
beggars11378223beggars
belters93819413belters
bestirs9311133bestirs
betas75528763be_ta_s
bettas84913923betta_s
betters94422093betters
bettors93312473bettors
bezoars1836793bezoars
cars67364763__c_ars
cedars93312833ce_dars
cellars93713693cellars
centals94317053centals
centare93113703centare
centares102913893centares
centas85020703centa_s
centaurs1035733centaurs
centers94420603centers
cestas85018543cesta_s
chars105936643__chars
costars94218013costars
cottars94412243cottars
czars164812913__czars
dears65736883de__ars
debars94218043de_bars
debtors1038533debtors
decafs124010883dec_afs
decals93717713dec_als
decare93919153dec_are
decares102818533dec_ares
decays124612913dec_ays
deciare10710663deciare
deciares11510633deciares
deckers144413833deckers
declare10411223declare
declares11611313declares
declass1038733declass
declaws1336253declaws
decors94017773dec_ors
deltas74414823delta_s
denars74621433de_nars
dentals83915393dentals
deodars937623deodars
deters74724683de_ters
dewars105117073de_wars
doctors1039993doctors
ears46356593_e__ars
eaters65535953_eaters
echard1249223_echard
echards1337963_echards
eclairs935963_eclairs
eclats8313033_eclats
ectases92911673_ectases
ectasis9249613_ectasis
eggars8398973_eggars
ejectors17328663ejectors
electors103013853electors
embars103812883_embars
enactors1038463enactors
endears83710053endears
enters64425643_enters
erecters102611613erecters
erectors103514263erectors
escars83913133_escars
eschars1237183eschars
eskars10357593_eskars
esters64627733_esters
etas46432273_e_ta_s
extras13310223_extras
factors12912133factors
fears84829393fe__ars
fecials123510333fecials
festers104121393festers
fetas85624403fe_ta_s
fetors91014473fe_tors
fetters103517903fetters
feuars938653fe_uars
gears64628693ge__ars
getas65421483ge_ta_s
getters84216103getters
guitars8116863guitars
hears86737373he__ars
heaters104225223heaters
hector113312653hector_
hefters134312003hefters
hektare1435503hektare
hektares1535813hektares
heptads1335873heptads
infecters14257583infecters
infectors14218553infectors
injectors18216723injectors
insectary1444213insectary
instars7411133instars
jesters144118193jesters
kantars11310033kantars
kebars124112493ke_bars
kelters113813753kelters
lactams1136953lactams
lactary1237853lactary
lears55938733le__ars
lechers123313963lechers
lectern937033lectern
lecterns1035943lecterns
lectins92515003lectins
lector83514993lector_
lecture9149523lecture
lectures101310163lectures
lekvars1432693lekvars
leotard846193leotard
leotards945303leotards
letters73819853letters
lictors93212603lictors
meccas1239493mecca_s
medlars10259443medlars
meeters94714543meeters
melters93918313melters
mentors9314993mentors
metals84520883me_tals
meters85625833me_ters
mortars93411523mortars
nachas114914193nacha_s
natters73718063natters
navars92810573n_avars
neaps75618323ne__aps
near45236503ne__ar_
neatens73310403neatens
neater64424313neater_
neats55931903ne__ats
necker124012793necker_
necks115119333nec__ks
neckties1445903neckties
nectarean1142913nectarean
nectarial1147103nectarial
nectaried1245443nectaried
nectarine1146983nectarine
nectarines1246893nectarines
needers84111903needers
negaters9349783negaters
negates83215843negates
negators92411173negators
nektons1136393nektons
nemas75321573ne_ma_s
nepetas935943nepeta_s
nerts55924983nert__s
nester64124183nester_
nestlers8359233nestlers
nestles73015463nestles
nestor63713423nestor_
nests55728003nest__s
netops839213ne_tops
nets45941533ne_t__s
netter63722023netter_
nettlers8307513nettlers
nettles73214083nettles
netts55320723ne_t_ts
neuter63713793neuter_
neutral737923neutral
neutrals846283neutrals
newtons1036813newtons
newts86015283newt__s
nicads938333nic_ads
nickers134415093nickers
nictate9310223nictate
nictates1039593nictates
niters64624213n_iters
nocturn944653nocturn
nocturns1043733nocturns
nonwars10109003nonwars
notary92310713n_otary
noters64021003n_oters
nuchals12216933nuchals
nutters74215433nutters
octads987333_octads
octans81411143_octans
ottars64112223_ottars
pears75138613pe__ars
pecans101515833pec_ans
peccary1636283peccary
pechans14810503pechans
peckers153312673peckers
pectase112410363pectase
pectases122411193pectases
pectate112214693pectate
pectates122213953pectates
pectens11189203pectens
pectins112315233pectins
pedlars103210213pedlars
pelters93720313pelters
pentads1039523pentads
pesters93827093pesters
petals84719813pe_tals
petard95013803pe_tard
petards104311153pe_tards
peters86624593pe_ters
petters93722363petters
pewters124113353pewters
qintars16268573qintars
reactors103212293reactors
rears54739653re__ars
reatas64021013reata_s
rebars84019833re_bars
recaps103615733rec_aps
rechart12314333rechart
recharts1337663recharts
recitals1039763recitals
reciters102613113reciters
reclads1049993reclads
recoals94214623recoals
recoats92616643recoats
recta74220263recta__
rectal84418133recta_l
rector84019753rector_
rectory123512733rectory
rectos85718783rect_os
rectums11338523rectums
rectus83314633rect_us
recurs83315803rec_urs
redears82814453redears
regears83012463regears
rehears103312773rehears
rentals74017473rentals
renters74224813renters
restart7320033restart
restarts8310873restarts
resters74130403resters
retags73414303re_tags
retard75018933re_tard
retards85015003re_tards
retears72814923retears
rewears102911043rewears
scars75433533_sc_ars
sears54744913se__ars
seaters74028943seaters
secpar1037923secpar_
sectaries11312243sectaries
sector83415933sector_
sects75622893sect__s
seculars10219393seculars
seggars9377783seggars
seitans73312303seitans
setters73822063setters
sewars94018633se_wars
sextans14349263sextans
sitars65417593_sitars
specters122811063specters
stars55836573__stars
tars46763953___tars
tartars73313403tartars
tatars64619793_tatars
tears55436463te__ars
tecta74215523tecta__
tectal83713253tecta_l
tectums11306423tectums
teeters74018303teeters
tenters73921103tenters
testers74124543testers
tetras63017623te_tras
tetters74320473tetters
tictacs1145793tictacs
vector113212063vector_
velars93913723ve_lars
venters103717733venters
vestals104612333vestals
vestas95916683vesta_s
vetters104016323vetters
vicars11712263vic_ars
victors123311183victors
wears86030303we__ars
welters103516063welters
westers105221963westers
wetters103817753wetters
years84527673ye__ars
yentas94614213yenta_s
zesters163517293zesters
zetas145018163ze_ta_s

Search took 7 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.390458182.1
2DLD Change Limit1340273055.92322628.2
3Display Results3053050.1102772.7
 (SQL Overall)1786913056.42327820.5
 
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.