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

172 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
proctors1231151(None) 
proctor11310431proctor_
doctors1039992_doctors
erectors103514262erectors
praetors1039832praetors
pretors9316812pr_etors
proctored1446422proctored
projectors21187172projectors
pronators11411302pronators
prosectors14199122prosectors
protectors142010142protectors
protons93118002pro_tons
rectors93520522_rectors
rotors64917952_ro_tors
tractors10312572tractors
actors81016773__actors
coactors1239483coactors
creators102814423creators
crofters13358913crofters
crotons93714373cro_tons
croutons1036753croutons
directors1248143directors
doctor938993_doctor_
eductors1135983eductors
ejectors17328663ejectors
electors103013863electors
enactors1038463enactors
erecters102611613erecters
erector93513813erector_
evictors13276863evictors
evocators1446713evocators
exactors1737023exactors
factors12912133_factors
foetors1039763_foetors
fracturs13146323fracturs
frontons1136503frontons
functors1335743functors
grantors93810363grantors
grocers103511253groc_ers
grottoes9276753grottoes
grottos8337333grotto_s
grouters95910093grouters
hectors123513263_hectors
isochors1355673isochors
lectors93415773_lectors
lictors93212603_lictors
locators102910433_locators
motors84616603_mo_tors
orators7313823or_ators
parachors1647413parachors
pastors94119003p_astors
perorators1249353perorators
photogs13358213pho_togs
photons123814433pho_tons
photos113316643pho_to_s
piscators1347083piscators
plotters104011553plotters
pontons93315553p_ontons
poofters1336923poofters
porters93722703p_orters
posters93928013p_osters
postops11311713p_ostops
potters94024343p_otters
pottos84615873p_otto_s
pouters94221873p_outers
powters124015663p_owters
praetor938973praetor_
praters94921653pr_aters
precatory1649123precatory
precentors1488343precentors
preceptors1657053preceptors
precious12310593precious
precooks1656763precooks
precools1237703precools
predators12310093predators
predictors1547273predictors
prelectors1447883prelectors
pressors103212693pressors
presters103419003presters
prestore104217353prestore
prestores114716083prestores
prestos93716093presto_s
pretor8315753pr_etor_
pricers113915063pric_ers
prickers163710673prickers
printers103214913printers
priors83914483pr__iors
proactions1449343proactions
probatory1647113probatory
probers113514583pro_bers
procarp1346823proc_arp
procarps1445973procarps
proceeds1335983proceeds
process11310403proc_ess
processors1446433processors
procreators1575713procreators
proctitis1348373proctitis
proctodea1443803proctodea
proctorial1447513proctorial
proctoring1546673proctoring
proctorship20164823proctorship
procurators1545173procurators
procure1138573proc_ure
procurers1345033procurers
procures1239213procures
prodders1237463prodders
proettes10312763proettes
proffers16126593proffers
profiters14228313profiters
proggers12258163proggers
projector20186683projector_
prolocutors1563113prolocutors
prologs103512133pro_logs
promisors13236363promisors
promos105116423pro_mo_s
promoters13310093promoters
promotes12314123promotes
prompters1537553prompters
pronator10311783pronator_
pronatores1247373pronatores
pronto8313993pronto__
proofers13118363proofers
proofs114511683pro__ofs
propers113619033pro_pers
propretors1445793propretors
proptoses1349873proptoses
proptosis1348203proptosis
prosector13208533prosector_
prosecutors1564463prosecutors
prosers94219643pro_sers
prosos85718553pro_so_s
prospectors1754583prospectors
prospers123012263prospers
prosties101421193prosties
proteas92015123pro_teas
protecters14168263protecters
protector13169533protector_
protectory17157483protectory
protestors12169313protestors
proteus92511593pro_teus
proton84318893pro_to_n
protractors1546623protractors
protyls12298463pro_tyls
provers123817793pro_vers
prowlers13328933prowlers
raptors94213353_raptors
reactors103212293reactors
rector84019753_rector_
rectory123512733_rectory
rectos85718793_recto_s
rhetors1038513_rhetors
rockers133916553_rockers
rooters74522933_rooters
rosters73727553_rosters
rotators8310203_rotators
rotor55519733_ro_tor_
rotos56027883_ro_to_s
rotters74421393_rotters
routers74822873_routers
sectors93116453_sectors
tractor9311343tractor_
traitors8310793traitors
trocars959043troc_ars
trochars1377853trochars
trotters83310253trotters
trustors8268913trustors
uprooters1164253uprooters
urochord1444453urochord
urochords1544213urochords
varactors1446413varactors
vectors123212593_vectors
victors123311183_victors

Search took 10 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621728.78016647.2
3Display Results1721720.0802150.0
 (SQL Overall)1786911729.26619284.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.