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

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

91 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
radioactivities2113201(None) 
bioactivities2063303__bioactivities
radioactivity2271623radioactivit__y
retroactivities2062553retroactivities
vasoactivities2272373va_soactivities
adaptivities1853124_ad__aptivities
directivities1954194__directivities
inactivities1755594___inactivities
radioactive1753314radioactiv___e_
reactivities1756174r___eactivities
refractivities22103974r_efractivities
underactivities2162744underactivities
absorptivities2161895_absorptivities
activities1548905_____activities
additivities1753115_ad__ditivities
affectivities2453515_a_ffectivities
hyperactivities2873775hyperactivities
overactivities2274465_overactivities
productivities2282595prod__uctivities
radioactively22112195radioactiv__ely
reflectivities2263625r_eflectivities
relativities1555775r__ela_tivities
resistivities1694495resi__stivities
retractilities1674085r_etractilities
superactivities2283775superactivities
acclivities1844376_a___cclivities
admirabilities1956056_admira_bilities
adorabilities1647806_ad_orabilities
advisabilities2055576_advisa_bilities
amiabilities16109896_ami_a_bilities
amicabilities19197916_amica_bilities
anelasticities16163026_anelasticities
aromaticities1754716_a_romaticities
associativities2091506_associativities
automaticities1862966_automaticities
bioactivity2152576__bioactivit__y
captivities1845946____captivities
collectivities2174166_collectivities
conductivities2283566_conductivities
connectivities2164476_connectivities
contractilities1983196contractilities
creativities1755786__crea_tivities
creditabilities2065296credita_bilities
deactivates1744396__d_eactivat_es
declivities1745726__d__eclivities
destructivities2162506destructivities
diffusivities2361246__diffusivities
disabilities15411146__disa_bilities
disutilities1355156__di_sutilities
docilities1349006__d_o_c_ilities
ductilities1446206__d__uctilities
effectivities2453856__effectivities
emotivities1645756__emo__tivities
facticities1846876____facticities
fatigabilities2065386fatiga_bilities
habitabilities21125336habita_bilities
inactivates1645046___inactivat_es
indocilities1555646ind_o_c_ilities
infectivities2155126__infectivities
mailabilities1767716ma_ila_bilities
mediocrities1752826medio_c__rities
motivities1547696___mo__tivities
nativities1348436____na_tivities
navigabilities2064966naviga_bilities
negativities1654876__nega_tivities
objectivities2754316__objectivities
perfectivities2483876_perfectivities
positivities1755456___positivities
primitivities2073566_pri_mitivities
proclivities1964686__pro_clivities
radiative1348176radi_a_tiv___e_
radioecologies1882706radioec_ologies
radiometries1575886radiomet___ries
rancidities1445596ra___nc_idities
rapacities1446546ra__pac___ities
ratiocinates1452806ratio_c_inat_es
rationalities1357286ratio__nalities
reactivates1645616r___eactivat_es
readabilities1649316read__a_bilities
receptivities2053906r__eceptivities
reliabilities15410466reli_a_bilities
retentivities1654546r__etentivities
retroactivity2162786retroactivit__y
roadabilities1647816road__a_bilities
selectivities1854876__selectivities
subjectivities2863416_subjectivities
tactilities1347676____tactilities
trainabilities1646616tra_ina_bilities
transitivities1763516tra__nsitivities
variabilities1848646vari_a_bilities
vasoactivity2361636va_soactivit__y

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 Filter178691950240.360496363.9
2DLD Change Limit95024917.94011967.8
3Display Results91910.0601516.7
 (SQL Overall)178691918.36021374.5
 
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.