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

526 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
shopper14331263(None) 
chopper163611891chopper
hopper134218481_hopper
shipper143514041shipper
shoppe133110321shoppe_
shopped153512211shopped
shoppers153010761shoppers
shoppes143411401shoppes
stopper113012601stopper
whopper17328501whopper
bopper123813832_bopper
chipper163912582chipper
chomper163810072chomper
chopped174511012chopped
choppers174110462choppers
choppier17286652choppier
copper124321892_copper
cropper133312972cropper
dropper12329872dropper
flopper14328472flopper
hepper133412662_hepper
hipper133818022_hipper
hooper114518312_hooper
hoper105829142_ho_per
hopped144318112_hopped
hoppers143115142_hoppers
hoppier143110702_hoppier
lopper103717202_lopper
mopper126215002_mopper
popper93615962_popper
sapper103822352s_apper
scooper113812032scooper
scupper1367422scupper
shaper114119932sh_aper
sharper124312702sharper
shipped153312102shipped
shippen14298862shippen
shippers153012312shippers
shoaler102610082shoaler
shocker163411432shocker
shoer84722162sho__er
shooter103013992shooter
shophar1555462shophar
shopmen14277202shopmen
shorter103515502shorter
shouter103213082shouter
shover124515992sho_ver
shower124315112sho_wer
showier1339102showier
sipper103920992s_ipper
skipper15339572skipper
slapper113512472slapper
slipper113712982slipper
sloper84615912slo_per
slopped123511442slopped
sloppier1255712sloppier
snapper113512072snapper
snipper113911332snipper
snooper93511532snooper
soaper84517872s_oaper
sopped114819902s_opped
soppier112711582s_oppier
stepper113010852stepper
stomper114111232stomper
stooper93813192stooper
stoper84320102sto_per
stopped124512202stopped
stoppers123910592stoppers
stropper1247762stropper
supper104115432s_upper
swapper14359702swapper
swooper12389172swooper
swopped15437672swopped
topper103817602_topper
whapper17348272whapper
whipper173611382whipper
whooper15297152whooper
whopped18358002whopped
whoppers18297532whoppers
adopter1036763adopter
bebopper1642103bebopper
blooper11358533blooper
bopped134413403_bopped
boppers133911923_boppers
capper124421983_capper
champer163813413champer
chapped172711443chapped
chapter144213853chapter
cheaper144010583cheaper
cheeper143610743cheeper
chipped174110813chipped
chippers173510883chippers
chippier17297673chippier
chirper14359963chirper
choicer14197893choicer
choker154314373cho_ker
chokier1638043chokier
choler113717153cho_ler
chomped17329773chomped
chompers17369593chompers
chooser124412973chooser
choppered1964883choppered
choppy18376293chopp_y
chouser125212943chouser
chowder16387813chowder
clapper134011863clapper
clipper133710323clipper
clopped143611533clopped
cooper104221123_cooper
coper95336093_co_per
copier103722903_copier
copped135221263_copped
coppers133519753_coppers
coppery16409393_coppery
copter109822013_copter
crapper133913193crapper
cropped143812073cropped
croppers143311483croppers
crupper13338563crupper
cupper124313863_cupper
dapper114016633_dapper
diopter1038473diopter
dipper114017793_dipper
doper86128393_do_per
dopier93515923_dopier
dorper94314573_dorper
dripper12349233dripper
dropped13329293dropped
droppers13318603droppers
eloper85414153elo_per
estopped1335003estopped
estoppel1243173estoppel
flapper14359203flapper
flipper14389143flipper
flopped15338763flopped
floppers15337463floppers
floppier1554633floppier
fopped144012673_fopped
foppery17385623_foppery
gipper114215303_gipper
glopped13347613glopped
gloppier1354673gloppier
goopier103910573goopier
gopher1239183_gopher
gripper124410713gripper
groper94517253gro_per
grouper104210093grouper
gypper14347293_gypper
hamper134518653_hamper
happed144820103_happed
happen134812193_happen
happier143312043_happier
harper115018403_harper
heaper114119523_heaper
helper114313093_helper
hipped144317693_hipped
hippier143212103_hippier
hoaxer16348563_hoaxer
hobber134114633_hobber
hocker155118563_hocker
hoer76533983_ho__er
hogger114615083_hogger
hokier134214033_hokier
holder104619653_holder
holier94921623_holier
holler93520613_holler
holpen11299413_holpen
homer105828453_ho_mer
homier116416993_homier
honer85332093_ho_ner
honker134117463_honker
hoofer124014953_hoofer
hooker134820173_hooker
hooped125518183_hooped
hoopers123616493_hoopers
hooter94123933_hooter
hoover124314433_hoover
hope96639673_ho_pe_
hoped115628183_ho_ped
hopers114222973_ho_pers
hopes105835643_ho_pes
hopple132910483_hopple
hoppled15338083_hoppled
hopples142810713_hopples
hoppy154912353_hopp_y
hoser811529763_ho_ser
hosier94219613_hosier
hotter94720083_hotter
houser95322283_houser
hover115524133_ho_ver
howler123514313_howler
humper134115883_humper
hyper135213903_h_yper
kipper143414213_kipper
knapper15387153knapper
knopped16355453knopped
lapper104319953_lapper
lipper104219633_lipper
looper83817113_looper
loopier93711193loopier
loper75129233_lo_per
lopped114218623_lopped
loppers113014103_loppers
loppier11369723_loppier
mapper124516093_mapper
moper94925923_mo_per
mopier103914783_mopier
mopped134114323_mopped
moppers133412463_moppers
moppet126915093_moppet
napper103718283_napper
nipper103715713_nipper
peopler1138083peopler
pepper93512943_pepper
phonier122710633phonier
plopped11288773plopped
popped104117813_popped
poppers103414863_poppers
poppet92717323_poppet
proper104319953pro_per
propped113311963propped
prosper114012193prosper
quipper2095823quipper
rapper104621573_rapper
reshipper1643623reshipper
ripper103518653_ripper
romper104213683_romper
roper75431913_ro_per
ropier84118813_ropier
sampler113212013sampler
sapped114422013s_apped
sappers113518903s_appers
sappier113613123sappier
scalper113912923scalper
scamper134613163scamper
scarper114814823scarper
scauper11379453scauper
scepter1138363scepter
schappe1635273schappe_
schappes1736043schappes
schnapper1842473schnapper
schooner1336623schooner
scoffer15317023scoffer
scolder103210343scolder
scooped124611753scooped
scoopers124210193scoopers
scooter93312873scooter
scope94821483sco_pe_
scoped115116663sco_ped
scopes104719593sco_pes
scorer84818263sco_rer
scorner9259763scorner
scoter83815483sco_ter
scourer93910433scourer
scouter93313323scouter
scowder13286873scowder
scowler12248193scowler
scraper114513423scraper
scrapper1466973scrapper
scuppers1446543scuppers
seepier92912013seepier
shader104218763sh_ader
shadier113111153shadier
shaker134319463sh_aker
shakier143411153shakier
shalier103116423shalier
shammer144613143shammer
shape105125113sh_ape_
shaped125020103sh_aped
shapen114414653sh_apen
shapers124016893sh_apers
shapes115124953sh_apes
sharer95025483sh_arer
sharker144313813sharker
sharped134112053sharped
sharpen12389723sharpen
sharpers133810943sharpers
shatter103615703shatter
shaver123718913sh_aver
shearer104414693shearer
shedder12339323shedder
sheer84726893sh__eer
sheerer103813853sheerer
sheeter103814913sheeter
sheller103515893sheller
shelter103214963shelter
shelver134211063shelver
shepherd1744373shepherd
shewer124515113sh_ewer
shicker163914823shicker
shier85428943sh__ier
shifter132911083shifter
shikker13277023shikker
shimmer143310873shimmer
shiner93820873sh_iner
shinier104113143shinier
shipmen14317283shipmen
shippens15316803shippens
shippon14285803shippon
shirker143711343shirker
shiver124517373sh_iver
shlepped1633643shlepped
shnorrer1143523shnorrer
shoaled113810973shoaled
shoalier1137073shoalier
shocked174611813shocked
shockers17319463shockers
shodden12265763shodden
shoddier1334213shoddier
shoe75933443sho__e_
shoed95723013sho__ed
shoepac1444013shoepac
shoers94518333sho__ers
shoes85429663sho__es
shofar1236313sho_far
shogged13397963shogged
shone83725983sho_ne_
shooed103916083sho_oed
shooled115212663shooled
shooters112811583shooters
shop95629843sho_p__
shopboy1743803shopboy
shopgirl1442263shopgirl
shophars1646353shophars
shopkeeper2151793shopkeeper
shopman14247263shopman
shopping163611293shopping
shops104222903sho_p_s
shopworn1643983shopworn
shore85432653sho_re_
shored105723653sho_red
shores94830413sho_res
shorted113614403shorted
shorten103511413shorten
shote85526103sho_te_
shotes95321913sho_tes
shotted113912403shotted
shotten10288463shotten
shoulder1234753shoulder
shouted113911553shouted
shouters113510623shouters
shove114421043sho_ve_
shoved134214283sho_ved
shovel124611323sho_vel
shoveler14165583shoveler
shovers134613003sho_vers
shoves124919423sho_ves
showed135016973sho_wed
showerer1436163showerer
showers134612683sho_wers
showery16437243sho_wery
showmen15227173showmen
shrimper1544413shrimper
shriver134712193shriver
shucker163710103shucker
shudder12297323shudder
shunner10358643shunner
shunter103611733shunter
shusher13288113shusher
shutter103712143shutter
shyer114714783sh__yer
shyster13116563shyster
simper103616293s_imper
simpler112910863simpler
sipped113720633s_ipped
sippers113117753s_ippers
sippet103519393s_ippet
skipped16358413skipped
skippers16318203skippers
skippet15288463skippet
slapped123511853slapped
slappers123710953slappers
sleeper93211563sleeper
slipped124711743slipped
slippers123711233slippers
slippery15275863slippery
slippier1256543slippier
slobber11388903slobber
slogger94310483slogger
slope75823563slo_pe_
sloped94216853slo_ped
slopers94213093slo_pers
slopes84820453slo_pes
sloppy1395303slopp_y
slotter73314453slotter
slower94016153slo_wer
smoker124311693smo_ker
smokier1356703smokier
smolder10327753smolder
smother123510213smother
snapped124611203snapped
snappers123510173snappers
snappier1266223snappier
sniper84413643s_niper
snipped123510043snipped
snippers12299723snippers
snippet113310433snippet
snippier1255793snippier
snooker113910303snooker
snooped103711813snooped
snoopers10319843snoopers
snoopier10177273snoopier
snoozer16409193snoozer
snorer64316763sno_rer
snorter74412663snorter
snowier1038793snowier
soaker105717533s_oaker
soaped95817973s_oaped
soapers93715923s_oapers
soapier93411713soapier
soarer64522243s_oarer
sobber104016593s_obber
sober74822413s_o_ber
soccer1038543s_occer
soever94412093s_oever
softer94015313s_ofter
solder73921343s_older
solver94016703s_olver
somber103714003s_omber
sonder73623523s_onder
sooner64220463s_ooner
soother104215043soother
sootier73916613sootier
sopor74016493s_o_por
soppy125113523s_opp_y
sorer56236593s_o_rer
sorner64720393s_orner
sorter64425093s_orter
souped95017673s_ouped
soupier93111753soupier
sourer63620213s_ourer
souter64225923s_outer
sower85229313s_o_wer
speer74623903s__peer
spier75728033s__pier
spoiler93310683spoiler
sponger1038523sponger
spoofer12368723spoofer
spooler93711383spooler
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
stamper113714403stamper
stapler93913633stapler
steeper93812773steeper
steppe10319873steppe_
stepped123210053stepped
steppers12289283steppers
steppes113110693steppes
stippler1235543stippler
stocker133713083stocker
stoker104417623sto_ker
stomped124110533stomped
stompers123610043stompers
stoner65823203sto_ner
stonier72013793stonier
stooker113811733stooker
stooped103813833stooped
stoopers103711303stoopers
stope74727243sto_pe_
stoped94721013sto_ped
stopers94217373sto_pers
stopes84525893sto_pes
stopover1344063stopover
stoppered1444473stoppered
stopple1156583stopple
stoppled1345003stoppled
stopples1236953stopples
storer64721673sto_rer
stouter74012053stouter
stover94115643sto_ver
strapper1258093strapper
striper94514793striper
stripper1247123stripper
stropped1367353stropped
stroppers1356713stroppers
stroppier1364463stroppier
stumper113610093stumper
sumpter1138873sumpter
super74924483s__uper
supped114415703s_upped
suppers113314703s_uppers
suppler1148433suppler
swamper14349313swamper
swapped15429143swapped
swappers15358083swappers
sweeper12329373sweeper
swobber14336543swobber
swooner10358673swooner
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
swotter10399473swotter
sypher14317083s_ypher
tapper104419613_tapper
thorpe113610093thorpe_
thorpes125010353thorpes
thumper14356953thumper
tipper103918413_tipper
toper75231023_to_per
topped114617723_topped
toppers113914603_toppers
trapper113912803trapper
tripper113711923tripper
trooper94210363trooper
trouper93811433trouper
unstopper1343523unstopper
upper93714263__upper
whapped18367573whapped
whappers18276743whappers
whimper17297723whimper
whipped18379333whipped
whippers18329043whippers
whippet17328843whippet
whippier18265823whippier
whisper15298013whisper
whoever1634103whoever
whomped18345473whomped
whooped16326933whooped
whoopee15287523whoopee
whoopers16286263whoopers
whupped18365413whupped
wrapper14368333wrapper
yapper133714513_yapper
zapper193414023_zapper
zipper193813123_zipper

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 Limit1340275266.84319586.0
3Display Results5265260.1862828.0
 (SQL Overall)1786915267.43524033.8
 
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.