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

211 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
accedes123772(None) 
accede1138301accede_
acceded1336101acceded
acceder1235361acceder
acceders1334791acceders
accents113511232accents
accepts13356352accepts
access1037682acce_ss
accesses1287492accesses
accidies1338042accidies
accretes1238112accretes
accrues1135322accrues
accuses114112192accuses
achenes12313492achenes
ackees124914582acke_es
acnodes1037832acnodes
aedes64625152a__edes
alcades101011472alcades
arcades101113192arcades
asceses938622asceses
cedes84927332__cedes
reaccedes1454462reaccedes
recedes102816062recedes
saccades13137252saccades
secedes103711982secedes
abeles84719393a_beles
abides94719893a_bides
abodes94417513a_bodes
abrades10312073abrades
academes1344873academes
accedence1344573accedence
accedences1454163accedences
acceding1446093acceding
accent105116263acce_nt
accented13107773accented
accept123210623acce_pt
accepted15105383accepted
acceptee14105723acceptee
acceptees15113693acceptees
accepter14144933accepter
accepters15114603accepters
accessed1385403accessed
accident13148183accident
accidents14155133accidents
accidia1246993accidia
accidias1346333accidias
accidie1247733accidie
accolades1445433accolades
accorded14155353accorded
accorder1395243accorder
accorders14144123accorders
accords1247243accords
accosts11107993accosts
accredit1344843accredit
accredits1443433accredits
accrete1137843accrete_
accreted1336333accreted
accrue1035823accrue_
accrued1233823accrued
accuse103411033accuse_
accused12368423accused
accuser11347933accuser
accusers12285903accusers
aced79540883a_ced__
acedia9310393a_cedia
acedias1039773a_cedias
aces67645093a_c__es
ached119227833ached__
achene11313813achene_
aches106132293a_c_hes
achieves1645523achieves
acids87121003a_cid_s
ackee115825373acke_e_
acmes96020653a_c_mes
acned87520673acned__
acnes75922623a_c_nes
acnode938203acnode_
acreages1138373acreages
acred87126353acred__
acres76327763a_c_res
acrider1038623acrider
acridest1138143acridest
acted88521733acted__
actives12311523actives
acutes83917723a_cutes
adheres11310163adheres
agenes74720253a_genes
agrees74915323agre_es
aides65336603a__ides
akees96119243a_ke_es
akenes104817343a_kenes
albedoes1184533albedoes
albedos1075253albedos
alcade91111513alcade_
alcaides11117673alcaides
alcaldes11114983alcaldes
alcaydes14133723alcaydes
alcids94812293alcid_s
alcoves1297873alcoves
alkenes114212753alkenes
allees64521483alle_es
alleges84212573alleges
alleles73812033alleles
alludes83610333alludes
almudes10418263almudes
amides95722663a_mides
amperes11313983amperes
ancones93116343ancones
aneles64626293a_neles
annexes1437203annexes
anodes74418763a_nodes
antecedes1245063antecedes
apexes1539133a_pexes
apheses12610703apheses
aphides134711203aphides
apsides103911303apsides
arcade91013643arcade_
arcaded1178973arcaded
arced88224163arced__
arches114822043arc_hes
arcuses94814693arcuses
arenes64928393a_renes
aretes64425353a_retes
ascended1246513ascended
ascender1136733ascender
ascenders1235683ascenders
ascends10388203ascends
ascents93812553ascents
ascesis938373ascesis
ascites9312603ascites
asides75118873a_sides
askeses1136463askeses
aubades1038753aubades
auxeses1435623auxeses
axseeds1533393axseeds
azides165113803a_zides
bredes94818473_bredes
caches137926913cac_hes
cackles153717203cackles
cades85440733__cades
cascades13128553cascades
cede74928773__cede_
ceded96118563__ceded
ceder85322243__ceder
ceders93817673__ceders
cedis84317083__cedis
cees65941593__ce_es
cepes94424463__cepes
ceres75540013__ceres
cetes75731103__cetes
cheder125113493_cheder
cheders134512393_cheders
chides124620473_chides
clades94920463_clades
clepes104214623_clepes
codes86247293__codes
coeds85920163_coed_s
concedes13311063concedes
credos94612853_credos
creds85418773_cred_s
creeds94714773_creeds
cremes104517993_cremes
crepes105419343_crepes
crudes96218623_crudes
cyeses11510123_cyeses
decades113615513decades
decides114217653decides
decodes113914983decodes
ecocides1346583ecocides
emcees1037813emce_es
encodes10310643encodes
exceeds1733843exceeds
excides1738343excides
facades1339033facades
gledes84915133_gledes
hackees165014103hacke_es
haeredes1246333haeredes
heredes11313133heredes
impedes124310093impedes
incudes10319523incudes
lycees11428863lyce_es
machetes1539633machetes
myceles1435213myceles
occludes1363103occludes
pedes85327293__pedes
precedes13310713precedes
racemes1139093racemes
rachides141511223rachides
reaccede1354363reaccede_
reacceded1573993reacceded
recede95515533recede_
receded112713043receded
recodes102918633recodes
redes65139133__redes
saccade12107033saccade_
saccules1237033saccules
scenes84520353_scenes
schemes1489663schemes
screeds106210293screeds
screes85023973scre_es
secede93311993secede_
seceded11319203seceded
seceder10329573seceder
seceders11277963seceders
succeeds1343693succeeds
suedes73918113_suedes
swedes102711893_swedes
sycees11409653syce_es
tacnodes1145003tacnodes
unceded11410563unceded
vaccines1536503vaccines

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272117.11018850.5
3Display Results2112110.0802637.5
 (SQL Overall)1786912117.61023481.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.