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

219 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
erector9351380(None) 
ejector16378601ejector
elector93313251elector
erecter93113391erecter
erectors103514251erectors
rector84019741_rector
creator93714432creator
defector14277952defector
detector11278322detector
director1147772director
eductor1035862eductor
effector1644872effector
ejectors17328662ejectors
electors103013842electors
electro92810032electro
enactor938032enactor
erect74129332erect__
erected103213992erected
erecters102611612erecters
erection102115512erection
erectly1257472erectly
erects84116182erect_s
evertor1038722evertor
evictor12346362evictor
exactor1636622exactor
executor1744832executor
hector113312652_hector
lector83514982_lector
pretor8315742pre_tor
proctor11310432proctor
reactor93011652reactor
recto74520802_recto_
rectors93520512_rectors
rectory123512722_rectory
rectos85718782_rectos
rejector17237722rejector
sector83415922_sector
selector1048602selector
tractor9311332tractor
vector113212062_vector
abettor956193abettor
actor71116073__actor
aerator7314843aer_ator
arrestor847643arrestor
bettor83612223_bettor
bisector1245193bisector
coactor1139113coactor
corrector1347593corrector
creators102814383creators
creditor1145893creditor
cremator1269173cremator
debtor938333_debtor
decor84717573_dec_or
defecator1546383defecator
defectors15237883defectors
deflector1555063deflector
depictor1355513depictor
detecter11298733detecter
detectors12278303detectors
detractor12147213detractor
directer1137583directer
directors1248133directors
directory1545863directory
doctor938993_doctor
editor738663e_ditor
educator1147153educator
eductors1135983eductors
effecter1664773effecter
effectors1755033effectors
eject145016043eject__
ejecta15337393eject_a
ejected17297653ejected
ejection172510043ejection
ejects15409953eject_s
elect74327033elect__
elected102812613elected
electee92513243electee
election102015353election
electoral1156723electoral
electron102611403electron
electros102811733electros
elects83315003elect_s
elevator1146713elevator
elicitor1045773elicitor
enactors1038443enactors
enactory1346143enactory
equator1637483equator
erectile1039513erectile
erecting112415063erecting
erections112515193erections
erective13311833erective
erenow937373ere_now
error53712233er__ror
eruct74022353eruct__
eructed10228653eructed
eructs83610793eruct_s
evection131910833evection
evertors1138953evertors
evictors13276853evictors
evocator1346573evocator
exacter1637403exacter
exactors1737013exactors
excitor1645993excitor
execrator1846563execrator
executer1745313executer
executors1844653executors
executory2143723executory
expecter1936513expecter
extractor1846723extractor
factor11911453_factor
feretory1447503fere_tory
fermentor1444693fermentor
fetor81214533_fe_tor
foetor939563foe_tor
fractur12135563fractur
fretter103412753fretter
functor1235203functor
grantor84010923grantor
greater84416493greater
greeter82812673greeter
hectors123513263_hectors
hereto9313693here_to_
heritor10310563her_itor
infector13478843infector
injector17236923injector
lectors93415763_lectors
lictor83610853_lictor
mentor8414363_mentor
nectar838853_nectar
neglector1253433neglector
nestor63713413_nestor
objector1943803objector
orator6314533or_ator
orectic1138823orectic
perfecter1646043perfecter
perfecto15105743perfecto_
perfectos16106073perfectos
permeator1347403permeator
persecutor1453243persecutor
praetor938973praetor
precatory1649113precatory
precentor1348733precentor
preceptor1547313preceptor
precook1577803precook
precool1139013precool
predator11310053predator
predictor1447093predictor
prelector1348093prelector
pressor93512873pressor
prester93519623prester
presto84216203presto_
prestore104217343prestore
prestos93716073prestos
pretors9316803pre_tors
proctors12311493proctors
projector20186683projector
prosector13208533prosector
protector13169533protector
questor16146633questor
raptor83912823_raptor
reactors103212283reactors
realtor73611353realtor
receptor1256693receptor
reciter94117263_reciter
reckon123010543_reckon
recolor978693_recolor
recon75624243_rec_on
recook125513923_recook
record96117423_rec_ord
recork126315483_rec_ork
recta74220263_rect_a
rectal84418133_rectal
recti73619623_rect_i
rectum103411283_rectum
rectus83314633_rectus
recur74116843_rec_ur
redactor1147023redactor
redtop937973_redtop
reductor1156433reductor
reecho11318653reecho_
reenactor1184353reenactor
reenter73217793reenter
refectory1746023refectory
reflector1445733reflector
refractor14156323refractor
rejecter17258943rejecter
rejectors18247613rejectors
relator74016363relator
renter64527413_renter
rerecord1145363rerec_ord
rester63832433_rester
restore75822973_restore
retore67630763_re_tore
retorn610923423_re_torn
retort66831143_re_tort
retractor11218513retractor
retro55020953_re_tro
rhetor938063_rhetor
rotor55519733_r_otor
secretor1045673secre_tor
sectors93116433_sectors
selectors1148943selectors
servitor1145053servitor
specter113111733specter
stentor739373stentor
stertor7310083stertor
tractors10312553tractors
traitor7310123traitor
treater74219833treater
treetop945523treetop
tremor84210393tre_mor
trisector1144323trisector
trustor7238403trustor
ureter6313203ure_ter
varactor1345673varactor
vectors123212593_vectors
victor113210673_victor
wrecker16367603wrecker
wrester102812413wrester

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.190940478.9
2DLD Change Limit1340272196.59320328.7
3Display Results2192190.0932354.8
 (SQL Overall)1786912196.87625987.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.