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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
expressionist226404(None) 
expressionism2463361expressionism
expressionists2363091expressionists
expressionisms2562602expressionisms
expressionistic2671902expressionistic
expressions2086362expression_s_
impressionist1763982impressionist
repressionist1555322repressionist
expansionist2183433exp_ansionist
expression1946573expression___
expressional2164213expression_al
expressionless2361923expressionless
impressionism1963143impressionism
impressionists1862893impressionists
depressions1447314depression_s_
egressions1146204e_gression_s_
exclusionist2154094ex_clusionist
excursionist2173204ex_cursionist
expansionism2392684exp_ansionism
expansionists2292734exp_ansionists
expressing2046624expressi_n__g
expressiveness2664124expressiveness
expressivity2763054expressi_vity
expressos1844554express_o__s_
impressionisms2062364impressionisms
impressionistic2171804impressionistic
impressions1546824impression_s_
oppressions1545724oppression_s_
precisionist1656484__precisionist
repressions1348964repression_s_
secessionist1454754_secessionist
aggressions1353855aggression_s_
compressions1856405compression_s_
creationist1379235__creationist
depression1347505depression___
derepressions1653075derepression_s_
digressions1344745digression_s_
diversionist1654515_diversionist
egression1046195e_gression___
espressos1143975espress_o__s_
exclusionists2263335ex_clusionists
excretions1946625excre_tion_s_
excursionists2282725ex_cursionists
exhibitionist2572915exhibitionist
expansionisms2482475exp_ansionisms
expansionistic2591745exp_ansionistic
expansions1944155exp_ansion_s_
explosions19134665exp_losion_s_
expressages2152105express_ages_
expressers1944435express__ers_
expresses1837865express___es_
expressible2254055expressi__ble
expressive2285935express___ive
expressively2753955expressi_vely
expressivities2662515expressivities
expressman2152365expressman___
expressmen2153355expressmen___
expresso1743885express_o____
expressways2661115express_ways_
expulsions1943835exp_ulsion_s_
extensions1746135ex_tension_s_
extortionist1975315ex_tortionist
extrusions1745165extr_usion_s_
impression1447095impression___
ingressions1245495ingression_s_
operationist1457945_operationist
oppression1445885oppression___
percussionist17123365percussionist
perfusionist1753905_perfusionist
pessimist1345275__p_essi_mist
precisionists1754635__precisionists
prerevisionist19102525prerevisionist
pressings12269025__pressi_ngs_
prussianise1392545__prussianise
recreationist1555745recreationist
regressions1247105regression_s_
reimpressions1753205reimpression_s_
repression1249045repression___
reunionist1056175___reunionist
revisionist14146525___revisionist
secessionism1653445_secessionism
secessionists1463335_secessionists
suppressions1674045suppression_s_

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 Filter1786911247900.406440125.6
2DLD Change Limit124790837.97015657.5
3Display Results83830.0631317.5
 (SQL Overall)178691838.43921174.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.