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

364 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
pitchers15321148(None) 
ditchers143610361ditchers
hitchers16379991hitchers
patchers153413301patchers
pinchers153510611pinchers
pitcher143813711pitcher_
pitches143617751pitche_s
aitches123014362aitche_s
batchers153613272batchers
bitchery18236562bitchery
bitches144117062bitche_s
botchers153511542botchers
butchers153710182butchers
catchers153114062catchers
cithers124315772cit_hers
ditcher134012002ditcher_
ditches133215712ditche_s
dithers114016152dit_hers
etchers123411292_etchers
fetchers16328862fetchers
filchers16286862filchers
fitches153516192fitche_s
fitchets16307412fitchets
fitchews19274772fitchews
hatchers163113172hatchers
hitcher153712002hitcher_
hitches153616272hitche_s
inchers123912522_inchers
itches114916212_itche_s
kitchens17195782kitchens
matchers153012432matchers
mithers123516732mit_hers
notchers13279422notchers
patcher143515142patcher_
patches143320382patche_s
peachers153213842peachers
perchers153611522perchers
pickers153718092pi_ckers
piecers114112252piec_ers
pincers113916502pinc_ers
pincher143812712pincher_
pinches144117932pinche_s
pinschers1644372pinschers
pishers123815752pi_shers
pitched153512922pitche_d
pitchier15368272pitchier_
pitiers93812652pit_iers
poachers152910762poachers
pothers123818622pot_hers
punchers152610072punchers
snitchers14166042snitchers
stitchers14147012stitchers
switchers17146632switchers
tithers104216732tit_hers
twitchers17134532twitchers
watchers163511792watchers
winchers16319222winchers
witchery19236092witchery
witches152715792witche_s
withers134417752wit_hers
zithers193911972zit_hers
aethers103614943aet_hers
anthers103715203ant_hers
archers124414573_archers
attachers14134883attachers
batcher144414853batcher_
batches144019613batche_s
bathers124720363bat_hers
belchers153510023belchers
benchers153611013benchers
bewitchers2042563bewitchers
bickers154316553bi_ckers
birches143412323birche_s
bitched153212923bitche_d
bitchen14349733bitche_n
bitcheries1745903bitcheries
bitchier15307733bitchier_
biters83925243bit__ers
bitters94920363bit_ters
blithers134711233blit_hers
bluchers15359033bluchers
botcher143613223botcher_
botchery18366763botchery
botches143716023botche_s
bothers124317753bot_hers
britches15278683britche_s
butcher143411163butcher_
butchery18326253butchery
butches144315363butche_s
catcher143115823catcher_
catches144320773catche_s
cinches144215773cinche_s
ciphers14379993ci_phers
circlers1235353circlers
citers85022983cit__ers
cither114616683cit_her_
cithern12489913cit_hern
citherns13338873cit_herns
clinchers16336263clinchers
coachers154312303coachers
couchers153513863couchers
cutchery18265173cutchery
cutches143216463cutche_s
detachers1536483detachers
dicers94720743di_c_ers
dickers144117663di_ckers
diethers1257453diethers
ditched143711903ditche_d
dither104417683dit_her_
dithery14318943dit_hery
dowitchers1942133dowitchers
either94517423eit_her_
epithets1345763epit_hets
etcher113912943_etcher_
etches114217763_etche_s
ethers94518413_et_hers
fathers133916503fat_hers
fetcher153510393fetcher_
fetches153413893fetche_s
fiches145219533fi_che_s
filcher15377793filcher_
filches153410723filche_s
finches153914193finche_s
fishers134714723fi_shers
fitchee152710783fitche_e
fitchet153113563fitche_t
fitchew18276803fitche_w
fitters104517753fit_ters
fletchers17335533fletchers
flinchers17295473flinchers
flitches16388463flitche_s
gathers114315073gat_hers
glitches14296653glitche_s
hatchels16368673hatchels
hatcher153314723hatcher_
hatchery19326383hatchery
hatches153420273hatche_s
hatchets163310383hatchets
hitched163312253hitche_d
hither124417253hit_her_
hitters104717593hit_ters
hotches153814363hotche_s
hutches153613523hutche_s
ichors11310423_i_chors
ickers123914183_i_ckers
incher114114033_incher_
inches114419673_inche_s
itched123812023_itche_d
itchier12247673_itchier_
ither84617603_it_her_
jitters144314473jit_ters
ketches164012193ketche_s
kickers124013293ki_ckers
kimchees1942943kimchees
kitchen16287683kitche_n
kiters105218593kit__ers
kithes135016653kit_he_s
kitsches1734073kitsche_s
kvetchers2142373kvetchers
latches123320123latche_s
latchets133410013latchets
lathers104321883lat_hers
leachers133712813leachers
lechers123313963_lechers
letches124015483letche_s
lichees123512783li_chees
lichens123510683li_chens
liches114724293li_che_s
lickers134118253li_ckers
litchis1238373litch_is
liters65429883lit__ers
lither94520953lit_her_
litters73422573lit_ters
lunchers13349563lunchers
lurchers13307153lurchers
lynchers16285453lynchers
marchers153710813marchers
matcher143214283matcher_
matches143219783matche_s
miches134320733mi_che_s
mincers113714853minc_ers
miterers10219683miterers
miters84328783mit__ers
mither114218563mit_her_
moochers15369123moochers
mothers123717623mot_hers
munchers15318773munchers
mutches143314283mutche_s
niches114419143ni_che_s
nickers134415093ni_ckers
nitchies1339073nitchies
niters64624213nit__ers
notcher123610933notcher_
notches123513653notche_s
ochers113915303__ochers
others93918003_ot_hers
pacers105124543p_ac_ers
packers153818893p_ackers
painches1588913painche_s
panthers13510783panthers
parches143720003parche_s
patched153514623patche_d
patchier15319663patchier_
paters84935833pat__ers
patters94825193pat_ters
patzers184210573pat_zers
peacher144216073peacher_
peaches144120053peache_s
peckers153312673p_eckers
percher143313423percher_
perches143717953perche_s
peters86624593pet__ers
petters93722363pet_ters
piaffers16114203piaffers
piasters102912813piasters
pickeers16347243pickeers
picker144422173pi_cker_
pickets154314183pi_ckets
pictures1249343pictures
piddlers12359593piddlers
piecer105213083piec_er_
pieces104217273piec_e_s
piercers12316723piercers
piers75926333pi___ers
pikers124717393pi__kers
pilchard1644553pilchard
pilchards1743923pilchards
pilfers1238963pi_lfers
pilsners1035533pilsners
pincer104019173pinc_er_
pincheck2143383pincheck
pinchecks2243153pinchecks
pinched153812453pinche_d
pinders103720473pi_nders
pingers104020743pi_ngers
pinkers134118603pi_nkers
pinners93518603pi_nners
pinscher1544803pinscher_
pioneers1035863pioneers
pipers104318663pi__pers
pisher114317753pi_sher_
pishes114722103pi_she_s
pissers95014753pi_ssers
pistaches1646673pistache_s
pitch125018413pitch___
pitcherful2051593pitcherful
pitcherfuls2151133pitcherfuls
pitchersful216973pitchersful
pitchfork2352543pitchfork
pitchforks2452373pitchforks
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchman1744013pitchman
pitchmen1744333pitchmen
pitchout1546943pitchout
pitchouts1643673pitchouts
pitchy16479673pitch__y
pithead13419593pit_head
pitheads14338143pit_heads
pithed124615613pit_he_d
pithier123010293pithier_
pithless13117023pithless
piths105817543pit_h__s
pitier84019823pit_ier_
pities83828083pit_ie_s
pitiless10127333pitiless
placers114515263plac_ers
plashers133813453plashers
pluckers16316553pluckers
poacher143912323poacher_
poaches144416943poache_s
pooches143214163pooche_s
porches143815673porche_s
pother113818853pot_her_
potherb14358683pot_herb
potherbs15387123pot_herbs
potiches1539203potiche_s
potsherd1434813potsherd
potsherds1544023potsherds
potters94024343pot_ters
potzers184010543pot_zers
pouches144116743pouche_s
preachers16339573preachers
pricers113915063pric_ers
prickers163710673prickers
psyches1755803psyche_s
puckers153514673p_uckers
puncher143311673puncher_
punches144816133punche_s
pushers123814503p_ushers
putsches1535313putsche_s
putters94219193put_ters
puttiers10288013puttiers
quitches2236193quitche_s
ranchers133311793ranchers
ratches123620463ratche_s
ratchets133110263ratchets
reachers133515723reachers
retches123318513retche_s
ricers84120993ri_c_ers
richens12349733ri_chens
richer114015043ri_cher_
riches115022083ri_che_s
ritters74020623rit_ters
rotches123515703rotche_s
satchels13328163satchels
scutchers16175643scutchers
sighers113712183si_ghers
sithens1039383sit_hens
sitters74221553sit_ters
sketchers1834513sketchers
slithers114212953slit_hers
smithers13369793smit_hers
snatchers14146313snatchers
snitcher13157373snitcher_
snitches13148983snitche_s
spicers113815553spi_c_ers
spitters104113383spit_ters
stickers142913033stickers
stitcher13168393stitcher_
stitchery17174073stitchery
stitches131410593stitche_s
switcher16177683switcher_
switches16159133switche_s
swithers144310533swit_hers
teachers133212393teachers
tethers103815313tet_hers
thatchers1744583thatchers
tickers133617723ti_ckers
titers64526413tit__ers
titfers10318933tit_fers
tither94920283tit_her_
tithes94720213tit_he_s
titters74219623tit_ters
tochers123413093_tochers
touchers133611213touchers
twitcher16135343twitcher_
twitches16156373twitche_s
vetches153411263vetche_s
vitamers1334683vitamers
vouchers16418623vouchers
watcher153113403watcher_
watches153017373watche_s
welchers16338053welchers
wenchers16319213wenchers
wethers135214693wet_hers
wiches144418753wi_che_s
wickers164114703wi_ckers
wincers123415363winc_ers
wincher153410653wincher_
winches154714373winche_s
wishers133215213wi_shers
witched163012193witche_d
witcheries1845463witcheries
witchier16307883witchier_
wither124321353wit_her_
withes124620843wit_he_s
writhers14398983writ_hers
wuthers133711523wut_hers
zilches21326303zilche_s
zither183813083zit_her_
zithern19447023zit_hern
zitherns20376133zit_herns

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.1561145455.1
2DLD Change Limit1461623647.69019006.8
3Display Results3643640.1402600.0
 (SQL Overall)1786913647.98622375.5
 
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.