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

420 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
peachy16451084(None) 
beachy164011251beachy
leachy14419731leachy
peach125422491peach_
poachy16388961poachy
preachy17307311preachy
achy126316092__achy
beach124623892beach_
beechy16397502beechy
deathy134210232deathy
each95530582_each_
eparchy17204752eparchy
heathy156111212heathy
leach105422522leach_
pacey126720282p_acey
pacha126518062p_acha
pacy115328682p_ac_y
patchy16509572patchy
peace95026082peac_e
peaced115818912peaced
peaces106324082peaces
peached154315882peached
peacher144216072peacher
peaches144120052peaches
peaky145718152pea_ky
pearly116414842pearly
peaty105725692pea_ty
peavey14398792peavey
peavy135014842pea_vy
pech116125452pe_ch_
pechs125516202pe_chs
pecky165515092pe_cky
perch124518832perch_
pitchy16479672pitchy
plashy14448872plashy
pleach134211242pleach_
poach124917862poach_
pouchy16538662pouchy
preach133613922preach_
punchy16398522punchy
reach105123882reach_
reechy14367822reechy
teach105221122teach_
techy135612012te_chy
tetchy1436002tetchy
yechy16519082ye_chy
ache96829823__ache
anarchy1544933anarchy
apache134210773apache
apathy1437033apathy
ashy107717353__ashy
bach116131393_bach_
beachboy2042913beachboy
beached154516553beached
beaches144120653beaches
beacon10511373beacon
beady114719923bea_dy
beaky146118023bea_ky
beamy126218573bea_my
beauty115410163beauty
beech124315503beech_
belch124415503belch_
bench125619503bench_
bitchy16479203bitchy
bleach133611403bleach_
botchy16537823botchy
brach126123303brach_
brachs134415753brachs
branchy17357913branchy
brashy145210593brashy
breach134213723breach_
breathy15328033breathy
bunchy16437463bunchy
cache125122483_cache
catchy16559583catchy
clach124617823clach_
clachs133511323clachs
coach125919453coach_
conchy163710223conchy
cracky175010223cracky
dacha114812573_dacha
dashy125612383_dashy
deacon9510423deacon
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
deary95826843dea_ry
deash95617243deash_
death94822523death_
deathly14336863deathly
deaths105914443deaths
decay114718483de_cay
decoy115716313de_coy
decry115514353de_cry
descry1256183descry
detach12310413detach_
diarchy1644673diarchy
drachm1436493drachm
duchy144310873_duchy
dyarchy1942503dyarchy
early85324123_early
earthy12399943_earthy
easy76224493_ea_sy
eath75735663_eath_
eche97520283_e_che
echo96615953_e_cho
echt95722903_e_cht
epact94921533epac_t
epacts105010393epacts
eparch13258423eparch_
eparchs14196243eparchs
epoch1248203epoch_
epochs1335813epochs
etch95419143_etch_
exarchy22193693exarchy
fealty122910223fealty
featly123711753featly
fetch134913473fetch_
fitchy17437623fitchy
flashy15498173flashy
headachy2043313headachy
heady125117263hea_dy
healthy16416083healthy
heapy135914983hea_py
hearty126313633hearty
heath115724283heath_
heaths126316383heaths
heavy144814183hea_vy
heuch135312333heuch_
heuchs14447923heuchs
hexarchy2642873hexarchy
impeach1644273impeach_
itchy13449013_itchy
jacky215412343_jacky
kench145513923kench_
ketch144912023ketch_
kvetchy2241803kvetchy
kwacha1832983kwacha
lacey105820913_lacey
lacy95829633_lac_y
lathy115215063_lathy
leached133715043leached
leacher124014843leacher
leaches123319343leaches
leady95618603lea_dy
leafy116316213lea_fy
leaky125217723lea_ky
leally94012613leally
lealty92910603lealty
leanly93811503leanly
leary85927383lea_ry
leash85519213leash_
leavy115715773lea_vy
lech96825443le_ch_
leech104913213leech_
legacy1256653legac_y
letch105215803letch_
loach105116363loach_
mach116134483_mach_
mache125925303_mache
macho126120153_macho
machs125722563_machs
mashy136016503_mashy
mealy104422183mea_ly
meanly115412043meanly
meany104620483mea_ny
measly113610443measly
meaty107021313mea_ty
menschy17354003menschy
merch125417963merch_
mercy125916183merc_y
meshy135612783me_shy
nacho105414383_nacho
nearby11356053nearby
nearly94813733nearly
neath86020283neath_
neatly93812483neatly
orach105219233orach_
orache114013593orache
pac79054083p_ac__
paca85132243p_ac_a
pacas96029403p_acas
pace86345773p_ac_e
paced106931683p_aced
pacer96131613p_acer
paces96741113p_aces
pachas135017143p_achas
pacify1667473p_acify
pack125535443p_ac_k
packly17228333p_ackly
packs135528933p_acks
pacs85842183p_ac_s
pact86648723p_ac_t
pacts95125803p_acts
paddy125913593p_addy
pah88853593p_a_h_
pally105727123p_ally
palmy126016733p_almy
palsy105417463p_alsy
paly95835533p_a_ly
panache1458423panache
pandy115021173p_andy
pansy105717973p_ansy
panty105929303p_anty
papacy1547493papac_y
pappy114713803p_appy
parch125123003parch_
pardy115523953p_ardy
parry105323753p_arry
party106630613p_arty
pash95638133p_ash_
pasha105417183p_asha
pasty105725053p_asty
patch125221223patch_
path99134913p_ath_
paths105521383p_aths
patly105020583p_atly
patsy105717203p_atsy
patty104723613p_atty
paty95234563p_a_ty
paunchy17324443paunchy
pawky173810153p_awky
pay88461183p_a__y
pea56657243pea___
peachers153213843peachers
peachier1548623peachier
peaching163613643peaching
peacing124117073peacing
peacoat11412913peacoat
peacock1745143peacock
peacocky2142453peacocky
peag75431343pea__g
peage84723563pea_ge
peages94321843peages
peags86122843pea_gs
peahen113410133peahen
peak106535203pea__k
peaked136117403peaked
peaks114825623pea_ks
peal68648103pea__l
pealed95322803pealed
peals75235493pea_ls
pean66147173pea__n
peans75437643pea_ns
peanut8318183peanut
pear69745233pea__r
pearl75324463pea_rl
pearls84715393pearls
pears75138613pea_rs
peart76440753pea_rt
peartly1267453peartly
peas65755063pea__s
peascod1244073peascod
pease75231113pea_se
peasen84815963peasen
peases85229473peases
peat65967933pea__t
peats76140193pea_ts
peaveys15324063peaveys
pebbly1545083pebbly
pec76744413pe_c__
pecan91919033pe_can
pecans101515833pecans
peccary1636283peccary
pechan13511543pe_chan
peched144915343pe_ched
peck125730683pe_c_k
pecks135724433pe_cks
pecs84634103pe_c_s
peery105719443pe_ery
peh86740963pe__h_
pehs95625763pe__hs
peltry11288653peltry
penally121111763penally
penalty1267743penalty
pence94924453penc_e
pencel103812913pencel
pencil103712973pencil
penny105119453pe_nny
penoche1447043penoche
pentarchy1942723pentarchy
penuche1435943penuche
penuchi1444033penuchi
penury1148103penury
peony105717563pe_ony
peppy114310363pe_ppy
peracid12312993peracid
perched154713233perched
percher143313423percher
perches143717953perches
perdy115417323pe_rdy
perky145319483pe_rky
peroxy1838243peroxy
perry105222713pe_rry
pertly115312543pertly
pesky145911563pe_sky
pesty106421713pe_sty
petty105320293pe_tty
picacho1644733picacho
picky165416943p_icky
pinch125619303pinch_
piracy1339473pirac_y
pitch125018413pitch_
pithy135614463p_ithy
place94824613plac_e
placed114318003placed
placer105117743placer
places104323703places
placet103923673placet
placid114012543placid
plack135017843plac_k
placks144414153placks
plaguy12386413plaguy
planch133711443planch_
planche14299753planche
plash104616563plash_
platy105021663pla_ty
play95928983pla__y
pleached16338063pleached
pleaches153210433pleaches
plench134010813plench_
plucky17406583plucky
plushy14406973plushy
poached154212403poached
poacher143912323poacher
poaches144416943poaches
pocky165314603p_ocky
poncho133310123poncho
pooch124815303pooch_
porch125918623porch_
pouch124617083pouch_
prahu105013973pra_hu
pray96331533pra__y
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preachify2243053preachify
preachily1945143preachily
preact103220393preac_t
preacts113211363preacts
prelacy1437583prelac_y
pricey134412633pricey
pricky174210343pricky
pricy124814563pric_y
psych1554963psych_
psyche1674293psyche
psycho1674533psycho
psychs1653653psychs
punch125118423punch_
pushy134614353p_ushy
quacky24376963quacky
racy95825683_rac_y
reached134619083reached
reacher123718293reacher
reaches123423203reaches
react74634333reac_t
reacts83616603reacts
ready94821503rea_dy
really93315613really
realty92713693realty
reecho11318653reecho
retch104818303retch_
roach105717003roach_
seamy105921273sea_my
search113312423search_
seaway12309993seaway
seiche11811833seiche
sketchy1943053sketchy
snatchy15355293snatchy
spacey136212533spacey
spacy125415623spac_y
speech1347563speech_
spinachy1842793spinachy
splashy1543553splashy
starchy15286743starchy
stenchy15256213stenchy
tach96132753_tach_
tache106222373_tache
tachs105820933_tachs
tacky145617443_tacky
teacher123714833teacher
teaches122718353teaches
teacup1036253teacup
teapoy1138113teapoy
teary85124053tea_ry
tech95925443te_ch_
techs106915833te_chs
tench105620003tench_
teuch105214853teuch_
thatchy1833303thatchy
thearchy1943443thearchy
torchy14549533torchy
touchy145010503touchy
trashy12509053trashy
treacly1237093treacly
upreach1444693upreach_
vealy115817773vea_ly
vetch134411843vetch_
vichy1639043_vichy
wacky174714933_wacky
washy145911843_washy
weakly1636483weakly
wealthy16314333wealthy
weary115620613wea_ry
wecht13415443we_cht
welch134411493welch_
wench136214783wench_
whacky21556493whacky
witchy17468593witchy
wrathy15377853wrathy
wreathy16326063wreathy
yacht13417393_yacht
yeah106725413yea_h_
yeahs115214553yea_hs
yearly125210273yearly
yeasty12438693yeasty
yecch15558093yecch_
yecchs16414953yecchs
yech127220533ye_ch_
yechs136112583ye_chs

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127164205.32621163.3
3Display Results4204200.1263333.3
 (SQL Overall)1786914205.57832035.0
 
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.