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

279 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
opposes114924(None) 
apposes11511471apposes
oppose1039191oppose_
opposed1236121opposed
opposer1135771opposer
opposers1244971opposers
appose10411992appose_
apposed1247852apposed
apposer1147482apposer
apposers1236282apposers
composes145017112composes
deposes103117212deposes
eposes84418782_eposes
exposes1639962exposes
imposes113213682imposes
opposites1346142opposites
oppress1135992oppress
opuses84012242o_puses
osmoses9138122osmoses
ostoses71213552ostoses
poses74642762__poses
proses84733472_proses
ptoses83514672_ptoses
pyoses114314302_pyoses
reopposes1345822reopposes
reposes94021262reposes
supposes1238202supposes
abioses9311493abioses
adiposes1137173adiposes
aldoses8311203aldoses
apheses12610703apheses
apodoses1136653apodoses
apoptoses1346443apoptoses
appeases1238663appeases
apples104315763app_les
applies11311223applies
apprises12310963apprises
approves15126833approves
appulses1234893appulses
apses76823913_ap_ses
arkoses113910833arkoses
aspises9611643aspises
bigoses1039073bigoses
broses86524403_broses
capotes11314643capotes
chaoses124715123chaoses
chooses125717423chooses
choses115825133_choses
closes85425593_closes
compose135716663compose_
composed154612063composed
composer145012953composer
composers153910623composers
composts144210913composts
compotes144716513compotes
conioses10313313conioses
coppices1638243coppices
copses104922473cop_ses
corpses113913803corp_ses
corpuses12310063corpuses
coses76949493__coses
cosmoses1239703cosmoses
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
demoses103815823demoses
depones103717093depones
depose94215763depose_
deposed113412023deposed
deposer104011843deposer
deposers11359243deposers
diploses111110323diploses
dipoles101013753dipoles
disposes11313823disposes
doses65938503__doses
epodes94315563_epodes
epopees1137233epopees
eroses65327053_eroses
espouses1037303espouses
ethoses10311763ethoses
expose1549523expose_
exposed1737443exposed
exposer1637413exposer
exposers1736133exposers
fucoses12148303fucoses
gaposis1038423gaposis
gnoses76515163_gnoses
gomphoses1745833gomphoses
gooses75723053_gooses
haploses1338853haploses
heptoses1338373heptoses
hexoses17228883hexoses
hognoses12108133hognoses
hommoses1538153hommoses
hoopoes121212483hoopo_es
hopples142810713hopp_les
hoses85443173__hoses
hypnoses1646633hypnoses
impones112712253impones
impose103113053impose_
imposed123110293imposed
imposer113310103imposer
imposers12278463imposers
imposts11269003imposts
ketoses114912873ketoses
koppies153210013kopp_ies
kyphoses2045283kyphoses
lapises93513463lapises
lapses85217693lap_ses
lipases9209483lipases
looses67328243_looses
lordoses937143lordoses
loses56742013__loses
lotoses73713643lotoses
lupuses936273lupuses
meioses9310833meioses
mioses84318853_mioses
mitoses9312183mitoses
mopokes1536693mopokes
morphoses1648123morphoses
mycoses1437733mycoses
myoses114013843_myoses
nooses65623643_nooses
noses55435643__noses
oases55330983o__ases
oboes75717713o_bo_es
oboles83815833o_boles
onuses65616253o_nuses
oospores1049533oospores
oozes145418713o__ozes
opaques1833643opaques
operose939433operose_
opes65942613o_p__es
ophites12310103ophites
opiates9312143opiates
opines84820703o_pines
opioids1036523opioids
opponent1246403opponent
opponents1343973opponents
opposeless1441673opposeless
opposing1336383opposing
opposite1247133opposite
oppresses1346873oppresses
oppugns1241933oppugns
optimes1148473optimes
orgones81010793orgones
orioles7412993orioles
orpines94414793orpines
orrises71312233orrises
orthoses11311133orthoses
oses46641513___oses
osmoles9138363osmoles
osmose8108003osmose_
osmosed10134843osmosed
osmosis976573osmosis
osteoses839033osteoses
ostosis71310123ostosis
otiose639403otiose_
ouphes113614633oup_hes
outposts1037253outposts
oyesses1037333oyesses
ozones1539393o_zones
papooses1248053papooses
pappooses1243993pappooses
pappose1047413pappose_
parses85534703_parses
pases75346503__pases
passes86030473_passes
pauses84621473_pauses
peases85229473_peases
peises84125043_peises
peones83821043_peones
peploses1269473peploses
perses85428063_perses
phases114618403_phases
phones114121213_phones
physes14399783_physes
pisses84525083_pisses
pluses83618073_pluses
pocosen1146833pocosen
pocosens1255253pocosens
poises84226543_poises
pokes116133013__pokes
poles75351003__poles
pomes94833933__pomes
pones74547043__pones
pooves113914713_pooves
popes95933813__popes
popover1495843popover
popovers1595663popovers
poppies102816203poppies
popples103011873popples
popsies112816463popsies
pores75849033__pores
porose84818743porose_
porpoises1348433porpoises
pose66441733__pose_
posed85828413__posed
poser75128773__poser
posers84223973__posers
posies84431433__posies
posoles9314883posoles
posse74722273__posse
posses85128803_posses
postposes1348193postposes
posts75228783__posts
poxes145325723__poxes
pozoles1839063pozoles
prases84429023_prases
prises84133173_prises
probes104119453_probes
proles84627203_proles
proposes122515973proposes
proptoses1349873proptoses
prose75835123_prose_
prosed94921093_prosed
proser84223463_proser
prosers94219643_prosers
prosos85718553_prosos
pross76529403_pros_s
prosses94019513_prosses
proves114322253_proves
ptosis83611823_ptosis
pulses83818663_pulses
purposes1237823purposes
purses84826373_purses
puses75532203__puses
pusses84322843_pusses
pyosis114012123_pyosis
reoppose1245563reoppose_
reopposed1444333reopposed
repose84121413repose_
reposed103616273reposed
reposer93715333reposer
reposers102911603reposers
riboses9310443riboses
ripostes10239083ripostes
riposts9279403riposts
rooses65526233_rooses
roses56445773__roses
sapotes9313943sapotes
saroses73619333saroses
sepses84515883sep_ses
sorboses1038523sorboses
soroses73117483soroses
speises93813933speises
spenses92913573spenses
splores91910953splores
sploshes1336133sploshes
spodes94817433_spodes
spokes124417213_spokes
spores84726613_spores
spouses92912813spouses
suppose1137973suppose_
supposed1345783supposed
supposer1245593supposer
supposers1344533supposers
sycoses1249133sycoses
tapises92914013tapises
topples113111653topp_les
trioses75015653trioses
triposes1039973triposes
unopposed1443133unopposed
unposed10711903unposed
upases84112903_upases
uppiles11208263uppiles
uprises92012733uprises
uprose82311483uprose_
uprouses1037553uprouses
uptoss836093uptos_s
uptosses1043973uptosses
vamoses1239143vamoses
viroses10310533viroses
woopses1237883woop_ses
xeroses143612823xeroses
xyloses1746843xyloses
zeppoles2143583zeppoles
zoonoses1746203zoonoses
zygoses20436783zygoses
zymoses21608693zymoses

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 Filter1786911340270.623286823.4
2DLD Change Limit1340272798.00016753.4
3Display Results2792790.0933000.0
 (SQL Overall)1786912798.71620501.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.