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

183 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
proctor1131043(None) 
proctors12311511proctors
doctor938992_doctor
erector93513812erector
praetor938972praetor
pretor8315752pr_etor
proctored1446422proctored
projector20186682projector
pronator10311782pronator
pronto8313992pronto_
prosector13208532prosector
protector13169532protector
proton84318892pro_ton
rector84019752_rector
rotor55519732_ro_tor
tractor9311342tractor
actor71116083__actor
coactor1139133coactor
creator93714443creator
crofter12299573crofter
croton84415453cro_ton
crouton947133crouton
director1147783director
doctors1039993_doctors
eductor1035863eductor
ejector16378603ejector
elector93313263elector
enactor938043enactor
erecter93113393erecter
erectors103514263erectors
evictor12346363evictor
evocator1346573evocator
exactor1636633exactor
factor11911463_factor
foetor939563_foetor
fractur12135573fractur
fronter103611583fronter
fronton1037203fronton
functor1235203functor
grantor84010943grantor
grocer94212143groc_er
grotto7349813grotto_
grottos8337333grottos
grouter84412523grouter
hector113312653_hector
isochor1244743isochor
kronor10417233kro_nor
lector83514993_lector
lictor83610863_lictor
locator93110423_locator
motor75317293_mo_tor
orator6314533or_ator
parachor1546663parachor
pastor84817483p_astor
perorator1149743perorator
photo104417233pho_to_
photog12379813pho_tog
photon1111514833pho_ton
photos113316643pho_tos
piscator1246923piscator
plotter94113663plotter
poco86826153p_oc_o_
ponton83217643p_onton
poofter1237163poofter
poor65630223p_o__or
porter84224413p_orter
poster84129173p_oster
postop10511943p_ostop
potter83926983p_otter
potto75320943p_otto_
pottos84615873p_ottos
pouter83923983p_outer
powter114116033p_owter
practic13312253practic
praetors1039833praetors
prater84825353pr_ater
precatory1649113precatory
precentor1348733precentor
preceptor1547323preceptor
precook1577803precook
precool1139013precool
predator11310053predator
predictor1447093predictor
prelector1348093prelector
pressor93512883pressor
prester93519623prester
presto84216203presto_
prestore104217353prestore
prestos93716083prestos
pretors9316813pr_etors
pricer103918293pric_er
pricier113313113pricier
pricker154013413pricker
printer93917303printer
prior74316173pr__ior
proaction13410103proaction
probatory1647113probatory
prober104516073pro_ber
procarp1346823procarp
proceed12310553proceed
process11310403process
processor1346233processor
procreator1465743procreator
proctodea1443803proctodea
proctorial1447513proctorial
proctoring1546673proctoring
procurator1445513procurator
procure1138573procure
procurer1235833procurer
prodder1147953prodder
proette9312363proette
proffer15126933proffer
profiter132710203profiter
progger11319373progger
projectors21187173projectors
prolabor1284543prolabor
prolocutor1453073prolocutor
prolog94212973pro_log
promisor12266183promisor
promo95620003pro_mo_
promos105116423pro_mos
promote11313143promote
promoter12311453promoter
prompter1437983prompter
pronators11411303pronators
pronota939763pronota
proof105221533pro__of
proofer12149103proofer
proper104319953pro_per
propretor1345533propretor
prosectors14199123prosectors
prosecutor1444413prosecutor
proser84223463pro_ser
prosier93817483prosier
proso77222413pro_so_
prosos85718553pro_sos
prospector1644363prospector
prosper114012193prosper
prost75434103prost__
prostie91617743prostie
protea82214763pro_tea
protecter13179103protecter
protectors142010143protectors
protectory17157483protectory
protei82615313pro_tei
protestor11178493protestor
protons93118003pro_tons
protractor1446263protractor
protyl11308213pro_tyl
prouder10310383prouder
prover113819723pro_ver
prowar114110943pro_war
prower114218123pro_wer
prowler123310013prowler
prutot8311823pr_utot
raptor83912823_raptor
reactor93011663reactor
recto74520803_recto_
rectors93520523_rectors
rectory123512733_rectory
rectos85718783_rectos
rhetor938063_rhetor
rocker124319573_rocker
rooter64926033_rooter
roster64329083_roster
rotator7310833_rotator
roto45935053_ro_to_
rotors64917953_ro_tors
rotos56027883_ro_tos
rotter64325463_rotter
router65025843_router
sector83415933_sector
tractors10312573tractors
traitor7310123traitor
trocar848773troc_ar
trochar1257073trochar
trotter73312253trotter
trustor7238413trustor
uprooter1085243uprooter
urochord1444453urochord
varactor1345703varactor
vector113212063_vector
victor113210673_victor

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.390458182.1
2DLD Change Limit1340271836.84319586.0
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.29624491.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.