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

43 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
transubstantial1771311transubstantial_
consubstantial1871814_consubstantial_
insubstantial1562274__insubstantial_
unsubstantial1572084__unsubstantial_
substantial13144835____substantial_
substantials14124025____substantials
unsubstantially2071855__unsubstantially
substantially1863366____substantially
substantiate1473806____substantiate
substantival17143206____substantival_
transferential1762566trans_ferential_
unsubstantiated1871846__unsubstantiated
circumstantial2072187_circumstantial_
substantiality1972767____substantiality
substantiated1673017____substantiated
substantiates1573407____substantiates
substantivally2262427____substantivally
substantive1654177____substanti_ve
substantively2163217____substantively
substantives1753767____substantives
tradescantia1561257tra__descanti__a
tradescantias166997tra__descantia_s
transatlantic1562027trans_atlanti__c
transcendental1771437transcendent_al_
transductant1573577transductant____
transductants1672547transductant___s
transfusional1662417transfusion__al_
transhistorical2092137transhistorical_
transmittal1354007trans_mit__t_al_
transmittals1453457trans_mit__t_als
transmutation1554407trans_muta_ti_on
transmutations1653807trans_muta_tions
transmutative1863037trans_muta_ti_ve
transplacental1881777transplacent_al_
transplantable1871337trans__plantable
transplanting1663967trans__planti_ng
transportation1663297transporta_ti_on
transportations1762907transporta_tions
transudation1355327transu__da_ti_on
transudations1454837transu__da_tions
transuranic1354107transu__ran_i__c
transuranics1463387transu__ran_i_cs
transuranium1462797transu__ran_i_um

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.346516448.0
2DLD Change Limit95024437.87312069.6
3Display Results43430.0331303.0
 (SQL Overall)178691438.25221654.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.