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

330 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
perchers15361152(None) 
peachers153213841peachers
percher143313421percher_
perches143717951perche_s
archers124414572_archers
belchers153510022belchers
benchers153611012benchers
etchers123411292_etchers
fetchers16328862fetchers
leachers133712812leachers
lechers123313962le_chers
lurchers13307152lurchers
marchers153710812marchers
mercers114412772merc_ers
merches144013762merche_s
parches143720002parche_s
patchers153413302patchers
peacher144216072peacher_
peaches144120052peache_s
peckers153312672pe_ckers
perched154713242perche_d
perusers10328802perusers
piercers12316722pierc_ers
pinchers153510612pinchers
pitchers153211482pitchers
poachers152910762poachers
porches143815672porche_s
preachers16339572preachers
punchers152610072punchers
reachers133515722reachers
searchers14197352searchers
teachers133212392teachers
welchers16338052welchers
wenchers16319212wenchers
aethers103614943ae_thers
amercers1256133amerc_ers
archer115016243_archer_
archery15478063_archery
arches114822043_arche_s
batchers153613273batchers
beaches144120653beache_s
beeches143413883beeche_s
belcher143511493belcher_
belches143514343belche_s
bencher144113483bencher_
benches143918603benche_s
birches143412323birche_s
bleachers16297923bleachers
blenchers16356723blenchers
bluchers15359033bluchers
botchers153511543botchers
breachers16369853breachers
burghers1435633burghers
butchers153710183butchers
catchers153114063catchers
circlers1235353circlers
clenchers16276553clenchers
coachers154312303coachers
coercers1237653coerc_ers
couchers153513863couchers
creches14313093creche_s
curches143512743curche_s
deckers144413833de_ckers
decreers11277623decreers
decriers11299733decriers
deicers103612733deic_ers
deriders102411853deriders
derivers123811363derivers
detachers1536483detachers
ditchers143610363ditchers
drenchers15296103drenchers
eches106322163_e_che_s
echoers12459693_e_choers
enrichers1444133enrichers
erasers74413943_erasers
erecters102611613_erecters
eschars1237183_eschars
eschews1534553_eschews
etcher113912943_etcher_
etches114217763_etche_s
ethers94518413_e_thers
euchres1288663_euchres
farcers124713443farc_ers
feathers143513243feathers
fencers123810623fenc_ers
fetcher153510393fetcher_
fetches153413893fetche_s
filchers16286863filchers
fletchers17335533fletchers
forcers124215713forc_ers
furthers1436493furthers
hatchers163113173hatchers
heathers143914733heathers
herders113914123her_ders
hitchers16379993hitchers
impeachers1942693impeachers
inchers123912523_inchers
jerkers18287083jer_kers
kenches163912273kenche_s
kerchiefs2141763kerchiefs
ketches164012193ketche_s
kvetchers2142373kvetchers
larches124416453larche_s
leacher124014843leacher_
leaches123319343leache_s
leathers114215083leathers
lecher113415853le_cher_
lechery15257643le_chery
leches115421313le_che_s
leeches123911933leeche_s
letches124015483letche_s
lunchers13349563lunchers
lurcher12338133lurcher_
lurches123311663lurche_s
lynchers16285453lynchers
marcher143912973marcher_
marches143921173marche_s
matchers153012433matchers
mercer105214203merc_er_
mercery14397623merc_ery
merces105720743merc_e_s
mercies113817563mercie_s
mergers103813423mer_gers
moochers15369123moochers
munchers15318773munchers
murthers1336543murthers
neckers134210463ne_ckers
northers1139333northers
notchers13279423notchers
ochers113915303__ochers
pacers105124543p_ac_ers
packers153818893p_ackers
panthers13510783panthers
parachors1647413parachors
paraders113113113paraders
parcels113712663parc_els
parceners1337453parceners
parched154013693parche_d
parcheesi16233763parcheesi
parchesi15358213parchesi
parchesis16318213parchesis
pardners11269193pardners
parers85530743par__ers
parkers133816873par_kers
parriers103612903parriers
parsers94118153par_sers
partiers103514243partiers
partners102711133partners
partyers13277763partyers
patcher143515143patcher_
patches143320383patche_s
peaces106324083peac_e_s
peached154315883peache_d
peachier1548623peachier_
peahens12307573pe_ahens
pearlers1039033pearlers
pechans14810503pe_chans
peched144915343pe_che_d
pechs125516203pe_ch__s
pecker144615363pe_cker_
pectens11189203pe_ctens
pedalers11239393pedalers
peddlers12298533peddlers
pedlers103013273pe_dlers
peelers93615593pe_elers
peepers113713673pe_epers
peers75130273pe___ers
pelters93720313pe_lters
pencels113610053penc_els
pencilers1345643pencilers
penners93414183pe_nners
penoches1538933penoche_s
pensters103012123pensters
penuches1536943penuche_s
peoplers1237163peoplers
peppers103311443pe_ppers
percales12313803percales
perceivers1743893perceivers
percent113520603perc_ent
percents122713373percents
percept133112523perc_ept
percepts14247643percepts
perch124518833perch___
perching163711633perching
percoids1339663percoids
percuss1137163perc_uss
perdues103511333perdue_s
perdures11289683perdures
peres76246643per__e_s
perfecters1745433perfecters
perfumers1683713perfumers
perhaps1446123per_haps
periderm1346803periderm
periderms1444993periderms
perigees1189503perigees
periphery1943843periphery
peripters1368123peripters
perishes13313753perishe_s
perjurers18224463perjurers
perjures17268083perjures
perkier133813123perkier_
perries93226603perrie_s
perses85428063per_se_s
perter84422283per_ter_
pertness10310093pertness
perukes133210113peruke_s
peruser93511373peruser_
peruses94018163peruse_s
pervaders1544433pervaders
perverse1336103per_verse
pervert12315583per_vert
perverts1337533per_verts
pesters93827093pe_sters
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
pickers153718093p_ickers
piecers114112253piec_ers
piercer11337773pierc_er_
pierces113411193pierc_e_s
pincers113916503pinc_ers
pincher143812713pincher_
pinches144117933pinche_s
pinschers1644383pinschers
pishers123815753p_ishers
pitcher143813713pitcher_
pitches143617753pitche_s
placers114515263plac_ers
plashers133813453plashers
pleaches153210433pleache_s
pleathers1446453pleathers
plenches153110623plenche_s
pluckers16316553pluckers
poacher143912323poacher_
poaches144416943poache_s
pooches143214163pooche_s
porkers134314933por_kers
porters93722703por_ters
pothers123818623p_others
pouches144116743pouche_s
praters94921653p_raters
prayers124212853p_rayers
preacher153211373preacher_
preaches153214893preache_s
preavers13910263preavers
precess11310863prec_ess
precheck2144153precheck
prechecks2243573prechecks
preclears1344373preclears
precures12312903precures
preeners102712813preeners
prefers123713333p_refers
preggers12236833preggers
premiers122911653premiers
pressers103215023pressers
presters103419003presters
preyers124412363p_reyers
pricers113915063p_ricers
prickers163710673prickers
priers84521193p_r_iers
primers114215673p_rimers
prizers183911843p_rizers
probers113514583p_robers
propers113619033p_ropers
prosers94219643p_rosers
provers123817793p_rovers
pruners93710723p_runers
pryers115012243p_r_yers
psyches1755803psyche_s
puckers153514673p_uckers
puncher143311673puncher_
punches144816133punche_s
purchasers1742553purchasers
purflers13216963purflers
purgers104714003pur_gers
pursers93916093pur_sers
pursuers10376523pursuers
pushers123814503p_ushers
quenchers2343173quenchers
ranchers133311793ranchers
reacher123718293reacher_
reaches123423203reache_s
rechews1537293re_chews
rescuers1037363rescuers
retches123318513retche_s
scorchers16145513scorchers
searcher13209103searcher_
searches132112903searche_s
seiches12513813seiche_s
sergers83815633ser_gers
servers103214833ser_vers
sketchers1834513sketchers
specters122811063spe_cters
speeches1537413speeche_s
spencers12269193spenc_ers
teacher123714833teacher_
teaches122718353teache_s
teethers11328713teethers
telphers1335473telphers
tenches123515523tenche_s
tercels94110363terc_els
terces83921413terc_e_s
tercets93512443terc_ets
termers95414503ter_mers
terriers84210823terriers
tethers103815313te_thers
tochers123413093_tochers
torchere1347683torchere
torcheres1446863torcheres
torches123715443torche_s
torchiers1445073torchiers
touchers133611213touchers
trenchers14288073trenchers
vergers114412633ver_gers
verniers11227843verniers
versers103813523ver_sers
vetches153411263vetche_s
vouchers16418623vouchers
watchers163511793watchers
weathers143412833weathers
weighers15135673weighers
welcher15319393welcher_
welches153710313welche_s
welshers14246813welshers
wencher153811133wencher_
wenches152914133wenche_s
wethers135214693we_thers
winchers16319223winchers
wreckers17315973wreckers
wrenchers17256333wrenchers

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.406440125.6
2DLD Change Limit1461623307.59319249.6
3Display Results3303300.1232682.9
 (SQL Overall)1786913308.12222000.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.