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

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

76 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
transparentizes2672021transparentizes_
transparentize2562432transparentize__
transparentized2771722transparentize_d
transparencies1892723transparenci_es_
transparentness1781773transparent_ness
transparences17103754transparen__ces_
transparence1694105transparen__ce__
transparent1356715transparent_____
transparently1862795transparent___ly
grandparents1662466grandparent___s_
transferences1853686transferen__ces_
transferential1762566transferenti__al
transiencies1456006trans__ienci_es_
translucencies1862226translucenci_es_
transparency1992926transparen____cy
transpirations1654726transpir_ations_
transpontine1465136transp__ontine__
transportations1762906transportations_
transvestites1663086trans__vestites_
apparentness1652027__a_pparent_ness
apprentices1753567__a__pprentices_
fragmentizes2752317fra___gmentizes_
grandparent1553377grandparent_____
grandparental1771577grandparent___al
grandparenthood2314687grandparent_hood
granularities1452987granular_iti_es_
transactions1445887trans_a__ctions_
transaminases1562987trans_amin_ases_
transaminations17113427trans_aminations_
transcendencies2071587transcendenci_es_
transcribes1556177trans_cr___ibes_
transcriptases1861727trans_criptases_
transcriptions1863637trans_criptions_
transections1446767trans___ections_
transfections1854857trans__fections_
transferees1456077transfere____es_
transference1754317transferen__ce__
transformations2062827transformations_
transformative2261927transformative__
transgenes1148407trans__gen___es_
transgresses1354157trans_gre__sses_
transgressions15102297trans_gressions_
transgressive1762197trans_gressive__
transiences13128277trans__ien__ces_
transients1078907trans__ient___s_
transistorizes23293347trans_istorizes_
transitivities1763517transitiviti_es_
translates10411707transla___t__es_
translations1258377transla___tions_
translative1456707transla___tive__
translucences1793577translucen__ces_
transmarine1357577transmar___ine__
transpierces1654687transp_ie__rces_
transpiration1555427transpir_ati__on
transpirational1773107transpir_ational
transpires1249317transp_____ires_
transplacental1881777transplacent___al
transplanted1574527transp_lant__e_d
transplanter1474567transp_lant__e_r
transplanters1583067transp_lant__ers
transplanting1663967transp_lanti__ng
transplants1355817transp_lant___s_
transportation1663297transportati__on
transported1455837transpor__t__e_d
transporter1366067transpor__t__e_r
transporters1454817transpor__t__ers
transporting1555787transpor__ti__ng
transports1247577transpor__t___s_
transpositions1663677transp_ositions_
transuranics1463387trans_uran_i_cs_
transvaluates16113257transvaluat__es_
transvaluations1863027transvaluations_
transvestism1762957trans__vesti__sm
transvestisms1871867trans__vestisms_
transvestite1553927trans__vestite__
traumatizes2254807tra_uma___tizes_

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.343520965.0
2DLD Change Limit95024768.56311097.0
3Display Results76760.0601266.7
 (SQL Overall)178691768.96619929.8
 
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.