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

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

47 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
transparently186279(None) 
transparency1992922transparen_cy
transparent1356712transparent__
transiently1455773trans__iently
translucently1882303translucently
transparence1694103transparen_ce
transparences17103753transparences
transparentize2562433transparentize
apparently1753794__a_pparently
grandparent1553374grandparent__
grandparental1771574grandparental
grandparents1662464grandparent_s
inapparently1962294ina_pparently
transcendently2071414transcendently
transparencies1892724transparencies
transparentized2771724transparentized
transparentizes2672024transparentizes
transparentness1781774transparentness
transplacental1881774transplacental
intransigently1882345intrans_igently
rampantly1643495_ra_mpa__ntly
transference1754315transferen_ce
transferences1853685transferences
transferential1762565transferential
transiency15135425trans__ien_cy
transient9713215trans__ient__
transients1078905trans__ient_s
translucency19132795translucen_cy
translucent1355435translucent__
transmarine1357575transmarin__e
transpersonal1562535transpersonal_
transpire1148865transpire____
transpired1346765transpire___d
transpires1249315transpire___s
transpiring1446875transpirin__g
transplant1257525transp_lant__
transplanted1574525transp_lanted
transplanter1474565transp_lanter
transplants1355815transp_lant_s
transport1149755transpor__t__
transportable1762645transportable
transported1455835transpor__ted
transporter1366065transpor__ter
transports1247575transpor__t_s
transversely1862515transver_sely
trenchantly1952015trencha__ntly
unsparingly1753535__unsparingly

Search took 10 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.406440125.6
2DLD Change Limit124790479.47013177.4
3Display Results47470.0301566.7
 (SQL Overall)178691479.90618038.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.