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

73 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
transparentizes267202(None) 
transparentize2562431transparentize_
transparentized2771721transparentized
transparencies1892722transparenci_es
transparences17103753transparen__ces
transparentness1781773transparentness
transparence1694104transparen__ce_
transparent1356714transparent____
transparently1862794transparent__ly
grandparents1662465grandparent___s
transferences1853685transferen__ces
transferential1762565transferenti_al
transiencies1456005trans__ienci_es
translucencies1862225translucenci_es
transparency1992925transparen___cy
transpirations1654725transpir_ations
transpontine1465135transp__ontine_
transportations1762905transportations
transvestites1663085trans__vestites
apprentices1753566__a__pprentices
fragmentizes2752316fra___gmentizes
grandparent1553376grandparent____
grandparental1771576grandparent__al
grandparenthood2314686grandparenthood
granularities1452986granular_iti_es
transactions1445886trans_a__ctions
transaminases1562986trans_amin_ases
transaminations17113426trans_aminations
transcendencies2071586transcendenci_es
transcribes1556176trans_cr___ibes
transcriptases1861726trans_criptases
transcriptions1863636trans_criptions
transections1446766trans___ections
transfections1854856trans__fections
transferees1456076transfere____es
transference1754316transferen__ce_
transformations2062826transformations
transformative2261926transformative_
transgenes1148406trans__gen___es
transgresses1354156trans_gre__sses
transgressions15102296trans_gressions
transgressive1762196trans_gressive_
transiences13128276trans__ien__ces
transients1078906trans__ient___s
transistorizes23293346trans_istorizes
transitivities1763516transitiviti_es
translates10411706transla___t__es
translations1258376transla___tions
translative1456706transla___tive_
translucences1793576translucen__ces
transmarine1357576transmar___ine_
transpierces1654686transp_ie__rces
transpiration1555426transpir_ati_on
transpires1249316transp_____ires
transplacental1881776transplacent__al
transplanted1574526transp_lant__ed
transplanter1474566transp_lant__er
transplanters1583066transp_lant_ers
transplanting1663966transp_lanti_ng
transplants1355816transp_lant___s
transportation1663296transportati_on
transported1455836transpor__t__ed
transporter1366066transpor__t__er
transporters1454816transpor__t_ers
transporting1555786transpor__ti_ng
transports1247576transpor__t___s
transpositions1663676transp_ositions
transuranics1463386trans_uran_i_cs
transvaluates16113256transvaluat__es
transvaluations1863026transvaluations
transvestisms1871866trans__vestisms
transvestite1553926trans__vestite_
traumatizes2254806tra_uma___tizes

Search took 8 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.390458182.1
2DLD Change Limit95024736.91013751.7
3Display Results73730.0601216.7
 (SQL Overall)178691737.36024278.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.