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

144 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
expressions208636(None) 
expression1946571expression_
depressions1447312depressions
egressions1146202e_gressions
expressing2046622expressi_ng
expressional2164212expressional
expressionism2463362expressionism
expressionist2264042expressionist
expressos1844552express_o_s
impressions1546822impressions
oppressions1545722oppressions
repressions1348962repressions
aggressions1353853aggressions
compressions1856403compressions
depression1347503depression_
derepressions1653073derepressions
digressions1344743digressions
egression1046193e_gression_
espressos1143973espress_o_s
excretions1946623excre_tions
expansions1944153exp_ansions
explosions19134663exp_losions
expressages2152103expressages
expressers1944433express_ers
expresses1837863express__es
expressible2254053expressible
expressionisms2562603expressionisms
expressionists2363093expressionists
expressionless2361923expressionless
expressive2285933expressi_ve
expressman2152363expressman_
expressmen2153353expressmen_
expresso1743883express_o__
expressways2661113expressways
expulsions1943833exp_ulsions
extensions1746133ex_tensions
extrusions1745163extr_usions
impression1447093impression_
ingressions1245493ingressions
oppression1445883oppression_
regressions1247103regressions
reimpressions1753203reimpressions
repression1249043repression_
suppressions1674043suppressions
accessions1445254_accessions
aggression1253944aggression_
aspersions1246104asp_ersions
cessions1039854___cessions
compression1756564compression_
concessions15128104concessions
confessions16136634confessions
decompressions21102664decompressions
depressing1448094depressi_ng
depressives1745174depressives
depressors1354904depress_ors
derepression1593134derepression_
digression1244664digression_
egestions1046704e__gestions
egressing1146854e_gressi_ng
emersions1147284e__mersions
emissions1146924e__missions
empresses1348164empress__es
erasions8310984e__r_asions
erections112515214e__rections
erepsins1037444e__repsi_ns
erosions8310344e__r_osions
espresso1043194espress_o__
eversions1238364e__versions
excelsiors1952034ex_celsiors
exceptions2146864ex_ceptions
excerptions2244984excerptions
excessing1945714ex_cessi_ng
excisions1846384ex__cisions
exclusions1945014ex_clusions
excretion1846714excre_tion_
excursions1944324ex_cursions
exertions1639764ex__ertions
exhaustions2153124exhaustions
expansion1844444exp_ansion_
expeditions2144634expeditions
expensing1946004exp_ensi_ng
expiations1959664exp_iations
expirations2069584expirations
explosion18115214exp_losion_
exportations2146654exportations
expositions2046844expositions
express1637494expre_s___s
expressage2052394express_age
expressed1946214express__ed
expresser1845734express__er
expressionistic2671904expressionistic
expressively2753954expressively
expressiveness2664124expressiveness
expressivity2763054expressivity
expressly2143474express__ly
expressway2551424express_way
expulsion1843894exp_ulsion_
expunctions2243634expunctions
expurgations2274124expurgations
exsections1947634ex_sections
exsertions1746744ex_sertions
extension1646294ex_tension_
extractions2077744extractions
extraversions2382334extraversions
extroversions2382154extroversions
extrusion1645254extr_usion_
impassions1444844imp_assions
imprecisions1853924imprecisions
impressing1547544impressi_ng
impressionism1963144impressionism
impressionist1763984impressionist
ingression1145514ingression_
obsessions1244274_obsessions
oppressing1545974oppressi_ng
oppressors1463844oppress_ors
passions10310584__p_assions
pensions10311694__p_ensions
possessions1265024possessions
preassigns1343554__preassigns
precessions1548554precessions
precisions1449374__precisions
prelusions1256374__prelusions
pressing112516444__pressi_ng
pressings12269024__pressings
pressors103212694__press_ors
pressruns1144294__pressruns
preunions1146484__preunions
previsions1547734__previsions
processions1548154processions
professions1646634professions
progressions1555554progressions
reaccessions1652764reaccessions
recessions1248934_recessions
reexpressing2263084reexpressi_ng
regression1146954regression_
reimpression1653264reimpression_
repressing13310394repressi_ng
repressionist1555324repressionist
repressors1265774repress_ors
secessions1246464_secessions
sessions839724___sessions
successions1553974successions
supersessions1454774supersessions
suppression1564334suppression_

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 Limit1488191448.84316829.0
3Display Results1441440.0761894.7
 (SQL Overall)1786911449.34219127.7
 
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.