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

471 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
pitcher14381371(None) 
ditcher134012001ditcher
hitcher153712001hitcher
patcher143515141patcher
pincher143812711pincher
pitched153512921pitched
pitchers153211481pitchers
pitches143617751pitches
pitchier15368271pitchier
aitches123014362aitches
batcher144414852batcher
bitched153212922bitched
bitchen14349732bitchen
bitchery18236562bitchery
bitches144117062bitches
bitchier15307732bitchier
botcher143613222botcher
butcher143411162butcher
catcher143115822catcher
cither114616682cit_her
ditched143711902ditched
ditchers143610362ditchers
ditches133215712ditches
dither104417682dit_her
either94517422eit_her
etcher113912942_etcher
fetcher153510392fetcher
filcher15377792filcher
fitchee152710782fitchee
fitches153516192fitches
fitchet153113562fitchet
fitchew18276802fitchew
hatcher153314722hatcher
hitched163312252hitched
hitchers16379992hitchers
hitches153616272hitches
hither124417252hit_her
incher114114032_incher
itched123812022_itched
itches114916212_itches
itchier12247672_itchier
ither84617602_it_her
kitchen16287682kitchen
lither94520952lit_her
matcher143214282matcher
mither114218562mit_her
notcher123610932notcher
patched153514622patched
patchers153413302patchers
patches143320382patches
patchier15319672patchier
peacher144216072peacher
percher143313422percher
picker144422172pi_cker
piecer105213082piec_er
pincer104019172pinc_er
pinched153812452pinched
pinchers153510612pinchers
pinches144117942pinches
pinscher1544812pinscher
pisher114317752pi_sher
pitch125018412pitch__
pitchmen1744332pitchmen
pitchy16479672pitch_y
pithed124615612pit_hed
pithier123010292pithier
pitier84019822pit_ier
poacher143912322poacher
pother113818852pot_her
puncher143311672puncher
richer114015042ri_cher
snitcher13157372snitcher
stitcher13168392stitcher
switcher16177682switcher
tither94920282tit_her
twitcher16135342twitcher
watcher153113402watcher
wincher153410652wincher
witched163012192witched
witchery19236092witchery
witches152715792witches
witchier16307882witchier
wither124321352wit_her
zither183813082zit_her
aether94213673aet_her
aitch105216163aitch__
anther93715063ant_her
archer115016243_archer
attacher13125713attacher
batched154114243batched
batchers153613273batchers
batches144019613batches
bather115322513bat_her
belcher143511493belcher
bencher144113483bencher
bewitcher1943003bewitcher
bicker144819173bi_cker
birched15349913birched
birchen14347883birchen
birches143412323birches
bitch125017763bitch__
bitchy16479203bitch_y
biter75030033bit__er
bitsier9379073bitsier
bitter84622673bit_ter
bittier94211663bittier
blither124812173blit_her
blucher143310223blucher
botched153611903botched
botchers153511543botchers
botchery18366763botchery
botches143716023botches
botchier15287143botchier
bother115218063bot_her
britches15278683britches
butchers153710183butchers
butchery18326253butchery
butches144315363butches
catchers153114063catchers
catches144320773catches
catchier15329863catchier
cinched153910863cinched
cinches144215773cinches
cipher133710263ci_pher
circler1136423circler
citer74827333cit__er
cithern12489913cit_hern
cithers124315773cit_hers
clincher15347663clincher
coacher143714123coacher
coucher144515853coucher
cutchery18265173cutchery
cutches143216463cutches
detacher1437543detacher
dicer85426423di_c_er
dicier94416233di_cier
dicker134521403di_cker
dictier103411863dictier
diether1147443diether
ditch115015093ditch__
dithers114016153dit_hers
dithery14318943dit_hery
ditsier83010293ditsier
ditzier17307963ditzier
dowitcher1842593dowitcher
epithet12312463epit_het
etched123613703_etched
etchers123411293_etchers
etches114217763_etches
ether84518773_et_her
father125116713fat_her
fetched163710473fetched
fetchers16328863fetchers
fetches153413893fetches
fiche134616743fi_che_
fiches145219533fi_ches
filched16307423filched
filchers16286863filchers
filches153410723filches
finches153914193finches
fisher124917143fi_sher
fitch134816873fitch__
fitchets16307413fitchets
fitchews19274773fitchews
fitchy17437623fitch_y
fitter94120033fit_ter
fletcher16306663fletcher
flincher16256583flincher
flitched17256293flitched
flitches16388463flitches
gather104115863gat_her
gaucher1337243gaucher
glitches14296663glitches
glitchier1542793glitchier
hatched163414463hatched
hatchel153510753hatchel
hatchers163113173hatchers
hatchery19326383hatchery
hatches153420273hatches
hatchet153317563hatchet
higher134610893hi_gher
hitch134515473hitch__
hitter94419863hit_ter
hotched163610923hotched
hotches153814363hotches
hutched16359883hutched
hutches153613523hutches
ichor1039483_i_chor
icier74313753_i_cier
icker114018443_i_cker
inched124514483_inched
inchers123912523_inchers
inches114419673_inches
itch95619173_itch__
itchy13449013_itch_y
jitter133314993jit_ter
ketches164012193ketches
kicker114116183ki_cker
kimchee1845603kimchee
kitchens17195783kitchens
kiter95523223kit__er
kithe125917463kit_he_
kithed144613013kit_hed
kithes135016653kit_hes
kitsches1734073kitsches
kittler11338163kittler
kvetcher2052813kvetcher
latched133914073latched
latches123320133latches
latchet123117913latchet
lather95124363lat_her
leacher124014843leacher
lecher113415853_lecher
letched133912053letched
letches124015483letches
lichee114017973li_chee
lichen114012743li_chen
liches114724293li_ches
licker125222043li_cker
litchi1137893litch_i
litchis1238373litchis
liter54736343lit__er
lithe84922013lit_he_
litter64324853lit_ter
littler7348553littler
luncher123111413luncher
lurcher12338133lurcher
lyncher15366553lyncher
marcher143912973marcher
matched153513963matched
matchers153012433matchers
matches143219783matches
miche126219243mi_che_
miched143913393mi_ched
miches134320733mi_ches
mincer104017363minc_er
mincier113512473mincier
miter75734793mit__er
miterer92511333miterer
mithers123516733mit_hers
mitier83620673mit_ier
moocher143610673moocher
mother113718643mot_her
muncher143610373muncher
mutches143314283mutches
neither1037573neit_her
nether94014163net_her
nicer74618293ni_c_er
niche105016793ni_che_
niched125514063ni_ched
niches114419143ni_ches
nicker123818703ni_cker
nigher103612753ni_gher
nitchie1247233nitchie
nitchies1339073nitchies
niter55028973nit__er
nittier73512243nittier
notched134210303notched
notchers13279423notchers
notches123513653notches
nother93815963not_her
ocher104516103__ocher
other84219103_ot_her
pacer96131613p_ac_er
pacier105018683p_acier
packer144223403p_acker
painches1588933painches
panther12611443panther
parched154013693parched
parches143720003parches
patch125221223patch__
patchy16509573patch_y
pater74740733pat__er
patter84628263pat_ter
patzer173111643pat_zer
peached154315883peached
peachers153213843peachers
peaches144120053peaches
peachier1548623peachier
peched144915343p_eched
pecker144615363p_ecker
perched154713243perched
perchers153611523perchers
perches143717953perches
peter74427593pet__er
petter83924773pet_ter
pettier94213613pettier
piaffer15104443piaffer
piaster93012883piaster
pice84641103pi_c_e_
picked154421313pi_cked
pickeer153710113pickeer
pickers153718093pi_ckers
picket144924313pi_cket
pickier153912973pickier
picture1158613picture
piddler112911523piddler
piece96717993piec_e_
pieced113912103piec_ed
piecers114112253piec_ers
pieces104217273piec_es
pier66035303pi___er
piercer11337773piercer
piggier113510003piggier
piker115622843pi__ker
pilchard1644553pilchard
pilfer1139163pi_lfer
pilsner935343pilsner
pincers113916503pinc_ers
pinch125619303pinch__
pincheck2143383pincheck
pinder94523463pi_nder
pinger94324093pi_nger
pinier84024693pi_nier
pinker125322443pi_nker
pinner84521503pi_nner
pinschers1644383pinschers
pioneer936893pioneer
piper96523193pi__per
pipier104913983pi_pier
pished124817063pi_shed
pishers123815753pi_shers
pishes114722103pi_shes
pisser84416383pi_sser
pistache1545893pistache_
pistaches1646673pistaches
pitcherful2051593pitcherful
pitchfork2352553pitchfork
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchman1744023pitchman
pitchout1546943pitchout
pith95432703pit_h__
pithead13419593pit_head
piths105817543pit_h_s
pithy135614463pit_h_y
pitied94017253pit_ied
pitiers93812653pit_iers
pities83828083pit_ies
pitmen102510793pit_men
pitted94319593pit_ted
placer105117743plac_er
plasher124215033plasher
plucker15368253plucker
plusher124010393plusher
poached154212403poached
poachers152910763poachers
poaches144416943poaches
poachier1556823poachier
pooched152810083pooched
pooches143214163pooches
porches143815673porches
posher115018163p_osher
potherb14358683pot_herb
pothers123818623pot_hers
potiche1438043potiche_
potiches1539203potiches
potsherd1434813potsherd
potter83926983pot_ter
pottier93516493pottier
potzer174411213pot_zer
pouched153612773pouched
pouches144116743pouches
pouchier1546803pouchier
preacher153211373preacher
pricer103918293pric_er
pricier113313113pricier
pricker154013413pricker
prithee1239933prit_hee
psyche1674293psyche_
psyched1843913psyched
psyches1755803psyches
pucker143817633p_ucker
punched153512173punched
punchers152610073punchers
punches144816133punches
punchier1536413punchier
pusher114318283p_usher
putsches1535313putsches
putter83921443put_ter
puttier93314503puttier
quitches2236193quitches
rancher123013633rancher
ratches123620463ratches
ratchet124218333ratchet
rather94319743rat_her
reacher123718293reacher
retched133814273retched
retches123318513retches
ricer74726613ri_c_er
richen113812513ri_chen
riches115022083ri_ches
ritter63822423rit_ter
ritzier16297203ritzier
rotche114311983rotche_
rotches123515703rotches
satchel123310303satchel
scutcher15176963scutcher
sicker124023903si_cker
sigher103813703si_gher
sitter63323383sit_ter
sketcher1735433sketcher
slither104112983slit_her
snatcher13167763snatcher
snitched14166863snitched
snitchers14166043snitchers
snitches13148983snitches
spicer104719313spi_c_er
spicier115112463spi_cier
spitter94015183spit_ter
sticker133515883sticker
stitched14148203stitched
stitchers14147013stitchers
stitchery17174073stitchery
stitches131410593stitches
switched17157133switched
switchers17146633switchers
switches16159133switches
swither133710993swit_her
teacher123714833teacher
tetched133010773tetched
tetchier1336453tetchier
tether93716103tet_her
thatcher1635663thatcher
thither13328103thit_her
ticker124321503ti_cker
titer55430613tit__er
titfer9409523tit_fer
tithe85319703tit_he_
tithed104115593tit_hed
tithers104216733tit_hers
tithes94720213tit_hes
titter63421163tit_ter
tocher114014913_tocher
tother94117143tot_her
toucher124814353toucher
twitched17155033twitched
twitchers17134533twitchers
twitches16156373twitches
twitchier1753233twitchier
vetches153411263vetches
vitamer1235473vitamer
voucher154110263voucher
watched163012823watched
watchers163511793watchers
watches153017373watches
welcher15319393welcher
wencher153811133wencher
wether123315393wet_her
whither163510253whit_her
wiches144418753wi_ches
wicker154518673wi_cker
wincer115018193winc_er
winched163110593winched
winchers16319223winchers
winches154714373winches
wisher123617063wi_sher
witch134517563witch__
witchy17468593witch_y
withe115220233wit_he_
withed134416233wit_hed
withers134417753wit_hers
withes124620843wit_hes
withier132910493withier
wittier103910823wittier
writher134010853writ_her
wuther124511613wut_her
zilches21326303zilches
zithern19447023zit_hern
zithers193911973zit_hers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274717.14018771.3
3Display Results4714710.1732722.5
 (SQL Overall)1786914717.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.