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 “subscriptions” 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
subscriptions195282(None) 
subscription1853121subscription_
ascriptions1544983__ascriptions
conscriptions1955003conscriptions
descriptions1755403_descriptions
inscriptions1654503_inscriptions
prescriptions19135333prescriptions
proscriptions19114163proscriptions
subreptions1545883sub__reptions
subscripts1653233subscript___s
subsumptions1852613subs_umptions
superscriptions2163343superscriptions
absorptions1544594_absor_ptions
ascription1444994__ascription_
conscription1855334conscription_
description1645374_description_
inscription1544954_inscription_
misdescriptions22111964misdescriptions
prescription18145344prescription_
proscription18124514proscription_
redescriptions1962784redescriptions
subauditions1552584subaudi_tions
suberizations2468774sub_erizations
subirrigations17102404subirrigations
submunitions1672934submuni_tions
subornations1446144sub_ornations
subreption1445824sub__reption_
subscribing1853244subscri_bi_ng
subscript1544664subscript____
subsections1597104subs__ections
subsidizations2653734subsidizations
substations1348244subs__tations
substitutions1553284substitutions
subsumption1752624subs_umption_
subtractions1645374sub_tractions
superscription2063634superscription_
suspirations1445854su_spirations
susurrations1244334su_surrations
transcriptions1863634transcriptions
abruptions1443845_ab__ruptions
abscissions1552405_absc_issions
absorption1444885_absor_ption_
abstractions1645785_abstractions
adsorptions1444165_adsor_ptions
conscripting1954025conscripti_ng
constrictions1747785constrictions
coscripting1843905_coscripti_ng
decryptions1943615__decryptions
descriptors1652755_descript_ors
desorptions1445995_desor_ptions
discretions1447225_discr_etions
disruptions14125685_dis_ruptions
encryptions1852965__encryptions
fasciations1646265_fasc_iations
inscriptional17173515_inscriptional
lubrications1645735lub__rications
lustrations1147625lu_str_ations
miscaptions1744185_misc_aptions
miscreations1647065_miscreations
misdescription21112125misdescription_
nutritions1066515nu__tri_tions
obscurations1644025_obscurations
observations1785015_observations
obstructions16155525_obstructions
redescription1862745redescription_
resorptions1347235_resor_ptions
restrictions1449285_restrictions
rubrications1646265rub__rications
scripting1437475___scripti_ng
secretions12117855s__ecr_etions
seriations10316685___seriations
sorptions1137125___sor_ptions
speciations1548485s_pec_iations
striations10312795___striations
strictions1249145___strictions
subaudition1452695subaudi_tion_
subcritical1753435sub_cri_tical
subdecisions1752865subdeci_sions
subdivisions1862215subdivi_sions
subductions1644505sub__ductions
suberization2359245sub_erization_
subirrigation1652645subirrigation_
subjections2296355sub__jections
subjugations2253415sub_jugations
subjunctions2353465sub_junctions
sublations12410115sub___lations
sublimations1646085sub_limations
subluxations2143385sub_luxations
submersions1544475submer__sions
submissions1553695sub__missions
submunition1563115submuni_tion_
subordinations1754005subordinations
subornation1346495sub_ornation_
subregions1344425sub__r_egions
subrogations1545455sub_rogations
subsaturations1672575subsaturations
subscribers1752615subscri__bers
subscribes1644875subscr___ibes
subsection1496785subs__ection_
subsidization2553985subsidization_
subsisting1345535subs__isti_ng
subsocieties1652705subsocieti_es
substantiations1772795substantiations
substation1248995subs__tation_
substitution1453325substitution_
subtilizations2556065subtilizations
subtraction1545625sub_traction_
subvarieties1751995subvarieti_es
subventions1674845sub__ventions
subversions1654495subver__sions
suctions103012905su__c___tions
sulcations1289585su_lc__ations
summarizations2754855summarizations
supernations14410875su_pernations
suppositions1654895supposi_tions
suppurations1645205suppur_ations
suspicions1453765su_s_pi_cions
suspiration1346545su_spiration_
susurration1144795su_surration_
transcription1764075transcription_
usurpations1343475_u_surpations

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.393454684.5
2DLD Change Limit1247901217.96615665.3
3Display Results1211210.0801512.5
 (SQL Overall)1786911218.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.