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

424 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
regress8271145(None) 
egress73310431_egress
redress82511871redress
regrets83212921regrets
repress92712681repress
aggress935592aggress
degrees92810722degrees
depress10239872depress
digress938322digress
egrets72712242_egrets
heiress1036812heiress
ingress838652ingress
legless838012legless
ogress7529502_ogress
peeress939502peeress
pegless1038052pegless
prepress12137982prepress
progress1137022progress
rearers74323562rearers
recess8314262re_cess
recross989832recross
redigress1143642redigress
redness82012442redness
refresh1335452refresh
reges65628792reg_e_s
reglets83512982reglets
regloss8218022regloss
regreen8309042regreen
regreens9257452regreens
regreet83015952regreet
regreets9287852regreets
regressed1138112regressed
regresses10310462regresses
regressor1064612regressor
regret73723532regre_t
regrew10388562regre_w
regrows11269152regrows
restress82511772restress
ryegrass1242792ryegrass
seeress7311572seeress
tigress836092tigress
actress948533actress
address956103address
aegises8311373aegises
ageless8310343ageless
agrees74915323_agrees
aigrets82810533aigrets
ancress978613ancress
bearers94619593bearers
bedless1039703bedless
befrets1237613befrets
begets96215523beg_ets
begrims1276763begrims
berets85822523be_rets
bigness1038193bigness
burgess10409343burgess
caress85720263_caress
ceres75540013ce_re_s
cereus85215523ce_reus
congress1138073congress
cress75022833__cress
crewless1335413crewless
cypress1434653cypress
dearest83618673dearest
dearness939973dearness
decrees102513123decrees
degases93413103degases
degauss933923degauss
degerms1135623degerms
degrease1045413degrease
degreases1146153degreases
degree82814853degre_e
degreed10258883degreed
derepress1243583derepress
dewless1137473dewless
dress65319833__dress
duress74712063_duress
eagres74014573eagre_s
earless74316073_earless
eelgrass942973eelgrass
egers65120373_eg_ers
egest65222343_eg_est
egests74411253_eg_ests
eggers84612583_eggers
eggless935663eggless
egises7312493_egises
egoless836983_egoless
egressed1046873_egressed
egresses949443_egresses
egret63327313_egre_t
eldress835003eldress
empress1138163empress
engross837123engross
erses55826803_e_rses
excess1546053_excess
express1637493express
eyres84921773_eyre_s
fearers104815273fearers
fearless1137873fearless
feeless103511103feeless
feres86038183fe_re_s
ferrels10248623ferrels
ferrets103111393ferrets
fewness1335003fewness
feyness1334923feyness
fogless1138193fogless
freeness11710443freeness
freres94716173fre_re_s
fretless1138063fretless
gearless937373gearless
genres75515623genre_s
glegness1034613glegness
grass66125203__grass
greegrees1142853greegrees
grees65132473__grees
greyness1235243greyness
greys96614853__greys
gross65421693__gross
guess64213363__guess
hearers104319783hearers
hearses104414533hearses
heirless1146053heirless
heres86245903he_re_s
heresy125011233he_resy
impress1137773impress
ireless72312243ire_less
jagless1537103jagless
jeerers14328923jeerers
keggers13357043keggers
keglers12277773keglers
kermess13396223kermess
keyless1436163keyless
largess8408913largess
legers74518313leg_ers
leges64427293leg_e_s
megass9219443meg_ass
megrims1276103megrims
meres75143573me_re_s
merest84725113me_rest
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
metres85121563metre_s
nearest73415843nearest
nearness838313nearness
neguses837933neguses
nereis6315343ne_reis
netless739863netless
newness1035703newness
ogres65818633_ogre_s
oppress1135993oppress
oratress834553oratress
peerless1037513peerless
peres76246643pe_re_s
perses85428063pe_rses
petrels9279373petrels
prebless1236823prebless
precess11310863pre_cess
preggers12236833preggers
prepregs13144763prepregs
press75425953__press
prestress1138133prestress
prioress1035393prioress
pugrees10218523pugrees
ragees74618663rag_ees
rages64539443rag_e_s
raggees93710913raggees
rares55247443r_are_s
rarest65725483r_arest
rawness1038153rawness
raygrass1242883raygrass
rayless10239003rayless
readdress1143823readdress
readers83823773readers
reales64934123reale_s
realest73322433realest
realness8410443realness
reamers94221083reamers
reapers93520453reapers
reared75930013reare_d
rearer64928913reare_r
rearms85114653rear_ms
rearrest8311603rearrest
rearrests945313rearrests
rears54739653rear__s
reassess836513reassess
reavers108320743reavers
reaves94127573reave_s
rebbes10313533rebbe_s
rebecs103913673re_becs
rebels84518133re_bels
rebores95319163rebore_s
rebred95816353rebre_d
rebreed104611073rebreed
rebreeds11426003rebreeds
rebuses94915293rebuses
recces10614913recce_s
rechews1537293rechews
reckless14257973reckless
recuses94619463recuses
reddens9259783reddens
redders93615343redders
reddest9311953reddest
redeems1037163redeems
redes65139133re_de_s
redlegs936823redlegs
redoes74623773redoe_s
redraws11218473redraws
redream10107913redream
redreams1195953redreams
redressed1137773redressed
redresser1056793redresser
redresses10410293redresses
redressor1064223redressor
redrew10309513redre_w
redries83721713redries
redyes104214093redye_s
reeds65430903re__eds
reefers103312593reefers
reefs85121663re__efs
reekers113613143reekers
reeks94124033re__eks
reelers73520273reelers
reels55333263re__els
reerect92915883reerect
reerects10319923reerects
rees45364193re__e_s
reest54938093re__est
reests64618893re__ests
reeves94721493reeve_s
reexpress1842793reexpress
refeeds11368973refeeds
refeels10379693refeels
refels94618053re_fels
referees111310413referees
refers93921083re_fers
refires104820313refire_s
reflets103513153reflets
reforest1139963reforest
reforests1245533reforests
refreshes1595953refreshes
refries104419733refries
refuels10399523refuels
refuses104918553refuses
regains84316583regains
regalers94311133regalers
regales83520793regales
regalness1045473regalness
regardless1252893regardless
regards94112563regards
regear73512743reg_ear
regears83012463regears
regent74127673reg_ent
regents83416543regents
reggaes948883reggaes
regilds996673regilds
regimens11469233regimens
regimes104514743regimes
reginas85614063reginas
regions83613473regions
regius7311923reg_ius
regives115014213regives
reglet73724233regle_t
reglows11288843reglows
reglues838713reglues
regorges10238413regorges
regrade92612033regrade
regrades103212173regrades
regraft11310153regraft
regrafts1235303regrafts
regrant8317323regrant
regrants9310013regrants
regrate82618663regrate
regrates92618403regrates
regressing1248143regressing
regression1146953regression
regressive1446493regressive
regressors1154253regressors
regrind938983regrind
regrinds1035533regrinds
regroom1077303regroom
regrooms1196013regrooms
regroup1095173regroup
regroups11104383regroups
regrow10309883regr_ow
regrown11237363regrown
regs55436573reg___s
regulus836523regulus
reheels10298253reheels
rehems113410983re_hems
rehires105016113rehire_s
reinless8139433reinless
reivers105117083reivers
reives95723043reive_s
rekeys13347693re_keys
relets64025673re_lets
reliefs10439433reliefs
reliers75519213reliers
relies65036423relie_s
remeets93712413remeets
remises93423483remises
remiss84216353re_miss
remorses10311993remorses
renders83821673renders
renest64529713re_nest
renests74014213re_nests
renews93811753re_news
rennets75212633rennets
renters74224813renters
rentes65431193rente_s
reopens939373reopens
reorders9198833reorders
repass84114703re_pass
repegs93311943re_pegs
repels84318763re_pels
reperks13298093reperks
reposes94021263reposes
repressed12610103repressed
represser1168953represser
represses11412143represses
repressor1166343repressor
reprise92715043reprise
reprises102615463reprises
reprocess1345933reprocess
repros84216003repr_os
request16311023request
requests1735743requests
reread71715433re_read
rereads81512293re_reads
reredos838633re_redos
rerent63832453re_rent
rerents73319423re_rents
rerigs74014793re_rigs
rerise64325633re_rise
rerises73525883re_rises
rerose63320843re_rose
reruns66413743re_runs
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483re_sees
resets65427613re_sets
resews94814173re_sews
reshes94124363reshe_s
resters74130403resters
restless82713163restless
retems83914573re_tems
retest64028453re_test
retests73813853re_tests
reties65436193retie_s
retirees84611653retirees
retirers84311533retirers
retires74726213retire_s
retread849003retread
retreads937823retreads
retreat7317533retreat
retreats8311413retreats
retries74129073retries
retrims93612373retrims
retrogress1143423retrogress
retros63820193retr_os
reuses66025523reuse_s
revels94220573re_vels
reverbs12368863reverbs
reverers113113153reverers
reveres103621343reveres
revers94529633re_vers
reverse103913743reverse
reverses112513513reverses
reverso10367693reverso
reversos11266713reversos
reverts104715043reverts
revest94623603re_vest
revests104413733re_vests
revets94022173re_vets
reviews1335533reviews
revises104220533revises
revues9813903revue_s
reweds104412303re_weds
rewets94617213re_wets
rewires104717113rewire_s
rewraps12136563rewraps
rexes124526953re_xe_s
rezeros1647453rezeros
ribgrass1143423ribgrass
ribless93410343ribless
riggers93613843riggers
rimless9369363rimless
roarers73812743roarers
rodless8310073rodless
rogers74517913rog_ers
rogues74617673rogue_s
ruggers94612313ruggers
rungless956733rungless
runless72810423runless
searest73322023searest
secrets9311773secrets
segues7412073segue_s
seres55448893se_re_s
serest64831613se_rest
sergers83815633sergers
serges74225973serge_s
sexless1467243sexless
stress66616673_stress
tearers75218233tearers
tearless848713tearless
tenrecs936033tenrecs
terrets72913583terrets
treeless839283treeless
tress55423163__tress
trigness968403trigness
tugless837383tugless
undress838893undress
veges94118873veg_e_s
vegies104314273vegie_s
vergers114412633vergers
verges104320183verge_s
verses94223763ve_rses
votress1035483votress
wearers104615903wearers
webless1237003webless
wetness10277723wetness
wigless11359673wigless
wiregrass1343423wiregrass
zebrass1834113zebrass

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.390458182.1
2DLD Change Limit1340274246.69020033.9
3Display Results4244240.1403028.6
 (SQL Overall)1786914247.22024749.4
 
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.