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

507 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
shoppes14341139(None) 
shoppe133110321shoppe_
shopped153512211shopped
shopper143312631shopper
shoppers153010761shoppers
chopped174511002chopped
chopper163611892chopper
choppers174110462choppers
hopes105835642_ho_pes
hopped144318112_hopped
hopper134218482_hopper
hoppers143115142_hoppers
hopples142810712_hopples
schappes1736032schappes
scopes104719592sco_pes
shapes115124942sh_apes
shipped153312102shipped
shippen14298862shippen
shippens15316802shippens
shipper143514042shipper
shippers153012312shippers
shoes85429662sho__es
shopmen14277202shopmen
shops104222902sho_p_s
shores94830412sho_res
shotes95321912sho_tes
shoves124919422sho_ves
slopes84820452slo_pes
slopped123511442slopped
sopped114819902s_opped
steppes113110692steppes
stopes84525892sto_pes
stopped124512202stopped
stopper113012602stopper
stoppers123910592stoppers
stopples1236952stopples
swopped15437672swopped
thorpes125010352thorpes
whopped18358002whopped
whopper17328502whopper
whoppers18297532whoppers
atopies92816433atopies
bopped134413403_bopped
bopper123813833_bopper
boppers133911923_boppers
chapes135421873ch_apes
chapped172711443chapped
chappies172610093chappies
chipped174110813chipped
chipper163912583chipper
chippers173510883chippers
chippies17309753chippies
choices142010613choices
chokes154917383cho_kes
chomped17329773chomped
chomper163810073chomper
chompers17369593chompers
chomps155112223chomp_s
chooses125717423chooses
chopines152711733chopines
chopins142312243chopins
choppier17286643choppier
choppiest18226373choppiest
choppy18376293chopp_y
chops125019873cho_p_s
chores114828023cho_res
choses115825133cho_ses
chouses125117813chouses
chowses155611283chowses
chuppas1644123chuppas
clopped143611523clopped
copes97747103_co_pes
copies104130303_copies
copped135221253_copped
copper124321893_copper
coppers133519753_coppers
copses104922473_copses
coupes105022523_coupes
cropped143812063cropped
cropper133312963cropper
croppers143311483croppers
croppies143111133croppies
croupes114613103croupes
dholes104914793dho_les
dopes84935043_do_pes
dropped13329283dropped
dropper12329873dropper
droppers13318603droppers
elopes85918163elo_pes
epopees1137233epopees
estopped1334993estopped
estoppel1243173estoppel
estoppels1342353estoppels
flopped15338763flopped
flopper14328473flopper
floppers15337463floppers
floppies1546813floppies
fopped144012673_fopped
frappes14328383frappes
glopped13347613glopped
grippes124810373grippes
gropes95220403gro_pes
happed144820103_happed
happen134812193_happen
happens14359173_happens
hepper133412663_hepper
heppest14228143_heppest
herpes115517323_herpes
hipped144317693_hipped
hipper133818023_hipper
hippest14219753_hippest
hippies142813743_hippies
hippos13408433_hippos
hoaxes163611693_hoaxes
hoboes114717443_hoboes
hoes75755733_ho__es
hoises94823673_hoises
hokes126231643_ho_kes
holes84748653_ho_les
holies94630033_holies
holpen11299413_holpen
homes106938813_ho_mes
homies114524723_homies
hones88144493_ho_nes
hooped125518183_hooped
hooper114518313_hooper
hoopers123616483_hoopers
hoopoes121212483hoopoes
hoops105621073_hoop_s
hooves124815483_hooves
hope96639673_ho_pe_
hoped115628183_ho_ped
hoper105829143_ho_per
hopers114222973_hopers
hoppier143110703_hoppier
hoppiest152610723_hoppiest
hopple132910483_hopple
hoppled15338083_hoppled
hoppy154912353_hopp_y
hops97942633_ho_p_s
hordes104921633_hordes
horses94729343_horses
hoses85443173_ho_ses
houses96032273_houses
howes114730263_ho_wes
hoyles12315013_hoyles
hypes135818673_h_ypes
knopped16355443knopped
kopjes1935363_kopjes
koppas14407603_koppas
koppies153210013_koppies
lopes76437343_lo_pes
lopped114218623_lopped
lopper103717203_lopper
loppers113014103_loppers
loupes84918053_loupes
mopes95134983_mo_pes
mopped134114323_mopped
mopper126215003_mopper
moppers133412463_moppers
moppet126915093_moppet
moppets13307163_moppets
myopes13419963myo_pes
myopies14309723myopies
nappes104515623_nappes
opes65942613__o_pes
peoples11312213peoples
phoebes1435813phoebes
phones114121213pho_nes
phonies123717513phonies
plopped11288773plopped
popes95933813_po_pes
poppas93710713_poppas
popped104117813_popped
popper93615963_popper
poppers103414863_poppers
poppet92717323_poppet
poppets10338853_poppets
poppies102816193_poppies
popples103011873_popples
propped113311953propped
rhaphes1534703rhaphes
ropes75940063_ro_pes
samples112815453samples
sapotes9313943sapotes
sapped114422013s_apped
sapper103822353s_apper
sappers113518903s_appers
sarapes94617743sarapes
scapes105122263s_capes
schappe1635263schappe_
sconces113811453sconces
scones84521303sco_nes
scooped124611743scooped
scooper113812033scooper
scoopers124210193scoopers
scoops105414363scoop_s
scope94821483sco_pe_
scoped115116653sco_ped
scops95820193sco_p_s
scores84725923sco_res
scouses93313243scouses
scrapes116217663scrapes
scupper1367423scupper
scuppers1446543scuppers
sepses84515883s_epses
serapes95218103serapes
shades105924533sh_ades
shakes135024593sh_akes
shakoes144510023shakoes
shales94731253sh_ales
shames114726223sh_ames
shammes144312833shammes
shape105125113sh_ape_
shaped125020103sh_aped
shapen114414653sh_apen
shaper114119933sh_aper
shapers124016893shapers
shares95236413sh_ares
sharped134112053sharped
sharpen12389723sharpen
sharpens13377813sharpens
sharper124312703sharper
sharpers133810943sharpers
sharpest1339143sharpest
sharpies13411223sharpies
sharps115516083sharp_s
shaves125224933sh_aves
shavies134213203shavies
sheaves134412973sheaves
sheeves133911953sheeves
shelves134112093shelves
sherpas1238093sherpas
shes75734353sh___es
shies86136553sh__ies
shikses14116573shikses
shines95028913sh_ines
shipless13277693shipless
shipmen14317283shipmen
shippon14285803shippon
shippons15255663shippons
ships105123773sh_ip_s
shires95225573sh_ires
shives124921413sh_ives
shlepped1633643shlepped
shlepps14394833shlepps
shleps114710333shlep_s
shmoes114612103sh_moes
shmoozes22254883shmoozes
shnapps1463343shnapps
shnaps1148083shnap_s
shoaled113810973shoaled
shoaler102610083shoaler
shoalest1168913shoalest
shoals94215793sho_als
shoats94117083sho_ats
shocked174611813shocked
shocker163411433shocker
shockers17319463shockers
shocks154414583sho_cks
shodden12265763shodden
shoddies1336053shoddies
shoe75933443sho__e_
shoed95723013sho__ed
shoeless1137803shoeless
shoepac1444013shoepac
shoepacs1543833shoepacs
shoer84722163sho__er
shoers94518333sho_ers
shofars1335833shofars
shogged13397963shogged
shogis103810943sho_gis
shogs95319713sho__gs
shoguns1134423shoguns
shojis16348493sho_jis
sholoms1278033sholoms
shone83725983sho_ne_
shooed103916083sho_oed
shooks134515633sho_oks
shooled115212663shooled
shools94919013sho_ols
shoos84226363sho__os
shooter103013993shooter
shooters112811583shooters
shoots94619363sho_ots
shop95629843sho_p__
shopboy1743803shopboy
shopboys1843273shopboys
shophar1555463shophar
shophars1646353shophars
shopman14247263shopman
shopping163611293shopping
shoppings17295073shoppings
shorans102812413shorans
shore85432653sho_re_
shored105723653sho_red
shorls94516203sho_rls
shorted113614403shorted
shorten103511413shorten
shortens11288993shortens
shorter103515503shorter
shortest11310783shortest
shorties11414583shorties
shorts95321743sho_rts
shote85526103sho_te_
shots84730853sho__ts
shotted113912403shotted
shotten10288463shotten
shotts93614703sho_tts
shouted113911553shouted
shouter103213083shouter
shouters113510623shouters
shouts94017723sho_uts
shove114421043sho_ve_
shoved134214283sho_ved
shovel124611323sho_vel
shovels13378393shovels
shover124515993sho_ver
shovers134613003shovers
showed135016973sho_wed
shower124315113sho_wer
showers134612683showers
showier1339103showier
showiest1438783showiest
showmen15227173showmen
shows115324583sho__ws
shoyus1266003sho_yus
shrikes144412393shrikes
shrines104618693shrines
shrives134416173shrives
shushes133510303shushes
shutes93518223sh_utes
simples113014943simples
sipes76036953s__ipes
sipped113720633s_ipped
sipper103920993s_ipper
sippers113117753s_ippers
sippet103519393s_ippet
sippets113310183s_ippets
skipped16358413skipped
skipper15339573skipper
skippers16318203skippers
skippet15288463skippet
skippets16284563skippets
skoshes14246253skoshes
slapped123511843slapped
slapper113512463slapper
slappers123710943slappers
slipes84921413s_lipes
slipped124711743slipped
slipper113712983slipper
slippers123711233slippers
sloes54728873slo__es
sloops85513623sloop_s
slope75823563slo_pe_
sloped94216853slo_ped
sloper84615913slo_per
slopers94213093slopers
sloppier1255703sloppier
sloppiest1345973sloppiest
sloppy1395303slopp_y
slops75026013slo_p_s
sloshes103811803sloshes
slypes114410483s_lypes
smokes124814343smo_kes
snapped124611203snapped
snapper113512073snapper
snappers123510173snappers
snipes83917393s_nipes
snipped123510043snipped
snipper113911333snipper
snippers12299723snippers
snippet113310433snippet
snippets12225623snippets
snooped103711813snooped
snooper93511533snooper
snoopers10319843snoopers
snoops84314173snoop_s
snoozes16289783snoozes
snores64324323sno_res
soaped95817973s_oaped
soaper84517873s_oaper
soapers93715923s_oapers
soaps75120713s_oap_s
soaves94218673s_oaves
socles8418453s_ocles
sokes95031423s_o_kes
soles55547923s_o_les
solves95018223s_olves
sondes74922873s_ondes
sones55444143s_o_nes
soothes103917113soothes
sophies12314613s_ophies
sophs104916023s_o_phs
sopites93817173s_opites
sopors85215203s_opors
soppier112711583s_oppier
soppiest122511933s_oppiest
soppy125113523s_opp_y
sops65244563s_o_p_s
sores55454283s_o_res
souped95017673s_ouped
soups75322943s_oup_s
souses64229243s_ouses
spaes76029973s__paes
spies76037623s__pies
spodes94817433spo_des
spokes124417213spo_kes
sponges10311043sponges
spores84726613spo_res
spouses92912813spouses
spues75025383s__pues
stapes85028733s_tapes
staples93617213staples
steppe10319873steppe_
stepped123210053stepped
stepper113010853stepper
steppers12289283steppers
stipes84524053s_tipes
stipples1247023stipples
stirpes95011293stirpes
stodges9309083stodges
stogies8413693stogies
stokes104821793sto_kes
stoles63927673sto_les
stomped124110533stomped
stomper114111233stomper
stompers123610043stompers
stomps105612833stomp_s
stones65130033sto_nes
stooges83611483stooges
stooped103813833stooped
stooper93813193stooper
stoopers103711303stoopers
stoops85917893stoop_s
stope74727243sto_pe_
stoped94721013sto_ped
stoper84320103sto_per
stopers94217373stopers
stoppages1444693stoppages
stopple1156583stopple
stoppled1345003stoppled
stops74827283sto_p_s
stores65533663sto_res
stories7324273stories
stoups85313273stoup_s
stoures74614163stoures
stoves93818923sto_ves
stowps115710583stowp_s
stripes95320573stripes
strophes13310603strophes
stropped1367343stropped
stropper1247763stropper
stroppers1356713stroppers
stupes84116953s_tupes
supes75628303s__upes
supped114415703s_upped
supper104115433s_upper
suppers113314703s_uppers
supples11511283supples
swapped15429143swapped
swapper14359703swapper
swappers15358083swappers
swipes114114333s_wipes
swiples12339643swiples
swipples1534843swipples
swooped13418753swooped
swooper12389173swooper
swoopers13317523swoopers
swoops114910923swoop_s
swops105913973swo_p_s
synopses1346223synopses
tholes94919783tho_les
thorpe113610093thorpe_
thorps113610893thorp_s
topees85519703_topees
topes76941763_to_pes
tophes115218423_tophes
topped114617723_topped
topper103817603_topper
toppers113914603_toppers
topples113111653_topples
trompes114111623trompes
tropes84824353tro_pes
troupes94112853troupes
whapped18367573whapped
whapper17348273whapper
whappers18276743whappers
whipped18379333whipped
whipper173611383whipper
whippers18329043whippers
whippet17328843whippet
whippets18255253whippets
wholes124616773who_les
whomped18345473whomped
whomps16457603whomp_s
whooped16326933whooped
whoopee15287513whoopee
whoopees16294823whoopees
whooper15297153whooper
whoopers16286263whoopers
whoopies16267373whoopies
whoops14487863whoop_s
whops135013933who_p_s
whores125617103who_res
whupped18365413whupped
woopses1237883woopses

Search took 7 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.1401276364.3
2DLD Change Limit1340275076.48620664.0
3Display Results5075070.1702982.4
 (SQL Overall)1786915076.79626293.6
 
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.