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

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

102 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
transcriptional199224(None) 
transcription1764072transcription__
transcriptions1863632transcription_s
inscriptional17173503__inscriptional
transitional1256223trans__i_tional
transpirational1773093transpirational
transactional1553424trans__actional
transductional1782504trans_ductional
translational1354744trans__lational
transnational1353914trans__national
transpositional17112334transpositional
ascription1444995__a_scription__
ascriptions1544985__a_scription_s
conscription1855335_conscription__
conscriptions1955005_conscription_s
inscription1544955__inscription__
inscriptions1654505__inscription_s
prescription18145345pr_escription__
prescriptions19135335pr_escription_s
proscription18124515pr_oscription__
proscriptions19114165pr_oscription_s
tractional1248045tra__c___tional
traditional1255385tra___di_tional
transcribing1754245transcri_bi_n_g
transcript1456475transcript_____
transcriptase1762075transcript__ase
transcriptases1861725transcript_ases
transcripts1554435transcript____s
transfusional1662415trans__fusional
transition1049705trans__i_tion__
transitionally1763125trans__i_tionally
transitions1148925trans__i_tion_s
transpiration1555425transpiration__
transpirations1654725transpiration_s
abstractional1753256__abstractional
antirational1278466__antir_ational
apparitional1652766__appari_tional
aspirational1454996__a_spirational
associational1552926__associational
attritional1154246__a_ttri_tional
conceptional1856906_con_c_eptional
conscripting1954026_conscripti_n_g
conservational1955336_conservational
consociational1853546_consociational
conspirational1853956_conspirational
constructional1854756_constructional
description1645376__description__
descriptions1755406__description_s
fractional1547126fra__c___tional
insertional1147456__inser__tional
inspirational1554406__inspirational
instructional1555086__instructional
nutritional1154776___nutri_tional
participational2171876partic_ipational
pronunciational1971626pronunciational
radiational1245946_ra___diational
recreational1455166_r__ecreational
redescription1862746redescription__
redescriptions1962786redescription_s
subscription1853126_subscription__
subscriptions1952826_subscription_s
transaction1346306trans__action__
transactions1445886trans__action_s
transamination16103796transamination__
transaminations17113426transamination_s
transcultural1562276transc_ult_ural
transduction1584456trans_duction__
transductions1664296trans_duction_s
transection1357376trans__ection__
transections1446766trans__ection_s
transeptal1254746trans__ept___al
transfection1765396trans_fection__
transfections1854856trans_fection_s
transferential1762566transferenti__al
transfixion2154206trans_fi_xion__
transfixions2253936trans_fi_xion_s
transformation1963076transformation__
transformations2062826transformation_s
transgression1462696transgression__
transgressions15102296transgression_s
transhipping2073226trans_hippi_n_g
transiting11410776trans__i_ti_n_g
translation1149486trans__lation__
translations1258366trans__lation_s
translocation1554686translocation__
translocations1664236translocation_s
transmission1454596trans_mission__
transmissions1554126trans_mission_s
transmittal1354006trans_mi_t__tal
transmitting1556096trans_mitti_n_g
transmutation1554406transmutation__
transmutations1653806transmutation_s
transpersonal1562536trans__personal
transportation1663296transportation__
transportations1762906transportation_s
transposition1554186transposition__
transpositions1663676transposition_s
transshipping2162026transshippi_n_g
transudation1355326trans_udation__
transudations1454836trans_udation_s
unscriptural1661326__unscript_ural
variational1444776_va___riational

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.1261418182.5
2DLD Change Limit950241028.31311430.8
3Display Results1021020.0761342.1
 (SQL Overall)1786911028.51520985.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.