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

114 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
attending1113637(None) 
attendings12143521attendings
amending12308912a_mending
appending1536282appending
ascending1336282ascending
attendant1045472attendant
attesting1036382attesting
attuning935902attun_ing
bartending1444912bartending
battening12268862batten_ing
coattending1543542coattending
extending1835852extending
fattening13287832fatten_ing
intending1139982intending
rattening10288762ratten_ing
tending94419162__tending
trending103012832_trending
abounding1335193abounding
absenting1236993absenting
acceding1446093acce_ding
accenting1487833accenting
agenting1039383a_genting
aliening91510893alien_ing
altering91917123alte_ring
anteceding1443953anteceding
anteing8312813ante__ing
assenting1038163assenting
astonying1345233astonying
astounding1244153astounding
atheling1249203athe_ling
atoning83514873a_ton_ing
attaching1545433attaching
attacking1635323attacking
attaining1047223attaining
attainting1144783attainting
attempting1542923attempting
attend7258973attend___
attendance1383363attendance
attendants1143683attendants
attended1035763attend_ed
attendee946403attend_ee
attendees1044053attendees
attender935913attend_er
attenders1045283attenders
attends8257593attend__s
attention946103attention
attentions1045993attentions
attentive1245853attentive
attenuating1253103attenuating
attiring939483att_iring
attorning1045503attorning
attriting1048693attriting
avenging1345863a_venging
battering122715153batte_ring
bending114420893__bending
blending12249963_blending
contending1449123contending
defending15298353defending
depending14208783depending
distending1348333distending
emending12298893_emending
ending83220253___ending
expending2045933expending
fastening13268603fasten_ing
fending123717603__fending
flattening14115103flatten_ing
friending1495553friending
goaltending1451993goaltending
hastening13259483hasten_ing
impending1535933impending
kittening1434593kitten_ing
latening9711493laten_ing
lending94118533__lending
mattering122314063matte_ring
mending114018683__mending
mistending1447953mistending
nattering102212223natte_ring
nonending1138003nonending
obtunding1354243obtunding
offending1744093offending
patenting1248953patenting
pattering122314433patte_ring
patterning1346073patterning
pending114119773__pending
portending1446193portending
pretending1438613pretending
protending1446813protending
relending112412023relending
remending132311313remending
rending93924263__rending
resending112313363resending
scending122610583_scending
sending94221373__sending
shending132511253_shending
spending122712433_spending
standing103413633_standing
steading103613593_steading
stounding1136233stounding
stranding1149653stranding
subtending1445103subtending
tattering102212333tatte_ring
tautening1035843tauten_ing
tedding103210883__tedding
tensing84616653__tensing
tenting84621153__tenting
treading103515333_treading
unbending1337463unbending
unending10239943_unending
upending12258133_upending
upsending1334903upsending
uttering91613083utte_ring
vending124015263__vending
wending123816843__wending
yattering132410453yatte_ring

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411147.17320722.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.64223382.8
 
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.