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

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

51 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
transpierces165468(None) 
transpierce1554851transpierce_
transpierced1753511transpierced
transiences13128272trans_iences
transpires1249312transpi_r_es
transferees1456073trans_ferees
transience12128433trans_ience_
transiencies1456003trans_iencies
transparences17103753transparences
transpiercing1862843transpiercing
transpire1148863transpi_r_e_
transpired1346763transpi_r_ed
transverses1445903trans_verses
brassieres12274384bra_ssier_es
crosspieces1752444crosspie_ces
grandnieces1552024grandnie_ces
shankpieces2251214shankpie_ces
stringpieces1751544stringpie_ces
tailpieces1452064t_ailpie_ces
transduces1345604trans__duces
transects1157824trans__e_cts
transfects1545724trans_fe_cts
transferals1455214trans_ferals
transferase1455454trans_ferase
transferases1555084trans_ferases
transferee1347254trans_fer_ee
transferences1853684transferences
transferors1484494trans_ferors
transferred1554604trans_ferred
transferrer1454694trans_ferrer
transferrers15133664trans_ferrers
transfers1238054trans_fer__s
transfigures1653254transfigures
transfixes2046474transfi__xes
transgenes1148404trans_ge_nes
transgresses1354154transgresses
transiency15135424trans_ienc_y
transients1078904trans_ie_nts
transliterates1462574transliterates
translucences1793574translucences
transmigrates1663844transmigrates
transparence1694104transparence_
transparencies1892724transparencies
transpicuous1662194transpicuous
transpiring1446874transpi_ring
transported1455834transp_orted
transporter1366064transp_orter
transporters1454814transp_orters
transports1247574transp_or_ts
transposes1247444transp__oses
transverse1345904trans_verse_

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 Filter1786911247900.390458182.1
2DLD Change Limit124790517.31317064.1
3Display Results51510.0301700.0
 (SQL Overall)178691517.73323107.6
 
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.