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

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

121 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
comparatively255371(None) 
comparative20176212comparative__
comparatives21164852comparative_s
cooperatively2354192cooperatively
combatively2354643com__batively
comparativist2262553comparativist
competitively2562813competitively
imperatively2255573_imperatively
operatively1946273_o_peratively
preparatively2353643preparatively
capacitively2452114c_apacitively
collaboratively2571544collaboratively
commemoratively2671914commemoratively
comparability2454904comparability
comparably2154394compara___bly
comparatist1756324comparati__st
comparatists1853734comparati_sts
comparativeness2482924comparativeness
comparativists2361794comparativists
compatibly21134884comp__ati_bly
compressively25103384compressively
compulsively2452794comp_ulsively
connotatively21102684connotatively
conservatively25133874conservatively
contrastively2153864contrastively
cooperative1847054cooperative__
cooperatives1965554cooperative_s
corporately1854124corporat__ely
corporative1847154corporative__
correlatively2153214correlatively
cumulatively2253064cum_ulatively
curatively1845734c___uratively
declaratively2262184declaratively
imputatively2253274_imputatively
optatively1864644_o_p_tatively
adumbratively2462055adumbratively
amatively1745085____amatively
bipartitely1851665_bipar_titely
causatively1953765c__ausatively
coercively2053485co__er_cively
cognitively2053255co__gnitively
collectively22114625co_llectively
combative1847215com__bative__
combinative2055135combinative__
comfortingly2371875comfor_tingly
communicatively2982955communicatively
commutative2055845commutative__
commutativity2561975commutativity
compactible2153655compa_cti_ble
compactly2043825compa_ct___ly
comparable1845605compara___ble
comparator1665805comparat___or
comparators1785685comparat__ors
comparted16338425compar_t__e_d
comparting17188385compar_ti__ng
compartment1995085compar_t_ment
compatible18125575comp__ati_ble
compatibles19134145comp__atibles
compensative2154655compensative__
competitive2074765competitive__
completely1944555comp_let__ely
completive1946235comp_letive__
compositely2053665comp__ositely
comradely1783485com__ra__dely
conjunctively3062655conjunctively
connectively2255185co_nnectively
consecutively2383255consecutively
constructively2463845constructively
consumptively2562475consumptively
contemplatively2771895contemp_latively
copulative1747295co_pulative__
copulatives1844875co_pulative_s
corporativism2262375corporativism
correctively2254865co_rrectively
corrosively1953395co__rrosively
corruptively2253275co_rruptively
costively1746355co____stively
creatively1846675c___reatively
decoratively2154445_decoratively
disparately1763185disparat__ely
emulatively1954515_em_ulatively
explanatively2861825explanatively
exploratively2862425exploratively
federatively2253905_federatively
figuratively2253005_figuratively
formatively2254525fo__rmatively
hortatively2054055ho__rtatively
imitatively1954255_im_itatively
impartially1853815_impar_tially
impartibly1953835_impar_ti_bly
impassively2153575_impa_ssively
imperative1748565_imperative__
imperatives1846445_imperative_s
implicatively2552865_implicatively
iteratively1745915__iteratively
lucratively1984015__lucratively
narratively1754255__narratively
normatively1954635no__rmatively
operative141110555_o_perative__
operatives15117885_o_perative_s
oxidatively2553065_o_xidatively
partitively1954145___partitively
pejoratively2753675_pejoratively
postoperatively2591265postoperatively
preoperatively2462965preoperatively
preparative1846355preparative__
preparatives1954445preparative_s
putatively1845065___putatively
rebarbatively2362065_rebarbatively
reiteratively1953795reiteratively
remuneratively2262595remuneratively
reparative1548175_reparative__
rotatively1645405ro___tatively
ruminatively2053485rum_inatively
separately1553435_separat__ely
separative1546975_separative__
sportively1845025__spor_tively
superlatively2174055_superlatively
temperately1853205temperat__ely
vituperatively2561785vituperatively
vocatively2144475vo___catively

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 Filter1786911247900.423422437.4
2DLD Change Limit1247901219.17313604.1
3Display Results1211210.0761592.1
 (SQL Overall)1786911219.67218475.1
 
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.