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

180 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
oppress113599(None) 
compress1439052compress
cypress1434662cypress
depress10239872depress
empress1138162empress
express1637492express
hotpress1344302hotpress
impress1137772impress
ogress7529502o_gress
opposes1149242opposes
oppressed1445122oppressed
oppresses1346872oppresses
oppressor1363812oppressor
ospreys1233142ospreys
outpress10118182outpress
press75425952__press
repress92712682repress
suppress1236442suppress
actress948533actress
address956103address
aggress935593aggress
ancress978613ancress
apparels1245123apparels
appels104312793app_els
apples104315763apple_s
applets115710063applets
apposes11511473apposes
appressed1445943appressed
apprise11310193apprise
apprises12310963apprises
apres75426403_apre_s
aptness9268573aptness
boppers133911923bopp_ers
capless114312763capless
caress85720263_caress
congress1138073congress
copperas14308573copperas
coppers133519753copp_ers
coppras13327833coppr_as
cress75022833__cress
cypres1338533cypre_s
cypreses1535143cypreses
digress938323digress
dopiness11289973dopiness
dress65319833__dress
duress74712063_duress
egress73310433_egress
eldress835003eldress
espresso1043193espresso
expresso1743883expresso
fortress1136753fortress
gapless10349993gapless
hapless123311333hapless
heiress1036813heiress
hipless12399923hipless
hipness12277383hipness
hoopless13279263hoopless
hopeless13118303hopeless
hoppers143115143hopp_ers
hoppiest152610733hoppiest
hopples142810713hopple_s
impresa1134753impresa
impresas1244453impresas
imprese1138143imprese
impreses1238093impreses
imprest11310203imprest
imprests1246313imprests
ingress838653ingress
koppies153210013koppie_s
koupreys1741733koupreys
lipless9259553lipless
loppers113014103lopp_ers
loppiest122410113loppiest
mopiness12259063mopiness
moppers133412463mopp_ers
moppets13307163mopp_ets
napless93110283napless
oarless73913373oarless
obsess845943o_bsess
ochres113510833ochre_s
oddness935313oddness
odorless934173odorless
ogres65818633o_gre_s
oldness836403oldness
ombres103911143ombre_s
oneness7512143oneness
openers9339493openers
openest9312913openest
openness1035473openness
opens76118553o_p_ens
operas8312453oper_as
operons91411743operons
operose939433operose
opes65942613o_p_e_s
opines84820703opine_s
oppose1039193opp_ose
opposed1236123opposed
opposer1135773opposer
opposers1244973opposers
oppressing1545973oppressing
oppression1445883oppression
oppressive1745373oppressive
oppressors1463843oppressors
oppugns1241933oppugns
opuses84012243opuse_s
oratress834553oratress
orbless937493orbless
ores46056683o__re_s
orphreys16132053orphreys
osprey1134883ospre_y
ouphes113614633ouphe_s
outdress9137323outdress
pareos87023773_pareos
parers85530743_parers
pares77164483_pare_s
pareses94718883_pareses
paresis93315093_paresis
pareus85420743_pareus
parses85534703_parses
peeress939503peeress
peres76246643_pere_s
perses85428063_perses
poetess938933poetess
poorest9312773poorest
poorness1036363poorness
popeless1288473popeless
popes95933813pop_e_s
poppers103414863poppers
poppets10338853poppets
poppies102816203poppie_s
popples103011873popple_s
pores75849033_pore_s
portress1038323portress
possess9419123possess
pourers93513673pourers
prees75937173__prees
prepress12137983prepress
preps96220693__preps
presa74319043__presa
prese75228383__prese
prest75736353__prest
prests84021263__prests
preys105717783__preys
priss74623893__priss
pross76529403__pross
purees84721683_purees
purest84021933_purest
purses84826373_purses
pyres105523883_pyre_s
redress82511873redress
regress82711453regress
ropiness102311073ropiness
sapless93313443sapless
seeress7311573seeress
soapless10278073soapless
soppiest122511943soppiest
soppiness1336543soppiness
soupless10268463soupless
sparers94519613sparers
spares84834553spare_s
sparest94616433sparest
spireas94412513spireas
spirems11499563spirems
spires84628113spire_s
spores84726613spore_s
sprees85620643_sprees
stress66616673_stress
tigress836093tigress
tipless92610063tipless
topcross1253383topcross
topless92511123topless
toppers113914603topp_ers
topples113111653topple_s
tress55423163__tress
undress838893undress
uppers102912293upp_ers
upprops1044223upprops
votaress1144223votaress
votress1035483votress
zipless18276303zipless

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.410435831.7
2DLD Change Limit1340271806.71619956.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.18924856.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.