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

450 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
peachers15321384(None) 
leachers133712811leachers
peacher144216071peacher_
peaches144120051peache_s
perchers153611521perchers
poachers152910761poachers
preachers16339571preachers
reachers133515721reachers
teachers133212391teachers
beaches144120652beache_s
belchers153510022belchers
benchers153611012benchers
bleachers16297922bleachers
breachers16369852breachers
coachers154312302coachers
detachers1536482detachers
etchers123411292_etchers
feathers143513242feathers
fetchers16328862fetchers
heathers143914732heathers
impeachers1942692impeachers
leacher124014842leacher_
leaches123319342leache_s
leathers114215082leathers
lechers123313962le_chers
pacers105124542p_ac_ers
packers153818892p_ackers
patchers153413302patchers
peaces106324082peac_e_s
peached154315882peache_d
peachier1548622peachier_
peahens12307572pea_hens
pearlers1039032pearlers
peckers153312672pe_ckers
percher143313422percher_
perches143717952perche_s
pinchers153510612pinchers
pitchers153211482pitchers
placers114515262plac_ers
plashers133813452plashers
pleaches153210432pleache_s
pleathers1446452pleathers
poacher143912322poacher_
poaches144416942poache_s
preacher153211372preacher_
preaches153214892preache_s
punchers152610072punchers
reacher123718292reacher_
reaches123423202reache_s
searchers14197352searchers
teacher123714832teacher_
teaches122718352teache_s
weathers143412832weathers
welchers16338052welchers
wenchers16319212wenchers
aches106132293__ache_s
aethers103614943ae_thers
apaches143411833apache_s
archers124414573_archers
attachers14134883attachers
baches135426943_bache_s
backers153821883_backers
bashers124820833_bashers
batchers153613273batchers
bathers124720363_bathers
beached154516553beache_d
beachgoers1842093beachgoers
beachier1538803beachier_
beaders104120183bea_ders
beakers134216873bea_kers
bearers94619593bea_rers
beaters94925043bea_ters
beavers124417323bea_vers
beeches143413883beeche_s
belcher143511493belcher_
belches143514343belche_s
bencher144113483bencher_
benches143918603benche_s
blanchers16307433blanchers
blathers134713793blathers
bleacher15358883bleacher_
bleaches153410673bleache_s
blenchers16356723blenchers
bluchers15359033bluchers
botchers153511543botchers
bracers114616703brac_ers
braches144621223brache_s
brachets154311983brachets
breacher153011503breacher_
breaches153714123breache_s
breathers14319103breathers
broachers16328153broachers
butchers153710183butchers
caches137926913_cache_s
cachets145014263_cachets
catchers153114063catchers
clackers163911703clackers
clashers134213993clashers
clenchers16276553clenchers
coacher143714123coacher_
coaches144018693coache_s
couchers153513863couchers
crackers164111723crackers
crashers134013233crashers
dackers143417043_dackers
dashers115016863_dashers
dealers84118613dea_lers
deashes113313903deashe_s
debauchers18122643debauchers
decayers14307963decayers
deckers144413833de_ckers
defacers14237993defac_ers
deicers103612733deic_ers
detacher1437543detacher_
detaches1439653detache_s
ditchers143610363ditchers
drenchers15296103drenchers
eagers74523683_ea_gers
earners74016453_earners
easters75125683_easters
eaters65535953_ea_ters
eches106322163_e_che_s
echoers12459693_e_choers
eschars1237183_eschars
eschews1534553_eschews
etcher113912943_etcher_
etches114217763_etche_s
ethers94518413_e_thers
euchres1288663_euchres
exacters1736773exacters
facers115519443_fac_ers
fathers133916503_fathers
fearers104815273fea_rers
feasters11511563feasters
feather133613503feather_
feathery17368073feathery
fencers123810623fenc_ers
fetcher153510393fetcher_
fetches153413893fetche_s
filchers16286863filchers
flashers143912653flashers
fletchers17335533fletchers
gathers114315073_gathers
glaciers11277893glaciers
hackers164619043_hackers
hatchers163113173hatchers
headers113819393hea_ders
healers104319463hea_lers
heapers123616673hea_pers
hearers104319783hea_rers
heaters104225223hea_ters
heathens143210153heathens
heather133914853heather_
heathery17349083heathery
heavers133717193hea_vers
hitchers16379993hitchers
impeacher1843093impeacher_
impeaches1843873impeache_s
inchers123912523_inchers
jackers204214453_jackers
kashers143914023_kashers
kenches163912273kenche_s
ketches164012193ketche_s
knackers13286843knackers
kvetchers2142373kvetchers
lacers85225253_lac_ers
laches116528343_lache_s
lackers134120543_lackers
lashers104121833_lashers
lathers104321883_lathers
leached133715043leache_d
leachier1337253leachier_
leaders83819603lea_ders
leaguers935063leaguers
leakers113415423lea_kers
leaners73718173lea_ners
leapers93716663lea_pers
learners8398153learners
leasers74717843lea_sers
leashes103514403leashe_s
leather103815783leather_
leathern11398913leathern
leathery14438973leathery
leavers103717783lea_vers
lecher113415853le_cher_
lechery15257643le_chery
leches115421313le_che_s
leeches123911933leeche_s
letches124015483letche_s
loaches123613983loache_s
loathers113310443loathers
lunchers13349563lunchers
lurchers13307153lurchers
lynchers16285453lynchers
macers105321273_mac_ers
maches134827233_mache_s
marchers153710813marchers
mashers124621053_mashers
matchers153012433matchers
meanders1168833meanders
meaners94415243mea_ners
menacers12279313menac_ers
mercers114412773merc_ers
merches144013763merche_s
moochers15369123moochers
munchers15318773munchers
naches114622413_nache_s
neatherd12107193neatherd
neatherds1395773neatherds
neckers134210463ne_ckers
notchers13279423notchers
ochers113915303__ochers
oraches124216473orache_s
pacer96131613p_ac_er_
paces96741113p_ac_e_s
pachas135017143p_ach_as
pacier105018683p_acier_
packer144223403p_acker_
packets155114773p_ackets
padders113312873p_adders
pagers94423253p_a_gers
palmers113513623p_almers
palters94021683p_alters
pampers133615933p_ampers
panaches15310283panache_s
panders103423733p_anders
paniers94717333p_aniers
panners93621273p_anners
panthers13510783panthers
panzers184012013p_anzers
papers105125323p_a_pers
parachors1647403parachors
parches143720003parche_s
parers85530743p_a_rers
parkers133816873p_arkers
parsers94118153p_arsers
pashes115828393p_ashe_s
passers94717753p_assers
pasters94531733p_asters
patcher143515143patcher_
patches143320383patche_s
paters84935833p_a_ters
patters94825193p_atters
patzers184210573p_atzers
paupers114311073p_aupers
pausers94113223p_ausers
pavers115021823p_a_vers
pawers114818783p_a_wers
pawners124311073p_awners
payers114621823p_a_yers
peace95026083peac_e__
peaced115818913peac_e_d
peach125422493peach___
peachiest1638533peachiest
peaching163613643peaching
peachy164510843peach__y
peacoats1247833peacoats
peacocks1844993peacocks
peages94321853pea_ge_s
peahen113410133pea_he_n
peakier134411443peakier_
peakless14236683peakless
pearler9310373pearler_
pears75138613pea___rs
pearter9412743pearter_
peases85229473pea_se_s
peatier94017233peatier_
peaveys15324063pea_veys
peavies122213403peavie_s
pechans14810503pe_chans
peched144915343pe_che_d
pechs125516203pe_ch__s
pecker144615363pe_cker_
pectens11189203pe_ctens
pedalers11239393pedalers
pedalfers1542903pedalfers
pedaliers1245183pedaliers
pedallers1244763pedallers
peddlers12298533peddlers
pedlers103013273pe_dlers
peelers93615593pe_elers
peepers113713673pe_epers
peers75130273pe___ers
pelters93720313pe_lters
pencels113610053penc_els
pencilers1345643pencilers
penners93414183pe_nners
penoches1538933penoche_s
pensters103012123pensters
penuches1536943penuche_s
peoplers1237163peoplers
peppers103311443pe_ppers
perched154713243perche_d
perusers10328803perusers
pesters93827093pe_sters
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
piaffers16114203piaffers
piasters102912813piasters
pickers153718093p_ickers
piecers114112253piec_ers
piercers12316723pierc_ers
pincers113916503pinc_ers
pincher143812713pincher_
pinches144117933pinche_s
pinschers1644383pinschers
pishers123815753p_ishers
pitcher143813713pitcher_
pitches143617753pitche_s
placaters1336473placaters
placer105117743plac_er_
places104323703plac_e_s
placets113911223plac_ets
plackets1646583plackets
plaguers11286503plaguers
plaiters103512633plaiters
planches153111863planche_s
planchets16236743planchets
planers94517943pla_ners
planners10399933planners
planters102915323planters
plasher124215033plasher_
plashes124417393plashe_s
plasters103518133plasters
platers93924093pla_ters
platters103415283platters
players124313763pla_yers
pleached16338063pleache_d
pleaders113210183plea_ders
pleasers104010293plea_sers
pleaters103613793plea_ters
pleather1356653pleather_
plenches153110623plenche_s
pluckers16316553pluckers
poached154212403poache_d
poachier1556823poachier_
pooches143214163pooche_s
porches143815673porche_s
pothers123818623p_others
pouches144116743pouche_s
praisers103410833praisers
prancers123210333prancers
praters94921653pra_ters
prawners1346003prawners
prayers124212853pra_yers
preached163412063preache_d
preachier1646923preachier_
prealters1147773prealters
preavers13910263prea_vers
prefacers1636293prefac_ers
pricers113915063pric_ers
prickers163710673prickers
psalters10227713psalters
psyches1755803psyche_s
puckers153514673p_uckers
puncher143311673puncher_
punches144816133punche_s
pushers123814503p_ushers
quashers20186803quashers
quenchers2343173quenchers
racers84725433_rac_ers
rachets124516833_rachets
rackers134320453_rackers
ranchers133311793ranchers
rashers104020913_rashers
reached134619083reache_d
reactors103212283reactors
readers83823773rea_ders
realters83614043realters
reamers94221083rea_mers
reapers93520453rea_pers
rearers74323563rea_rers
reavers108320743rea_vers
rechews1537293re_chews
regathers1336353regathers
rescuers1037363rescuers
retches123318513retche_s
roaches123616213roache_s
sachems14348903_sachems
sachets123914103_sachets
sackers133820223_sackers
sealers74323553sea_lers
seamers94719433sea_mers
searcher13209103searcher_
searches132112903searche_s
seaters74028943sea_ters
seiches12513813seiche_s
sheathers1557553sheathers
sketchers1834513sketchers
slackers143812743slackers
slashers113313613slashers
slathers113914783slathers
smackers16318713smackers
smashers13339593smashers
snackers143010223snackers
snatchers14146313snatchers
spacers113813873spac_ers
speakers14299453spea_kers
spearers103711143spea_rers
specters122811063spe_cters
speeches1537413speeche_s
spencers12269193spenc_ers
splashers1445283splashers
stackers143413563stackers
stanchers14206813stanchers
swashers14389533swashers
swathers144512083swathers
taches114224173_tache_s
tackers134319623_tackers
teacherly1743513teacherly
tearers75218233tea_rers
teasers75317243tea_sers
teethers11328713teethers
telphers1335473telphers
tenches123515523tenche_s
tethers103815313te_thers
thatchers1744583thatchers
tochers123413093_tochers
touchers133611213touchers
tracers94917843trac_ers
tracheas13410273tracheas
trackers143512853trackers
trashers113013643trashers
treachery1744693treachery
trenchers14288073trenchers
upgathers1582533upgathers
upreaches1654633upreache_s
vealers103214293vea_lers
vetches153411263vetche_s
vouchers16418623vouchers
washers134517523_washers
watchers163511793watchers
weaners104613833wea_ners
wearers104615903wea_rers
weather133513223weather_
weavers133714463wea_vers
weighers15135673weighers
welcher15319393welcher_
welches153710313welche_s
welshers14246813welshers
wencher153811133wencher_
wenches152914133wenche_s
wethers135214693we_thers
whackers20326543whackers
winchers16319223winchers
wreathers15257493wreathers
wrenchers17256333wrenchers
yachters1633883_yachters
yearners11346373yearners

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.420425454.8
2DLD Change Limit1461624506.65621959.4
3Display Results4504500.1902368.4
 (SQL Overall)1786914507.26624592.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.