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 “transparentness” 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.

60 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
transparentness178177(None) 
transparences17103753transparen_ce_s
transparencies1892723transparencie_s
transparentizes2672023transparentizes
apparentness1652024__a_pparentness
transparence1694104transparen_ce__
transparent1356714transparent____
transparentize2562434transparent_ize
transparentized2771724transparentized
transparently1862794transparent__ly
grandparents1662465grandparent___s
transferences1853685transferen_ce_s
transparency1992925transpare__n_cy
transplanters1583065transp_lant_ers
transporters1454815transpor__t_ers
ancientness1353356__an__cientness
apartness1146056__a__par__tness
apparentnesses18121776__a_pparentnesses
fraudulentness188636fra_udulentness
grandparent1553376grandparent____
grandparental1771576grandparent__al
grandparenthood2314686grandparenthood
graspingness1652096gra_sp__ingness
instantness1154086__insta__ntness
parentless1244456_____parentless
plainspokenness2314696plainspoken_ness
preparedness1753886pr__epare_dness
presentness1345666pr_es___entness
spareness1139866____spare__ness
transaminases1562986trans_aminase_s
transcriptases1861726trans_criptases
transferees1456076transfere___e_s
transference1754316transferen_ce__
transferential1762566transferent_ial
transgenes1148406trans__ge__ne_s
transgress1144746trans_gr____ess
transgresses1354156trans_gre_sse_s
transiences13128276trans__ien_ce_s
transiencies1456006trans__iencie_s
transients1078906trans__ient___s
transitiveness1763276trans_itiveness
transitoriness1482666trans_itoriness
translates10411706transla___t_e_s
translucences1793576translucen_ce_s
translucencies1862226translucencie_s
transmarine1357576transmar__ine__
transpierces1654686transp_ie_rce_s
transpirations1654726transpir_ations
transpires1249316transpir____e_s
transplacental1881776transplacent__al
transplanted1574526transp_lant_e_d
transplanter1474566transp_lant_e_r
transplants1355816transp_lant___s
transponders1563356transp__on_ders
transpontine1465136transp__ontine__
transportations1762906transportations
transported1455836transpor__t_e_d
transporter1366066transpor__t_e_r
transports1247576transpor__t___s
transvaluates16113256transvaluat_e_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 Filter178691950240.360496363.9
2DLD Change Limit95024607.62312465.4
3Display Results60600.0461304.3
 (SQL Overall)178691608.02922255.7
 
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.