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 “depressives” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
depressives174517(None) 
depressive1646321depressive_
degressive1545142degressive_
depresses1259882depress__es
depressions1447312depressions
depressively21114612depressively
repressive1548112repressive_
defensives1743863de_fensives
degressively20174143degressively
depressants1453013depressants
depressed1357623depress__ed
depressible1654593depressible
depressing1448093depressi_ng
depression1347503depressi_on
depressors1354903depress_ors
depressurizes2562003depressurizes
deprives1438393depr___ives
detersives1444953de_tersives
digressive1554583digressive_
expressive2285933expressive_
impressive1746293impressive_
ingressives1554253ingressives
oppressive1745373oppressive_
recessives1545673re_cessives
regressive1446493regressive_
represses11412143repress__es
repressions1348963repressions
repressively20155183repressively
aggressive1554254aggressive_
caressive1445824_caressive_
cerussites1243184ce_russites
compressive2055304compressive_
cypresses1645854cypress__es
dearnesses1139584dearness__es
deceives1437904de_ce__ives
decreases1237224decreas__es
decretive1547494decre_tive_
deepnesses1366674deepness__es
defectives1945684de_fectives
defensive1644994de_fensive_
degreases1146154degreas__es
depletive1545624deple_tive_
depraves1436874depr___aves
deprecates1547284depre_cates
depreciates1664624depreciates
depredates1445504depre_dates
depress10239874depre_s___s
depressant1354874depress_ant
depressingly1953614depressingly
depressor1265174depress__or
depressurize2462334depressurize_
depressurized2661884depressurized
deprive1338304depr___ive_
deprived1546464depr___ived
depriver1446294depr___iver
deprivers1545214depr___ivers
depsides1238504dep___sides
derepresses1444774derepress__es
derepressions1653074derepressions
derisive1247504de_r_isive_
derives114017814de_r___ives
detectives1645784de_tectives
detersive1346344de_tersive_
digestives1545214d_igestives
digresses1137864digress__es
digressions1344744digressions
digressively20143474digressively
directives1655834d_irectives
dressages1144154d__ressages
dresses83716174d__ress__es
dressier956864d__ressi_er
dressiest1036824d__ressi_est
dressiness1145544d__ressiness
dressings11265374d__ressings
duresses939174d_uress__es
egresses949444_egress__es
egressions1146204_egressions
empresses1348164empress__es
excessive2145044_excessive_
expressages2152104expressages
expresses1837864express__es
expressions2086364expressions
expressively2753954expressively
heiresses1236964heiress__es
heresies11312694he_re_si_es
impresses1338214impress__es
impressions1546824impressions
impressively2254394impressively
impressures1552954impressures
inexpressive2462964inexpressive_
ingressive1455264ingressive_
leprosies1146804lepr_osi_es
obsessives1552954_obsessives
oppresses1346874oppress__es
oppressions1545724oppressions
oppressively2253534oppressively
passives13228824__p_assives
peeresses1138474peeress__es
possessives1583154possessives
prelives13310384__pre_lives
preserves14109074__preserves
presides11414914__pre_sides
preslices1338214__preslices
presolves1456534__presolves
presses93523154__press__es
pressings12269024__pressings
pressures1149064__pressures
prestiges12310594__prestiges
prissies101712004__prissi_es
progressives1854294progressives
prossies101515224__prossi_es
recessive1447264re_cessive_
redresses10410294redress__es
regresses10310464regress__es
regressions1247104regressions
regressively19124754regressively
repressed12610104repress__ed
represser1168954repress__er
repressers1256884repress_ers
repressible1555104repressible
repressing13310394repressi_ng
repression1249044repressi_on
repressiveness1964814repressiveness
repressors1265774repress_ors
repressurizes2462264repressurizes
seeresses939054seeress__es
suppressive1853874suppressive_
unexpressive2462734unexpressive_

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191288.60617292.5
3Display Results1281280.0801600.0
 (SQL Overall)1786911289.10919617.0
 
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.