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

52 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
transcending165383(None) 
transcendent1563712transcendent
ascending1336283__a_scending
reascending1544273_reascending
transcend1246443transcend___
transcended1554503transcend_ed
transcendence1862553transcendence
transcendency2162063transcendency
transcends1345473transcend__s
transcribing1754243transcribing
transecting1447373trans_ecting
transfecting1855163transfecting
transferring1654333transferring
transuding1246003trans__uding
absconding1642994__absconding
crescendoing1851094cr_escendoing
descending1546114__descending
grandstanding1761494grandstanding
prescinding1744854pr_escinding
redescending1752574redescending
rescinding1436724_r_escinding
resending112313364_r_es_ending
scending122610584____scending
trancing112812024tran_c___ing
transacting1446524trans_acting
transcendences1962214transcendences
transcendental1771434transcendental
transcendently2071414transcendently
transducing1554354trans_ducing
transferrin1454774transferrin_
transferrins1554584transferrins
transfixing2254804trans_fixing
transforming1854644transforming
transfusing1554674trans_fusing
transgender1354194transgend_er
transgenic1355774transgen_i_c
transgressing1562694transgressing
transhipping2073224transhipping
transiencies1456004transiencies
transiting11410774trans__iting
translating1249444trans_lating
transmitting1556094transmitting
transmuting1456224trans_muting
transpiercing1862844transpiercing
transpiring1446874trans_piring
transplanting1663964transplanting
transpontine1465134transpontine
transporting1555784transporting
transposing1455454trans_posing
transshaping1863494transshaping
transvaluing1653424transvaluing
trending103012834tr____ending

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.393454684.5
2DLD Change Limit124790526.65318757.0
3Display Results52520.0331575.8
 (SQL Overall)178691527.07925242.4
 
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.