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

83 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
transgressing156269(None) 
transgression1462692transgression
transgressions15102292transgressions
transgressive1762192transgressive
transgress1144743transgress___
transgressed1452953transgress_ed
transgresses1354153transgress_es
transgressor1361653transgress_or
transgressors1461483transgressors
aggressing1344184__a_ggressing
congressing1545604_con_gressing
prestressing1583974pr_estressing
progressing1545774pr__ogressing
redigressing1552924_redigressing
regressing1248144_r__egressing
restressing1266044_r_estressing
transcending1653834trans_cending
transcribing1754244transcr_ibing
transecting1447374trans__ecting
transfecting1855164trans_fecting
transferring1654334trans_ferring
transfusing1554674trans__fusing
transpiercing1862844transpiercing
transposing1455454trans__posing
abscessing1543325__abs_cessing
addressing1343135__a_ddressing
assessing1045175__a_s_sessing
caressing1238805_ca___ressing
crisscrossing186755crisscrossing
digressing1345795___digressing
distressing1385975__distressing
egressing1146855____egressing
engrossing12124655__en_grossing
gangrening1342775_gan_gre_ning
hairdressing1751735_hairdressing
harnessing1443905harn___essing
misguessing1542835__misguessing
overstressing1753715overstressing
readdressing1552795_readdressing
reassessing1243995_reas_sessing
redressing1247825_r__edressing
reexpressing2263085_reexpressing
repressing13310395_r__epressing
retrogressing1553165retrogressing
strangering1345195stran_g_e_ring
stressing1038335____stressing
teargassing1352005tea_rg_assing
topdressing1552665t__opdressing
transacting1446525trans__acting
transducing1554355trans__ducing
transferrin1454775trans_ferrin_
transferrins1554585trans_ferrins
transfiguring1862685transfiguring
transfixing2254805trans__fixing
transforming1854645trans_forming
transgene1047955transg_e___ne
transgenic1355775transg_e_ni_c
transhipping2073225trans_hipping
transiting11410775trans___iting
translating1249445trans__lating
translocating1654285translocating
transmigrating1863085transmigr_ating
transmission1454595trans_mission
transmissions1554125trans_missions
transmissive1763445trans_missive
transmitting1556095trans_mitting
transmogrifying257945transmogrifying
transmuting1456225trans__muting
transpiring1446875trans__piring
transplanting1663965transplanting
transporting1555785trans_porting
transshaping1863495trans_shaping
transshipping2162025transshipping
transuding1246005trans___uding
transvaluing1653425trans_valuing
transvestism1762955trans_vestism
transvestite1553925trans_vestite
trapesing1247265tra___pe_sing
trapnesting1453155tra__pnesting
traversing1444805tra___versing
trespassing1442315tr_es_passing
undressing1246535__un_dressing
waitressing1552495_wa_itressing

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 Filter1786911247900.406440125.6
2DLD Change Limit124790838.40614845.3
3Display Results83830.0631317.5
 (SQL Overall)178691838.87520134.2
 
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.