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

139 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
acceding144609(None) 
accenting1487822accenting
accepting1695802accepting
accessing1445832accessing
according1545272according
accreting1446332accreting
accruing1344032accruing
accusing1336782accusing
arcading1239762arcading
ascending1336282ascending
ceding104014802__ceding
reacceding1644222reacceding
receding122713762receding
seceding12288562seceding
abiding11510503a_biding
aboding11410123a_boding
abrading1239503abrading
accede1138293acced__e
acceded1336093acced_ed
accedence1344573accedence
acceder1235353acced_er
acceders1334793acceders
accedes1237713acced_es
accent105116263acce__nt
accident13148183accident
accidia1246993accidi_a
accidias1346333accidias
accidie1247733accidi_e
accidies1338043accidies
accolading1644773accolading
accosting1446733accosting
accredit1344843accredi_t
accrediting1752463accrediting
accredits1443433accredits
acedia9310393a_cedi_a
acedias1039773a_cedias
acetin8314693a_cetin_
acetins9313173a_cetins
achieving1843303achieving
aching126521973a_c_hing
acing87429153a_c__ing
acridine1139553acridine
acting95920983a_c_ting
adding93914963a__dding
adeeming1254793adeeming
adhering1338883adhering
aedine73218393a__edine
ageing84213403a_ge_ing
agreeing10295903agreeing
aiding84423613a__iding
alcidine1148233alcidine
aliening91510893aliening
alleging1038473alleging
alluding1036953alluding
altering91917113altering
amending12308913amending
aneling82719503a_neling
angeling102811733angeling
angering102113803angering
annexing1635473annexing
anteceding1443953anteceding
anteing8312813ante_ing
appending1536283appending
arcadings1354393arcadings
arching136216693arc_hing
arcing95819643arc__ing
arcking145811963arc_king
atheling1249203atheling
attending11136373attending
auding83616933a__uding
avoiding1336783avoiding
awarding1356043awarding
aweing103911253a_we_ing
bleeding12359053bleeding
breeding123411843breeding
cacheting1737153cacheting
caching156317503cac_hing
cackling172610943cackling
cageling12310843cageling
cameoing1379063cameoing
canceling14310163canceling
capering132414963capering
carding113922433_carding
cascading1545673cascading
catering112019903catering
cering94522533__cering
chefing16359033_chefing
chewing163911143_chewing
chiding143911593_chiding
cleping123310423_cleping
clewing13359583_clewing
codding124014693_codding
coding104024793__coding
conceding1559343conceding
cording113620823_cording
creping122913653_creping
crewing133212623_crewing
cueing94913613_cue_ing
curding113515133_curding
dackering1737383dackering
deciding132210833deciding
decoding132410053decoding
deeding103315123_deeding
emceeing1343573emceeing
encoding1239043encoding
exceeding2043493exceeding
exciding1935923exciding
faceting1438783faceting
feeding123515073_feeding
heeding123515063_heeding
impeding1436563impeding
jacketing2345643jacketing
lacewing1435843lacewing
lackering1639373lackering
lackeying1934923lackeying
needing93214423_needing
occluding1542823occluding
ochering14219393ochering
packeting1836853packeting
parceling1438443parceling
preceding15129363preceding
racheting1537793racheting
racketing1647873racketing
recoding122213853recoding
reding83825563__reding
reeding94124133_reeding
scalding12339393scalding
scending122610583scending
scheming1636633scheming
scolding12278913scolding
screeding1336313screeding
screwing14288223screwing
scudding1335673scudding
seeding93719483_seeding
speeding122810933speeding
succeeding1642683succeeding
sueding92613753_sueding
ulcering1139333ulcering
weeding123815213_weeding

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621397.34319904.9
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.56223630.1
 
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.