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

359 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
erecters10261161(None) 
erecter93113391erecter_
erectors103514261erectors
detecters12217752detecters
effecters1764322effecters
ejectors17328662ejectors
electees10238722electees
electors103013842electors
erected103213992erecte_d
erectness1146122erectness
erector93513812erector_
erects84116182erect__s
exacters1736772exacters
executers1854182executers
expecters2045472expecters
fretters113410302fretters
greeters92610112greeters
perfecters1745432perfecters
presters103419002presters
reciters102613112_reciters
rectors93520522_rectors
reenters82915302reenters
rejecters18257542rejecters
renters74224812_renters
resters74130402_resters
specters122811062specters
treaters83615842treaters
ureters7311822ure_ters
wreckers17315972wreckers
wresters112711732wresters
abetters1057173abetters
affecters1763933affecters
arbiters1038853arbiters
archers124414573ar_chers
aretes64425353are_te_s
arresters948193arresters
averters11249513averters
beaters94925043_beaters
begetters12135043begetters
belters93819413_belters
bereavers1446123bereavers
besetters11136633besetters
betters94422093_betters
bleaters103412323bleaters
bracers114616703brac_ers
breachers16369853breachers
breakers143810973breakers
breathers14319103breathers
breeders11368893breeders
breviers1335923breviers
brewers123811063bre_wers
bruiters10329143bruiters
cementers1338313cementers
centers94420603_centers
cheaters133613513cheaters
checkers19317843checkers
crackers164111723crackers
crafters13419953crafters
craters95021893cr_aters
creamers124111313creamers
creasers103612833creasers
creates95225203create_s
creators102814413creators
creches14313093creche_s
creepers12318633creepers
critters103511323critters
crofters13358903crofters
decenters122410373decenters
deckers144413833_deckers
defeaters13289103defeaters
defectors15237883defectors
depicters1435823depicters
deserters10129983deserters
detecter11298733detecter_
detectors12278303detectors
deters74724683_de_ters
detesters10298303detesters
diesters92513603diesters
dieters83216433die_ters
directer1137583directer_
directors1248143directors
drafters12338523drafters
dreamers11369003dreamers
dredgers11256093dredgers
drenchers15296103drenchers
dressers9359863dressers
drifters12417913drifters
easters75125683e_asters
eaters65535953__eaters
eductors1135983eductors
effecter1664773effecter_
effectors1755033effectors
ejected17297653ejecte_d
ejector16378603ejector_
ejects15409953eject__s
elaters74420193e_laters
elected102812613electe_d
electee92513243electe_e
elector93313253elector_
electress1146113electress
electret10411993electret
electrets1146543electrets
electro92810033elect_ro
electros102811743electros
elects83315003elect__s
emeers83314183eme__ers
emenders11319033emenders
emeutes938013emeute_s
emitters10349643emitters
emoters94712873e_moters
enactors1038453enactors
enfetters1244463enfetters
enrichers1444133enrichers
enters64425643__enters
erasers74413943er_asers
erect74129333erect___
erectile1039513erectile
erecting112415063erecting
erection102115513erection
erections112515213erections
erective13311833erective
erectly1257483erect_ly
eremites10312603eremite_s
ergates8314493ergate_s
eructed10228653eructe_d
eructs83610793eruct__s
esters64627733__esters
etcetera1043183etcetera
etceteras1142653etceteras
etchers123411293e_tchers
eveners10109503eve_ners
evertors1138953evertors
evictees1344583evictees
evictors13276853evictors
exacter1637403exacter_
exactors1737013exactors
exalters1536653exalters
exciters1736323exciters
excreters1874873excre_ters
executer1745313executer_
executes1736533execute_s
executors1844653executors
expecter1936513expecter_
eyewaters1543603eyewaters
fermenters15116533fermenters
ferreters1246253ferreters
festers104121393_festers
fetters103517903_fetters
foresters12312533foresters
fracturs13146313fracturs
fraters103517213fr_aters
freers94717303fre__ers
freezers20307173freezers
frescoers1454563frescoers
fretter103412753fretter_
fritters113810783fritters
fruiters11328183fruiters
getters84216103_getters
grafters12409193grafters
granters93614143granters
graters85419743gr_aters
greasers93410253greasers
greatens9307593greatens
greater84416493greater_
greeter82812673greeter_
grifters12389233grifters
gristers94013403gristers
gritters94210633gritters
grocers103511253groc_ers
grouters95910083grouters
grunters9359033grunters
heaters104225223_heaters
hectors123513263_hectors
hefters134312003_hefters
hereafters1643593hereafters
infecters14257583infecters
jesters144118193_jesters
keesters12319593keesters
kelters113813753_kelters
kiesters123310153kiesters
kraters114212343kr_aters
kreutzers2241263kreutzers
kreuzers2132063kreuzers
lechers123313963_lechers
lectern937033_lectern
lecterns1035943_lecterns
lectors93415763_lectors
letters73819853_letters
meeters94714543_meeters
melters93918313_melters
mercers114412773mer_c_ers
meters85625833_me_ters
neckers134210463_neckers
nectars938463_nectars
neglecters1362933neglecters
nesters74422793_nesters
netters73618583_netters
neuters74212273_neuters
orbiters1036593orbiters
orienters937613orienters
overeaters1348633overeaters
peckers153312673_peckers
pectens11189203_pectens
pelters93720313_pelters
perchers153611523per_chers
perfecter1646043perfecter_
peripters1368123peripters
perverters1544963perverters
pesters93827093_pesters
peters86624593_pe_ters
petters93722363_petters
pewters124113353_pewters
piecers114112253piec_ers
pleaters103613793pleaters
praters94921653pr_aters
preachers16339573preachers
prealters1147773prealters
preavers13910263preavers
precess11310863prec_ess
preclears1344373preclears
precures12312903precures
preeners102712813preeners
prefers123713333pre_fers
preggers12236833preggers
premiers122911653premiers
pressers103215023pressers
prester93519623prester_
preterm11310163pre_term
preterms1237223pre_terms
pretors9316813pre_tors
preyers124412363pre_yers
pricers113915063pric_ers
prickers163710673prickers
printers103214903printers
proctors12311513proctors
protecters14168253protecters
questers17168763questers
racers84725433_rac_ers
rackers134320453_rackers
rafters103715633_rafters
ranters73323643_ranters
rasters74629023_rasters
raters63936583_r_aters
ratters74422473_ratters
reachers133515723reachers
reactors103212283reactors
readers83823773_readers
realters83614043realters
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
rebaters103413943rebaters
recanters112310483_recanters
recces10614913_recce_s
recess8314263_rec_ess
rechews1537293_rechews
reciter94117263_reciter_
recites93524583_recite_s
recovers133511123_recovers
rector84019753_rector_
rectory123512733_rectory
rectos85718783_rect_os
rectums11338523_rectums
rectus83314633_rect_us
recurs83315803_rec_urs
redders93615343_redders
reefers103312593_reefers
reekers113613143_reekers
reelers73520273_reelers
reenter73217793reenter_
refers93921083_re_fers
refuters11449613refuters
regretters1144093regretters
reheaters122010273reheaters
reinters82614773reinters
reivers105117083_reivers
rejectees18235423rejectees
rejecter17258943rejecter_
rejectors18247613rejectors
relaters83218153relaters
reletters9138783reletters
reliers75519213_reliers
renders83821673_renders
renter64527413_renter_
rentes65431193_rente_s
rentiers83311763_rentiers
repeaters112811993repeaters
repenters112511553repenters
rescuers1037363rescuers
resetters9129463resetters
respecters1445863respecters
rester63832433_rester_
retears72814923_re_tears
retems83914573_re_tems
retreaters1047543retreaters
reutters8138573reutters
revers94529633_re_vers
reverters122710433reverters
ricers84120993_ric_ers
rioters73615513_rioters
ritters74020623_ritters
rockers133916553_rockers
rooters74522933_rooters
rosters73727543_rosters
rotters74421393_rotters
routers74822873_routers
scepters1237793scepters
seaters74028943_seaters
sectors93116453_sectors
selectees1147013selectees
selectors1148963selectors
semesters1139123semesters
setters73822063_setters
sheeters113111863sheeters
shelters113412813shelters
skeeters12298963skeeters
skelters12349373skelters
smelters103310513smelters
specter113111733specter_
spectres12268683spectres
spelters103912243spelters
sweaters113811063sweaters
swelters113110193swelters
teeters74018303_teeters
tenters73921103_tenters
testers74124543_testers
tetters74320473_tetters
theaters114211903theaters
tracers94917843trac_ers
trackers143512853trackers
tractors10312563tractors
treaders93311843treaders
treater74219833treater_
trekkers1133803trekkers
trenchers14288073trenchers
trickers143812813trickers
trotters83310243trotters
truckers14279013truckers
trusters83112263trusters
trysters11298373trysters
tweeters11287143tweeters
ureter6313203ure_ter_
vectors123212593_vectors
venters103717733_venters
verditers1344993verditers
vetters104016323_vetters
welters103516063_welters
westers105221963_westers
wetters103817753_wetters
whetters14246653whetters
wreakers15328423wreakers
wreathers15257493wreathers
wrecker16367603wrecker_
wrenchers17256333wrenchers
wrester102812413wrester_
wrestlers12306103wrestlers
writers105513493wr_iters
zesters163517293_zesters

Search took 9 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.670266703.0
2DLD Change Limit1461623598.09318060.3
3Display Results3593590.1732075.1
 (SQL Overall)1786913598.93619996.8
 
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.