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

500 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
shoppe13311032(None) 
shopped153512211shopped
shopper143312631shopper
shoppes143411391shoppes
chopped174511002chopped
chopper163611892chopper
choppy18376292choppy
hope96639672_ho_pe
hopped144318112_hopped
hopper134218482_hopper
hopple132910482_hopple
hoppy154912352_hoppy
schappe1635262schappe
scope94821482sco_pe
shape105125112sh_ape
shipped153312102shipped
shippen14298862shippen
shipper143514042shipper
shoe75933442sho__e
shone83725982sho_ne
shop95629842sho_p_
shopmen14277202shopmen
shoppers153010762shoppers
shops104222902sho_ps
shore85432652sho_re
shote85526102sho_te
shove114421042sho_ve
slope75823562slo_pe
slopped123511442slopped
sloppy1395302sloppy
sopped114819902s_opped
soppy125113522s_oppy
steppe10319872steppe
stope74727242sto_pe
stopped124512202stopped
stopper113012602stopper
stopple1156582stopple
swopped15437672swopped
thorpe113610092thorpe
whopped18358002whopped
whopper17328502whopper
ahorse9311513ahorse
ashore9414613asho_re
aslope839013aslo_pe
bopped134413403_bopped
bopper123813833_bopper
chape125221143ch_ape
chapped172711443chapped
chappie16298653chappie
chipped174110813chipped
chipper163912583chipper
chippie16297693chippie
chippy18437613chippy
choice132010523choice
choke145118023cho_ke
chomp144815663chomp_
chomped17329773chomped
chomper163810073chomper
chomps155112223chomps
choose115116143choose
chop116024923cho_p_
chopin132712193chopin
chopine143512263chopine
choppers174110463choppers
choppier17286643choppier
chops125019873cho_ps
chore105126763cho_re
chose105925403cho_se
chouse116017563chouse
chowse144711753chowse
chuppa1543973chuppa
clopped143611523clopped
cope86847383_co_pe
copped135221253_copped
copper124321893_copper
copse95623923_copse
coupe96023483_coupe
cropped143812063cropped
cropper133312963cropper
croppie13278793croppie
croupe105114433croupe
dhole95215363dho_le
dope76038893_do_pe
dropped13329283dropped
dropper12329873dropper
elope75219343elo_pe
epopee10312503epopee
estopped1334993estopped
estoppel1243173estoppel
flopped15338763flopped
flopper14328473flopper
floppy1654873floppy
fopped144012673_fopped
frappe13286953frappe
glopped13347613glopped
gloppy1454723gloppy
grippe115310323grippe
grope84821613gro_pe
happed144820103_happed
happen134812193_happen
happy155813533_happy
hepper133412663_hepper
hipped144317693_hipped
hipper133818023_hipper
hippie132811243_hippie
hippo12369063_hippo
hippy155112793_hippy
hoe67562723_ho__e
hoise85224773_hoise
hoke115935933_ho_ke
hole77553393_ho_le
holp95727553_holp_
holpen11299413_holpen
home98042443_ho_me
homie104622533_homie
hone77549323_ho_ne
hoop96129983_hoop_
hooped125518183_hooped
hooper114518313_hooper
hoopoe11911233hoopoe
hoops105621073_hoops
hop87554593_ho_p_
hoped115628183_hoped
hoper105829143_hoper
hopes105835643_hopes
hoppers143115143_hoppers
hoppier143110703_hoppier
hoppled15338083_hoppled
hopples142810713_hopples
hops97942633_ho_ps
horde94623053_horde
horse86132653_horse
hose76547243_ho_se
house89131423_house
hove107132223_ho_ve
howe106734103_ho_we
hoyle11314413_hoyle
hype125519813_h_ype
knopped16355453knopped
kopje1835273_kopje
koppa13397293_koppa
koppie14277883_koppie
lope65941923_lo_pe
lopped114218623_lopped
lopper103717203_lopper
loppy125911663_loppy
loupe75319513_loupe
mope86838043_mo_pe
mopped134114323_mopped
mopper126215003_mopper
moppet126915093_moppet
myope124010973myo_pe
nappe96114993_nappe
nope65934193_no_pe
ope56845243__o_pe
people10310193people
phoebe1335003phoebe
phone105621933pho_ne
plopped11288773plopped
pope85535613_po_pe
poppa8409893_poppa
popped104117813_popped
popper93615963_popper
poppet92717323_poppet
popple92710983_popple
poppy114813193_poppy
propped113311953propped
rhaphe1433423rhaphe
rope65542913_ro_pe
salpae84614273salpae
sample104215013sample
sapote8314363sapote
sapped114422013s_apped
sapper103822353s_apper
sappy125413473s_appy
sarape84817573sarape
scape96921843s_cape
schappes1736033schappes
sconce104711723sconce
scone74621833sco_ne
scoop95617163scoop_
scooped124611743scooped
scooper113812033scooper
scoops105414363scoops
scop85925523sco_p_
scoped115116653scoped
scopes104719593scopes
scops95820193sco_ps
score75526743sco_re
scouse84113633scouse
scrape105917573scrape
scupper1367423scupper
semple103212753semple
sempre102710093sempre
serape84818413serape
shade95125583sh_ade
shake124726403sh_ake
shale85332833sh_ale
shame105726703sh_ame
shaped125020103shaped
shapen114414653shapen
shaper114119933shaper
shapes115124943shapes
share86437083sh_are
sharp104922533sharp_
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238393sharpie
sharps115516083sharps
sharpy145211033sharpy
shave114425893sh_ave
shavie124312423shavie
she66837693sh___e
sheave124514003sheave
sheep105321523sheep_
sheeve123412843sheeve
shelve124012763shelve
sherpa1138093sherpa
shikse1386073shikse
shine85533093sh_ine
ship95228243sh_ip_
shipmen14317283shipmen
shippens15316803shippens
shippers153012313shippers
shippon14285803shippon
ships105123773sh_ips
shire84727133sh_ire
shive114423423sh_ive
shlep104914833shlep_
shlepp13366193shlepp
shlepped1633643shlepped
shlepps14394833shlepps
shleps114710333shleps
shmooze21255263shmooze
shnapps1463343shnapps
shnaps1148083shnaps
shoal83920273sho_al
shoaled113810973shoaled
shoaler102610083shoaler
shoals94215793shoals
shoaly124010773shoaly
shoat85633953sho_at
shoats94117083shoats
shock144917033sho_ck
shocked174611813shocked
shocker163411433shocker
shocks154414583shocks
shod86225063sho__d
shodden12265763shodden
shoddy1434543shoddy
shoed95723013sho_ed
shoepac1444013shoepac
shoer84722163sho_er
shoers94518333shoers
shoes85429663sho_es
shofar1236313shofar
shog86025143sho__g
shogged13397963shogged
shogi95014013sho_gi
shogis103810943shogis
shogs95319713sho_gs
shogun1045713shogun
shoji15419963sho_ji
shojis16348493shojis
sholom11910113sholom
shoo75929893sho__o
shooed103916083shooed
shook124920163sho_ok
shooks134515633shooks
shool84523153sho_ol
shooled115212663shooled
shools94919013shools
shoon84022013sho_on
shoos84226363sho_os
shoot84235913sho_ot
shooter103013993shooter
shoots94619363shoots
shopboy1743803shopboy
shophar1555463shophar
shopman14247263shopman
shopping163611293shopping
shoran94016043shoran
shored105723653shored
shores94830413shores
shorl84720253sho_rl
shorls94516203shorls
shorn85722183sho_rn
short85040533sho_rt
shorted113614403shorted
shorten103511413shorten
shorter103515503shorter
shortie10411343shortie
shorts95321743shorts
shorty124313203shorty
shot76150263sho__t
shotes95321913shotes
shots84730853sho_ts
shott85332193sho_tt
shotted113912403shotted
shotten10288463shotten
shotts93614703shotts
should1038033should
shout85433173sho_ut
shouted113911553shouted
shouter103213083shouter
shouts94017723shouts
shoved134214283shoved
shovel124611323shovel
shover124515993shover
shoves124919423shoves
show106229193sho__w
showed135016973showed
shower124315113shower
showier1339103showier
showmen15227173showmen
shown115216483sho_wn
shows115324583sho_ws
showy145714013sho_wy
shoyu1138913sho_yu
shoyus1266003shoyus
shrike134513243shrike
shrine94920053shrine
shrive125216953shrive
shrove125412233shrove
shute84520353sh_ute
simple104315173simple
sinopie948783sinopie
sipe67341043s__ipe
sipped113720633s_ipped
sipper103920993s_ipper
sippet103519393s_ippet
skipped16358413skipped
skipper15339573skipper
skippet15288463skippet
slapped123511843slapped
slapper113512463slapper
slipe75626133s_lipe
slipped124711743slipped
slipper113712983slipper
slippy1375843slippy
sloe45534953slo__e
sloop76118913sloop_
sloops85513623sloops
slop66533873slo_p_
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
sloppier1255703sloppier
slops75026013slo_ps
slype105112363s_lype
smoke115015823smo_ke
smote75820283smo_te
snapped124611203snapped
snapper113512073snapper
snappy1366103snappy
snipe75320573s_nipe
snipped123510043snipped
snipper113911333snipper
snippet113310433snippet
snippy1374843snippy
snoop75317173snoop_
snooped103711813snooped
snooper93511533snooper
snoops84314173snoops
snoopy11449473snoopy
snooze15439993snooze
snore55424953sno_re
soap65831133s_oap_
soaped95817973s_oaped
soaper84517873s_oaper
soaps75120713s_oaps
soapy106114783s_oapy
soave84219053s_oave
socle7419573s_ocle
soke85436263s_o_ke
sole46053673s_o_le
solve85618943s_olve
some66040383s_o_me
sonde64622833s_onde
sone46649983s_o_ne
soothe94214853soothe
sop57557863s_o_p_
soph97024203s_o_ph
sophs104916023s_ophs
sophy136611763s_ophy
sopite84917713s_opite
sopor74016493s_opor
soppier112711583s_oppier
sops65244563s_o_ps
sore47059533s_o_re
soup66232913s_oup_
souped95017673s_ouped
soups75322943s_oups
soupy106115403s_oupy
souse56530773s_ouse
spae65034323s__pae
spode84617703spo_de
spoke114818663spo_ke
sponge939663sponge
spore75428593spo_re
spouse84112513spouse
spue66025523s__pue
staple84415823staple
stepped123210053stepped
stepper113010853stepper
steppes113110693steppes
stipe76523373s_tipe
stipple1146623stipple
stoae55024263sto_ae
stodge8369043stodge
stogie7311323stogie
stoke94922513sto_ke
stole54928813sto_le
stomp95616663stomp_
stomped124110533stomped
stomper114111233stomper
stomps105612833stomps
stone55431183sto_ne
stooge73811663stooge
stoop75821543stoop_
stooped103813833stooped
stooper93813193stooper
stoops85917893stoops
stop66532033sto_p_
stoped94721013stoped
stoper84320103stoper
stopes84525893stopes
stoppage1344683stoppage
stoppers123910593stoppers
stoppled1345003stoppled
stopples1236953stopples
stops74827283sto_ps
stopt76528353sto_pt
store56333813sto_re
stoup75517073stoup_
stoups85313273stoups
stoure64814943stoure
stove85220253sto_ve
stowp105614233stowp_
stowps115710583stowps
stripe85822443stripe
strophe1239143strophe
stropped1367343stropped
stropper1247763stropper
stroppy14205093stroppy
stupe75217753s_tupe
supe65932763s__upe
supped114415703s_upped
supper104115433s_upper
supple10410203supple
swapped15429143swapped
swapper14359703swapper
swipe105217083s_wipe
swiple11379233swiple
swipple1444633swipple
swoop105213433swoop_
swooped13418753swooped
swooper12389173swooper
swoops114910923swoops
swoopy14487283swoopy
swop95120503swo_p_
swops105913973swo_ps
swore84920823swo_re
thole85620843tho_le
thorp104414263thorp_
thorpes125010353thorpes
thorps113610893thorps
those85218143tho_se
tope65946383_to_pe
topee76029953_topee
tophe106718973_tophe
topped114617723_topped
topper103817603_topper
topple104411323_topple
trompe105611263trompe
trope75725803tro_pe
troupe84812433troupe
whapped18367573whapped
whapper17348273whapper
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
whippy19385843whippy
whole114418093who_le
whomp155011323whomp_
whomped18345473whomped
whomps16457603whomps
whoop134211443whoop_
whooped16326933whooped
whoopee15287513whoopee
whooper15297153whooper
whoopie15295933whoopie
whoops14487863whoops
whop125520923who_p_
whoppers18297533whoppers
whops135013933who_ps
whore116018043who_re
whose114914533who_se
whupped18365413whupped

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 Filter1786911127160.376475242.0
2DLD Change Limit1127165005.62620034.8
3Display Results5005000.1533268.0
 (SQL Overall)1786915006.15529031.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.