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

362 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
hectors12351326(None) 
hector113312651hector_
lectors93415761lectors
rectors93520521rectors
sectors93116451sectors
vectors123212591vectors
actors81016762_actors
bettors93312472bettors
debtors1038532debtors
decors94017772dec_ors
doctors1039992doctors
ejectors17328662ejectors
electors103013842electors
erectors103514262erectors
factors12912122factors
fetors91014472fe_tors
heaters104225222heaters
hectare1238462hectare
hectares1338852hectares
hectored1436872hectored
hefters134312002hefters
heritors11310902heritors
lector83514982lector_
lictors93212592lictors
mentors9314992mentors
nectars938462nectars
nestors73614972nestors
reactors103212282reactors
rector84019752rector_
rectory123512732rectory
rectos85718782recto_s
rhetors1038512rhe_tors
sector83415932sector_
vector113212062vector_
victors123311182victors
abators94413083abators
abettors1056133abettors
acetous9410363acetous
actor71116073_actor_
aerators8315613aerators
anchors123912953anchors
beaters94925043beaters
beckons15279143beckons
beclogs1237073beclogs
belters93819413belters
bentos86218303bento_s
bestirs9311133bestirs
bestows1248863bestows
betons84919553be_tons
betters94422093betters
bettor83612223bettor_
bevors111610343be_vors
bisectors1345733bisectors
cantors94620753cantors
captors113914983captors
castors94919443castors
censors93611843censors
centers94420603centers
centos85920463cento_s
cestos84718093cesto_s
chantors133710263chantors
cheaters133613513cheaters
checkers19317843checkers
chelators1448163chelators
coactors1239473coactors
cors66656443__c_ors
creators102814413creators
debtor938333debtor_
deckers144413833deckers
decolors1187713decolors
decor84717573dec_or_
decos85522123dec_o_s
decoys123911283dec_oys
defectors15237883defectors
delators92314823delators
depictors1465943depictors
detectors12278303detectors
deters74724683de_ters
detours858043de_tours
directors1248143directors
doctor938993doctor_
eaters65535953_eaters
echoers12459693_echoers
echoes114715523_echoes
echos105216463_echo_s
ecotours1044463_ecotours
editors839423editors
eductors1135983eductors
effectors1755033effectors
ejector16378603ejector_
elector93313253elector_
electros102811743electros
enactors1038453enactors
enters64425643_enters
ephors11311403_ephors
erecters102611613erecters
erector93513813erector_
errors63311313_errors
esters64627733_esters
estops84011223_estops
evertors1138953evertors
evictors13276853evictors
exactors1737013exactors
excitors1746093excitors
executors1844653executors
extols1337683_extols
extort13513973_extort
extorts1447753_extorts
factor11911453factor_
factory15108343factory
fervors1336233fervors
festers104121393festers
fetor81214533fe_tor_
fetters103517903fetters
foetors1039763foetors
functors1335743functors
gators74115833_gators
geckoes14325793geckoes
geckos13457433gecko_s
genitors937423genitors
gentoos838633gentoos
getters84216103getters
ghettoes1243493ghettoes
ghettos1134473ghetto_s
hackers164619043hackers
hafters134614333hafters
haftoros1444173haftoros
halters104619803halters
harbors12412413harbors
haters94930403h_aters
hatters104221523hatters
haviors1347383haviors
headers113819393headers
healers104319463healers
heapers123616673heapers
hearers104319783hearers
hears86737373he__ars
heater94828303heater_
heathers143914733heathers
heaths126316383heat_hs
heats85838403heat__s
heavers133717193heavers
hecatomb1742973hecatomb
hecatombs1841933hecatombs
hecklers17357123hecklers
heckles163711383heckles
hecks145220653hec__ks
hectic132311523hect_ic
hectogram17115813hectogram
hectograms18114813hectograms
hectoring1538303hectoring
heders104119763he_ders
hedgers124310263hedgers
heeders114213743heeders
heelers103815623heelers
hefter124313923hefter_
hefts116218153heft__s
heifers1337933heifers
heinous1038853heinous
heirs85618563he__irs
heisters113413133heisters
hektare1435503hektare
hektares1535813hektares
helios94816633helio_s
hellers103619833hellers
helloes103717463helloes
hellos95321683hello_s
helos84928063he_lo_s
helotry1345653helotry
helots95217703he_lots
helpers123311853helpers
hemmers143310843hemmers
hencoops1543213hencoops
hents87330743hent__s
heptads1335873heptads
heptose1237493heptose
heptoses1338373heptoses
herders113914123herders
heriots10312063heriots
heritor10310563heritor_
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
hers75844873he___rs
herstory1446693herstory
hertzes1938303hertzes
hests85829933hest__s
hetero9312633he_tero
heteros10312683he_teros
heths116317783he_t_hs
hets75547203he_t__s
hewers123715273he_wers
hexers165612753he_xers
hickory1943903hickory
hinters103719583hinters
history1339423history
hitters104717593hitters
hockers163915913hockers
honors94816793h_onors
hooters104520473hooters
horrors1078693horrors
humors11129633h_umors
hunters103915733hunters
hurters103413643hurters
ichors11310423_ichors
infectors14218553infectors
injectors18216723injectors
jesters144118193jesters
jetons134512613je_tons
jettons1437273jettons
kelters113813753kelters
ketols104210763ke_tols
lechers123313963lechers
lectern937033lectern
lecterns1035943lecterns
lectins92515003lectins
lections102413843lections
lecture9149513lecture
lectures101310153lectures
legators92811033legators
lentos65317403lento_s
leptons91910433leptons
lessors73610523lessors
letters73819853letters
levators11249283levators
lictor83610853lictor_
locators102910433locators
meeters94714543meeters
melters93918313melters
meltons9410923meltons
mentor8414363mentor_
meteors94610013meteors
meters85625833me_ters
metols84115773me_tols
metros84217803me_tros
motors84616603_motors
mucors104410853muc_ors
neckers134210463neckers
nectar838853nectar_
nectary1246223nectary
negators92411173negators
nektons1136393nektons
nesters74422793nesters
nestor63713423nestor_
netops839213ne_tops
netters73618583netters
neuters74212273neuters
newtons1036813newtons
objectors2044053objectors
orators7313823orators
pastors94119003pastors
peckers153312673peckers
pectens11189203pectens
pectins112315233pectins
pectoral121210503pectoral
pectorals13128153pectorals
pelters93720313pelters
pesters93827093pesters
pestos84719083pesto_s
peters86624593pe_ters
petters93722363petters
pewters124113353pewters
pretors9316813pretors
proctors12311513proctors
questors17147013questors
raptors94213353raptors
reactor93011653reactor_
realtors82811683realtors
receptors1356923receptors
reciters102613113reciters
reckons13269653reckons
recolors1078813recolors
recons84922993rec_ons
recooks134711233recooks
record96117433rec_ord
records105213923rec_ords
recork126315493rec_ork
recorks134813023rec_orks
recross989833recross
recto74520803recto__
rectories11314643rectories
rectums11338523rectums
rectus83314633rect_us
recurs83315803rec_urs
redactors1247533redactors
redtops1037373redtops
reductors1246523reductors
rejectors18247613rejectors
relators83316123relators
renters74224813renters
resters74130403resters
restore75822983restore
restores85222993restores
retore67630773re_tore
retorn610923433re_torn
retort66831153re_tort
retorts76016513re_torts
retros63820193re_tros
rhetor938063rhe_tor_
rotors64917953_rotors
sartors7314973sartors
seaters74028943seaters
seccos1039923secco_s
secpars1138413secpars
secretors1145843secretors
sectary1238273sectary
sections102714703sections
sectoral10109543sectoral
sectored1138063sectored
sects75622893sect__s
seisors73212843seisors
seizors16329013seizors
selectors1148963selectors
senators8312953senators
senhors103512133senhors
seniors73413623seniors
senors63620793se_nors
sensors73514643sensors
setons64620173se_tons
setous64917373se_tous
setters73822063setters
settlors8255013settlors
sextons143710413sextons
sextos134012163sexto_s
sheeters113111863sheeters
shelters113412813shelters
specters122811063specters
stators73915583stators
stentors839743stentors
stertors8310933stertors
succors1137413succors
suitors73012493suitors
tectums11306423tectums
teeters74018303teeters
tenors63217753te_nors
tensors72712373tensors
tenters73921103tenters
termors94712773termors
terrors73112213terrors
testers74124543testers
testons7313563testons
tetters74320473tetters
theaters114211903theaters
tictocs1145903tictocs
tors46157383___tors
tractors10312563tractors
tutors6912333_tutors
vectored1435623vectored
vendors113510223vendors
venters103717733venters
vetoers10359473ve_toers
vetoes92914083ve_toes
vetters104016323vetters
viators102712023viators
victor113210673victor_
victory15326983victory
weldors11238003weldors
welters103516063welters
westers105221963westers
wetters103817753wetters
whetters14246653whetters
zesters163517293zesters

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.423422437.4
2DLD Change Limit1340273626.93619323.4
3Display Results3623620.1402585.7
 (SQL Overall)1786913627.49923828.6
 
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.