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

213 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
erectors10351425(None) 
ejectors17328661ejectors
electors103013841electors
erecters102611611erecters
erector93513801erector_
rectors93520511_rectors
creators102814402creators
defectors15237882defectors
detectors12278302detectors
directors1248132directors
eductors1135982eductors
effectors1755032effectors
ejector16378602ejector_
elector93313252elector_
electros102811742electros
enactors1038452enactors
erecter93113392erecter_
erections112515212erections
erects84116182erect__s
evertors1138952evertors
evictors13276852evictors
exactors1737012exactors
executors1844652executors
hectors123513262_hectors
lectors93415762_lectors
pretors9316802pre_tors
proctors12311512proctors
reactors103212282reactors
rector84019742_rector_
rectory123512722_rectory
rectos85718782_recto_s
rejectors18247612rejectors
sectors93116442_sectors
selectors1148952selectors
tractors10312562tractors
vectors123212592_vectors
abettors1056133abettors
actors81016763__actors
aerators8315613aer_ators
arrestors958023arrestors
bettors93312473_bettors
bisectors1345733bisectors
coactors1239473coactors
correctors1447493correctors
creator93714433creator_
creditors1245863creditors
cremators1369803cremators
debtors1038533_debtors
decors94017773_dec_ors
defecators1656253defecators
defector14277953defector_
deflectors1654773deflectors
depictors1465943depictors
detecters12217753detecters
detector11278323detector_
detractors13147293detractors
director1147773director_
directory1545873directory
doctors1039993_doctors
editors839423e_ditors
educators1246993educators
eductor1035863eductor_
effecters1764323effecters
effector1644873effector_
ejections18249963ejections
ejects15409953eject__s
electees10238723electees
elections112414973elections
electoral1156723electoral
electro92810033elect_ro
electron102611413electron
electrons112411753electrons
elects83315003elect__s
elevators1246303elevators
elicitors1145803elicitors
enactor938033enactor_
enactory1346143enactory
equators1737473equators
erect74129333erect___
erected103213993erect_ed
erectile1039513erectile
erecting112415063erecting
erection102115513erection
erective13311833erective
erectly1257473erect_ly
erectness1146123erectness
errors63311313er__rors
eructs83610793eruct__s
evections142510693evections
evertor1038723evertor_
evictor12346363evictor_
evocators1446713evocators
exacters1736773exacters
exactor1636623exactor_
excitors1746093excitors
execrators1946023execrators
executers1854183executers
executor1744833executor_
executory2143723executory
expecters2045473expecters
extractors1946423extractors
factors12912123_factors
feretory1447503fere_tory
fermentors1594233fermentors
fetors91014473_fe_tors
foetors1039763foe_tors
fracturs13146313fracturs
fretters113410303fretters
functors1335743functors
grantors93810353grantors
greeters92610113greeters
hector113312653_hector_
heritors11310903her_itors
infectors14218553infectors
injectors18216723injectors
lector83514983_lector_
lictors93212593_lictors
mentors9314993_mentors
nectars938463_nectars
neglectors1363533neglectors
nestors73614973_nestors
objectors2044053objectors
orators7313823or_ators
perfecters1745433perfecters
perfectos16106073perfecto_s
permeators1447403permeators
persecutors1553153persecutors
praetors1039833praetors
precatory1649113precatory
precentors1488343precentors
preceptors1657053preceptors
precious12310593precious
precooks1656763precooks
precools1237703precools
predators12310083predators
predictors1547263predictors
prelectors1447863prelectors
pressors103212683pressors
presters103419003presters
prestore104217343prestore
prestores114716083prestores
prestos93716083presto_s
pretor8315743pre_tor_
proctor11310433proctor_
projectors21187173projectors
prosectors14199123prosectors
protectors142010143protectors
questors17147013questors
raptors94213353_raptors
reactor93011653reactor_
realtors82811683realtors
receptors1356923receptors
reciters102613113_reciters
reckons13269653_reckons
recolors1078813_recolors
recons84922993_rec_ons
recooks134711233_recooks
record96117423_rec_ord
records105213923_rec_ords
recork126315483_rec_ork
recorks134813023_rec_orks
recross989833_recross
recto74520803_recto__
rectories11314643_rectories
rectums11338523_rectums
rectus83314633_rect_us
recurs83315803_rec_urs
redactors1247533redactors
redtops1037373_redtops
reductors1246523reductors
reechoes1338413reechoes
reenactors1294383reenactors
reenters82915303reenters
refectory1746023refectory
reflectors1545503reflectors
refractors15156273refractors
rejecters18257543rejecters
rejector17237723rejector_
relators83316123relators
renters74224813_renters
rerecord1145363rerec_ord
rerecords1244003rerec_ords
resters74130403_resters
restore75822973_restore
restores85222993_restores
retore67630763_re_tore
retorn610923423_re_torn
retort66831143_re_tort
retorts76016513_re_torts
retractors12158583retractors
retros63820193_re_tros
rhetors1038513_rhetors
rotors64917953_r_otors
secretors1145833secre_tors
sector83415923_sector_
selector1048603selector_
servitors1245203servitors
specters122811063specters
stentors839733stentors
stertors8310923stertors
tractor9311333tractor_
traitors8310793traitors
treaters83615843treaters
treetops1045463treetops
tremors93711223tre_mors
trisectors1244463trisectors
trustors8268913trustors
ureters7311823ure_ters
varactors1446393varactors
vector113212063_vector_
victors123311183_victors
wreckers17315973wreckers
wresters112711733wresters

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622137.17020385.2
3Display Results2132130.0962218.8
 (SQL Overall)1786912137.42224075.9
 
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.