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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
ascending133628(None) 
scending122610581_scending
absconding1642992absconding
acceding1446092acce_ding
accenting1487822accenting
amending12308912a_mending
appending1536282appending
ascendant1245162ascendant
ascendent1245942ascendent
assenting1038162assenting
attending11136372attending
descending1546112descending
reascending1544272reascending
scenting113212812_scenting
sending94221372_s_ending
shending132511252_shending
spending122712432_spending
abounding1335193abounding
abscessing1543313abscessing
absenting1236993absenting
accepting1695803accepting
accessing1445833accessing
according1545273according
agenting1039383a_genting
aliening91510893alien_ing
arcading1239763arc_ading
ascend9429733ascend___
ascendance15113963ascendance
ascendancy18122953ascendancy
ascendants1343613ascendants
ascended1246513ascend_ed
ascendence1594663ascendence
ascendency18123423ascendency
ascendents1344243ascendents
ascender1136733ascend_er
ascenders1235683ascenders
ascendible1552613ascendible
ascends10388203ascend__s
ascension1144703ascension
ascensions1244613ascensions
ascensive1444183ascensive
ascribing1444953ascribing
aspersing1237603aspersing
asserting1038663asserting
assessing1045173assessing
astonying1345233astonying
astounding1244153astounding
attendings12143523attendings
avenging1345863a_venging
bartending1444913bartending
bending114420893__bending
blending12249963_blending
cascading1545673casc_ading
ceding104014803__ce_ding
censing104215263__censing
defending15298353defending
depending14208783depending
dispending1547923dispending
distending1348333distending
emending12298893_emending
ending83220253___ending
exceeding2043493exceeding
expending2045933expending
exscinding2142333exscinding
extending1835853extending
fastening13268603fasten_ing
fending123717603__fending
friending1495553friending
gasconading1652013gasconading
hastening13259483hasten_ing
impending1535933impending
incensing1297663incensing
incenting12912063incenting
intending1139983intending
islanding1135623islanding
lending94118533__lending
licencing1443853licencing
licensing1244753licensing
mending114018683__mending
missending1446493missending
mistending1447953mistending
nonending1138003nonending
offending1744093offending
pending114119773__pending
receding122713763rece_ding
relending112412023relending
remending132311313remending
rending93924263__rending
rescinding1436723rescinding
resending112313363resending
sanding93520603_s_anding
scalding12339393_scalding
scanning113310773_scanning
scanting113914763_scanting
scolding12278913_scolding
sconcing1338263_sconcing
screeding1336323_screeding
scudding1335673_scudding
seceding12288563_seceding
seconding1337613seconding
seeding93719483_s_eeding
sensing84116953_s_ensing
shedding14278113_shedding
sledding11248503_sledding
snedding11246953_snedding
sounding102712873_sounding
speeding122810933_speeding
standing103413633_standing
steading103613593_steading
sueding92613753_sue_ding
suspending1445033suspending
tending94419163__tending
transcending1653833transcending
trending103012833_trending
unbending1337463unbending
unending10239943_unending
upending12258133_upending
upsending1334903upsending
vending124015263__vending
wending123816843__wending

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411207.57619620.0
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.04522211.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.