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

103 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
extending183585(None) 
expending2045931expending
attending11136372attending
coextending2252912coextending
emending12298892e_mending
exceeding2043492exceeding
expanding2044792expanding
expensing1946002expensing
extruding1844332extruding
intending1139982intending
tending94419162__tending
amending12308913_amending
appending1536283appending
ascending1336283ascending
attendings12143523attendings
bartending1444913bartending
bending114420893__bending
besteading1446033besteading
blending12249963_blending
contending1449123contending
defending15298353defending
depending14208783depending
descending1546113descending
distending1348333distending
embedding1643313embedding
ending83220253___ending
entering91920053ente_ring
enwinding1444933enwinding
esteeming1244703esteeming
evening11310223e_ven_ing
excelling1935643excelling
excepting2145873excepting
excessing1945713excessing
exciding1935923ex_ciding
excluding2043463excluding
exerting162211153ex_erting
expecting2146693expecting
expelling1936133expelling
experting1938053experting
exploding2044933exploding
expounding2142693expounding
expunging2042833expunging
exscinding2142333exscinding
exsecting1935933exsecting
exserting1736663exserting
extend14267523extend___
extended17135833extend_ed
extender16146333extend_er
extenders17125673extenders
extendible2052953extendible
extends15227113extend__s
extensile1645033extensile
extension1646293extension
extensions1746133extensions
extensity1944723extensity
extensive1945723extensive
extenuating1943573extenuating
extermine1848283extermine
extincting2044003extincting
extolling1744623extolling
extorting1746763extorting
exuding16347443ex__uding
fending123717603__fending
friending1495553friending
impending1535933impending
latening9711493laten_ing
lending94118533__lending
mending114018683__mending
mistending1447953mistending
neatening1038353neaten_ing
nonending1138003nonending
obtunding1354243obtunding
offending1744093offending
patenting1248943patenting
pending114119773__pending
perpending1646683perpending
portending1446193portending
pretending1438613pretending
protending1446813protending
reblending1455813reblending
relending112412023relending
remending132311313remending
rending93924263__rending
resending112313363resending
scending122610583_scending
sending94221373__sending
sentencing1345403sentencing
shending132511253_shending
spending122712433_spending
standing103413633_standing
steading103613593_steading
subtending1445103subtending
tedding103210883__tedding
tensing84616653__tensing
tenting84621153__tenting
trending103012833_trending
unbending1337463unbending
unending10239943_unending
upending12258133_upending
upsending1334903upsending
vending124015263__vending
weekending1942233weekending
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.420425454.8
2DLD Change Limit1486411038.31317880.5
3Display Results1031030.0931107.5
 (SQL Overall)1786911038.82620246.0
 
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.