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

300 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
oppose103919(None) 
appose10411991appose
opposed1236121opposed
opposer1135771opposer
opposes1149241opposes
apposed1247852apposed
apposer1147482apposer
apposes11511472apposes
compose135716662compose
depose94215762depose
expose1549522expose
impose103113052impose
operose939432operose
opposers1244972opposers
opposite1247132opposite
osmose8108002osmose
otiose639402otiose
pappose1047412pappose
porose84818742porose
pose66441732__pose
prose75835122_prose
reoppose1245562reoppose
repose84121412repose
suppose1137972suppose
uprose82311482uprose
adipose1036653adipose
aldose7311093aldose
apos65433823_apos_
appease1137913appease
apple94517673app_le
apples104315763apples
apposers1236283apposers
apposite12410013apposite
apprise11310193apprise
approve14116603approve
apps86319693app_s_
appulse1134673appulse
apse67725383_ap_se
ariose64818723ariose
arkose104911343arkose
arose55832083_arose
brose75227033_brose
capos94826073capos_
capote10315733capote
choose115116143choose
chose105925403_chose
close76425223_close
comose105016843comose
compone136517193compone
compos124818803compos_
composed154612063composed
composer145012953composer
composes145017113composes
compost134515353compost
compote135616463compote
coppice1537483coppice
copse95623923cop_se
corpse104013403corp_se
cowpoke1835103cowpoke
cymose13429653cymose
depone93616553depone
deposed113412023deposed
deposer104011843deposer
deposes103117213deposes
dipole91112853dipole
dispose10312763dispose
dose56442433__dose
epode85114093_epode
epopee10312503epopee
epos66723733_epos_
eposes84418783_eposes
erose55727273_erose
espouse936403espouse
expos1449203expos_
exposed1737443exposed
exposer1637413exposer
exposes1639963exposes
filose96112503filose
foliose10378013foliose
foppish1735103foppish
fucose11167683fucose
goose65925903_goose
gyrose105310253gyrose
heptose1237493heptose
hexose16267843hexose
hippos13408433hippos_
hognose11117243hognose
hoopoe11911233hoopo_e
hoopoes121212483hoopoes
hopple132910483hopp_le
hopples142810713hopples
hose76547243__hose
hypos1312014743hypos_
impone103011863impone
imposed123110293imposed
imposer113310103imposer
imposes113213683imposes
impost103011783impost
jocose1537103jocose
ketose105711813ketose
koppas14407603koppas_
koppie14277883kopp_ie
koppies153210013koppies
lanose6313593lanose
lapse74917683lap_se
leprose938543leprose
lipase8239103lipase
loose56627683_loose
lose45144583__lose
moose76327193_moose
mopoke1436633mopoke
morose85116243morose
mucose10149313mucose
nodose738883nodose
noose55624063_noose
nose46739363__nose
obese75212423o_bese
oboe66822943o_bo_e
oboes75717713o_boes
obole75917143o_bole
obtuse8147483obtuse
ochone11311293ochone
oleos55419683oleos_
olios54520853olios_
onos46229003o_nos_
oops65232673oop_s_
oospore939013oospore
ooze136420603o__oze
opahs105411983opahs_
opals75718353opals_
opaque1734213opaque
ope56845243o_p__e
opens76118553opens_
opes65942613o_pes_
ophite11410563ophite
opiate8513463opiate
opine77422463o_pine
opines84820703opines
opioid9310083opioid
opponent1246403opponent
opposable1544063opposable
opposing1336383opposing
opposites1346143opposites
oppress1135993oppress
oppugn1142793oppugn
ops56641253o_p_s_
optime1079353optime
opts68124743o_pts_
opus66420593o_pus_
opuses84012243o_puses
ordos65216203ordos_
orgone71110913orgone
oriole6814293oriole
orpine83914483orpine
orzos143311253orzos_
ose38147343___ose
osmole8128513osmole
osmosed10134843osmosed
osmoses9138123osmoses
ostoses71213553ostoses
ottos54714323ottos_
ouphe104413263oup_he
ouphes113614633ouphes
ouphs104311273ouphs_
outpost9612443outpost
ouzos143210413ouzos_
owse76321623o__wse
ozone14310613o_zone
paise75028333_paise
papoose1147513papoose
pappoose1143803pappoose
parse75236993_parse
pase65346863__pase
passe75525693_passe
pause75021833_pause
pease75231113_pease
peise75825773_peise
pepos96620083pepos_
perse75429523_perse
phase104617213_phase
phone105621933_phone
pilose84514243pilose
pocosen1146833pocosen
poise75127893_poise
poke105335363__poke
pole65951303__pole
polos76129913polos_
pome85636693__pome
pomos95321583pomos_
pone65747533__pone
poops94422413poops_
poos65949113_poos_
poove104514303_poove
pope85535613__pope
popes95933813popes_
popish133812113popish
popover1495843popover
poppas93710713poppas_
poppies102816193poppies
popple92710983popple
popples103011873popples
pops86340953pop_s_
popsie103013053popsie
popsy125713403pop_sy
pore66451263__pore
porpoise1248083porpoise
posed85828413__posed
poser75128773__poser
poses74642763__poses
posh95427323__posh
posole8314223posole
posse74722273_posse
post67953363__post
postpose1247653postpose
posy96028423__posy
pozole1758913pozole
prase76128753_prase
prese75228383_prese
prise74632613_prise
probe94320813_probe
prole74527793_prole
prone75332623_prone
propose112714843propose
pros65742783_pros_
prosed94921093_prosed
proser84223463_proser
proses84733473_proses
proso77222413_proso
pross76529403_pross
prost75434103_prost
prosy106319253_prosy
prove104823193_prove
psoae74411623_psoae
ptoses83514673_ptoses
pulse74219973_pulse
purpose1137383purpose
purse76028893_purse
pyoses114314303_pyoses
ramose8314403ramose
reopposed1444333reopposed
reopposes1345823reopposes
repos74725793repos_
reposed103616273reposed
reposer93715333reposer
reposes94021263reposes
rerose63320843rerose
ribose839893ribose
rimose8310593rimose
ripost83615003ripost
riposte9269623riposte
roose56127093_roose
rose46148903__rose
rugose737283rugose
sapote8314363sapote
scapose1147753scapose
setose65114773setose
sorbose938983sorbose
sparse84516343sparse
speise84614253speise
spense83912433spense
spinose937943spinose
splore81611303splore
splosh1186543splosh
spode84617703_spode
spoke114818663_spoke
spore75428593_spore
spouse84112513spouse
supposed1345783supposed
supposer1245593supposer
supposes1238203supposes
those85218143_those
topmost1148173topmost
topos75726393topos_
topple104411323topp_le
topples113111653topples
torose64317693torose
trappose1245813trappose
triose64715383triose
typhose1546693typhose
typos106015813typos_
unopposed1443133unopposed
unposed10711903unposed
upbore10247883upbore
updos8389513updos_
updove1234483updove
uphove1436133uphove
upmost1068193upmost
uppile10178503uppile
uppish1336633uppish
uprise82313693uprise
uprouse937223uprouse
uptore8279453uptore
uptoss836093uptoss
vadose1037963vadose
vamose1159283vamose
venose9310843venose
whose114914533_whose
xylose1636763xylose
zeppole2043493zeppole
zygose19455553zygose

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.390458182.1
2DLD Change Limit1127163005.50020493.8
3Display Results3003000.0933225.8
 (SQL Overall)1786913005.98329866.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.