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

400 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
lectors9341577(None) 
electors103013861electors
hectors123513261hectors
lector83514991lector_
lictors93212601lictors
rectors93520521rectors
sectors93116451sectors
vectors123212591vectors
actors81016772_actors
bettors93312472bettors
debtors1038532debtors
decors94017772dec_ors
doctors1039992doctors
ejectors17328662ejectors
elector93313262elector_
electros102811752electros
erectors103514262erectors
factors12912132factors
fetors91014472fe_tors
hector113312652hector_
lechers123313962lechers
lectern937032lectern
lecterns1035942lecterns
lectins92515002lectins
lections102413842lections
lecture9149522lecture
lectures101310162lectures
legators92811032legators
lentos65317402lento_s
leptons91910432leptons
lessors73610522lessors
letters73819852letters
levators11249282levators
lictor83610862lictor_
locators102910432locators
mentors9314992mentors
nectars938462nectars
nestors73614972nestors
reactors103212292reactors
rector84019752rector_
rectory123512732rectory
rectos85718782recto_s
sector83415932sector_
selectors1148972selectors
vector113212062vector_
victors123311182victors
abators94413093abators
abettors1056133abettors
acetous9410363acetous
actor71116083_actor_
aerators8315613aerators
alastors8311223alastors
aleatory1148823aleatory
anchors123912953anchors
beaters94925043beaters
beckons15279143beckons
beclogs1237073beclogs
belters93819413belters
bentos86218303bento_s
bestirs9311133bestirs
bestows1248863bestows
betons84919553be_tons
betters94422093betters
bettor83612223bettor_
bevors111610343be_vors
bisectors1345733bisectors
bleaters103412323bleaters
cantors94620753cantors
captors113914983captors
castors94919443castors
censors93611843censors
centers94420603centers
centos85920463cento_s
cestos84718093cesto_s
coactors1239483coactors
collectors1446593collectors
cors66656443__c_ors
creators102814413creators
debtor938333debtor_
deckers144413833deckers
decolors1187713decolors
decor84717573dec_or_
decos85522123dec_o_s
decoys123911283dec_oys
defectors15237883defectors
deflectors1654773deflectors
delators92314833delators
depictors1465943depictors
detectors12278303detectors
deters74724683de_ters
detours858043de_tours
directors1248143directors
doctor938993doctor_
eaters65535953_eaters
echoers12459693_echoers
echoes114715523_echoes
echos105216463_echo_s
ecotours1044463_ecotours
editors839423editors
eductors1135983eductors
effectors1755033effectors
ejector16378603ejector_
elaters74420193elaters
electees10238723electees
elections112414973elections
electoral1156733electoral
electro92810033elect_ro
electron102611413electron
electrons112411763electrons
elects83315003elect__s
elevators1246303elevators
elicitors1145803elicitors
enactors1038463enactors
enters64425643_enters
ephors11311403_ephors
erecters102611613erecters
erector93513813erector_
errors63311313_errors
esters64627733_esters
estops84011223_estops
evertors1138953evertors
evictors13276853evictors
exactors1737023exactors
excitors1746093excitors
executors1844653executors
extols1337683_extols
extort13513973_extort
extorts1447753_extorts
factor11911463factor_
factory15108353factory
fervors1336233fervors
festers104121393festers
fetor81214533fe_tor_
fetters103517903fetters
flections14239213flections
flexors1734773fle_xors
foetors1039763foetors
functors1335743functors
gators74115843_gators
geckoes14325793geckoes
geckos13457433gecko_s
genitors937423genitors
gentoos838633gentoos
getters84216103getters
heaters104225223heaters
hectare1238463hectare
hectares1338853hectares
hectored1436893hectored
hefters134312003hefters
heritors11310903heritors
ichors11310423_ichors
infectors14218553infectors
inflectors1545223inflectors
injectors18216723injectors
jesters144118193jesters
jetons134512613je_tons
jettons1437273jettons
kelters113813753kelters
ketols104210763ke_tols
kleptos1344363klepto_s
labors84016413l_abors
lacers85225253lac_ers
lackers134120543lackers
lactams1136953lactams
lactary1237853lactary
lacteous1046773lacteous
lactone9311413lactone
lactones10311243lactones
lactose969493lactose
lactoses1039833lactoses
laptops1166603laptops
lasters75627693lasters
leachers133712813leachers
leaders83819603leaders
leakers113415423leakers
leaners73718173leaners
leapers93716663leapers
lears55938733le__ars
leasers74717843leasers
leathers114215083leathers
leavers103717783leavers
lecher113415853lecher_
lechery15257643lechery
leches115421313lec_hes
lechwes1535063lechwes
lectin82515013lect_in
lection92614863lection
lectured11127233lectured
lecturer10136033lecturer
lecturers11124233lecturers
lecythis1642873lecythis
lecythus1641783lecythus
ledgers94912183ledgers
leers54828983le__ers
leets54927123leet__s
lefter93613433lefter_
lefties10312073lefties
leftovers1542783leftovers
lefts86517813left__s
legator83011133legator_
legatos82711183legato_s
legers74518313le_gers
leghorn1146223leghorn
leghorns1244903leghorns
legions84611783legions
legwork1545663legwork
legworks1645373legworks
lehrs86111133le__hrs
leisters83312823leisters
lekvars1432693lekvars
lemons84415053le_mons
lemurs837253le_murs
lenders84419643lenders
lenos56024863le_no_s
lentils73912973lentils
lento57223393lento__
lentoid8310683lentoid
lentoids947443lentoids
leotard846193leotard
leotards945303leotards
lepers84817323le_pers
leprous938843leprous
leptins92412693leptins
lepton82510803lepto_n
lesbos837403lesbo_s
lesions73813873lesions
lessons73811023lessons
lessor64010603lessor_
letches124015483letches
lethes94818083le_thes
lets47147943le_t__s
letter63722583letter_
letups8317683le_tups
leukons1135753leukons
levator10298963levator_
levatores12225743levatores
levers94621323le_vers
leviers103510343leviers
lickers134118253lickers
lifters104313783lifters
linters73822633linters
lintols7339553lintols
liquors1634433liquors
listers74026533listers
liters65429883l_iters
litters73422573litters
locaters102710073locaters
locator93110423locator_
lockers133516923lockers
locoes85516583loc_oes
locos75822603loc_o_s
locutory1344273locutory
lofters103912903lofters
loiters74116613loiters
looters74419163looters
lotos54724633l_oto_s
lotters73921063lotters
lottos64613103lotto_s
lusters73921443lusters
meeters94714543meeters
melters93918313melters
meltons9410923meltons
mentor8414363mentor_
meteors94610013meteors
meters85625833me_ters
metols84115773me_tols
metros84217803me_tros
motors84616603_motors
mucors104410853muc_ors
neckers134210463neckers
nectar838853nectar_
nectary1246223nectary
negators92411173negators
neglectors1363543neglectors
nektons1136393nektons
nesters74422793nesters
nestor63713423nestor_
netops839223ne_tops
netters73618583netters
neuters74212273neuters
newtons1036813newtons
objectors2044053objectors
orators7313823orators
pastors94119003pastors
peckers153312673peckers
pectens11189203pectens
pectins112315233pectins
pectoral121210503pectoral
pectorals13128153pectorals
pelters93720313pelters
pesters93827093pesters
pestos84719083pesto_s
peters86624593pe_ters
petters93722363petters
pewters124113353pewters
pleaters103613793pleaters
plectra1145793plect_ra
plectron12228023plectron
plectrons13258073plectrons
pledgors12325263pledgors
plessors10278253plessors
plexors1645423ple_xors
prelectors1447873prelectors
pretors9316813pretors
proctors12311513proctors
questors17147013questors
raptors94213353raptors
reactor93011663reactor_
realtors82811683realtors
receptors1356923receptors
reciters102613113reciters
reckons13269653reckons
recolors1078813recolors
recons84922993rec_ons
recooks134711233recooks
record96117433rec_ord
records105213923rec_ords
recork126315493rec_ork
recorks134813023rec_orks
recross989843recross
recto74520803recto__
rectories11314663rectories
rectums11338523rectums
rectus83314633rect_us
recurs83315803rec_urs
redactors1247543redactors
redtops1037373redtops
reductors1246523reductors
reflectors1545503reflectors
rejectors18247613rejectors
relators83316133relators
renters74224813renters
resters74130403resters
restore75822983restore
restores85222993restores
retore67630773re_tore
retorn610923433re_torn
retort66831153re_tort
retorts76016513re_torts
retros63820193re_tros
rhetors1038513rhetors
rotors64917953_rotors
sartors7314973sartors
seaters74028943seaters
seccos1039923secco_s
secpars1138413secpars
secretors1145843secretors
sectary1238273sectary
sections102714703sections
sectoral10109543sectoral
sectored1138083sectored
sects75622893sect__s
seisors73212843seisors
seizors16329013seizors
selector1048623selector_
senators8312953senators
senhors103512133senhors
seniors73413623seniors
senors63620793se_nors
sensors73514643sensors
setons64620173se_tons
setous64917373se_tous
setters73822063setters
settlors8255013settlors
sextons143710413sextons
sextos134012163sexto_s
specters122811063specters
stators73915583stators
stentors839743stentors
stertors8310933stertors
succors1137413succors
suitors73012493suitors
tectums11306423tectums
teeters74018303teeters
tenors63217753te_nors
tensors72712373tensors
tenters73921103tenters
termors94712773termors
terrors73112213terrors
testers74124543testers
testons7313563testons
tetters74320473tetters
tictocs1145903tictocs
tors46157383___tors
tractors10312573tractors
tutors6912333_tutors
vectored1435643vectored
vendors113510223vendors
venters103717733venters
vetoers10359473ve_toers
vetoes92914083ve_toes
vetters104016323vetters
viators102712023viators
victor113210673victor_
victory15326983victory
weldors11238003weldors
welters103516063welters
westers105221963westers
wetters103817753wetters
zesters163517293zesters

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.403443402.0
2DLD Change Limit1340274005.89322743.4
3Display Results4004000.1532614.4
 (SQL Overall)1786914006.44927708.3
 
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.