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

183 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
acceded133609(None) 
accede1138291accede_
acceder1235351acceder
accedes1237711accedes
acceders1334792acceders
accented13107772accented
accepted15105372accepted
accessed1385402accessed
accorded14155342accorded
accreted1336332accreted
accrued1233822accrued
accused12368422accused
arcaded1178972arcaded
ascended1246512ascended
ceded96118552__ceded
reacceded1573992reacceded
receded112713042receded
seceded11319202seceded
unceded11410562unceded
abided105313313a_bided
aboded104912513a_boded
abraded1138643abraded
accedence1344573accedence
acceding1446093acceding
accent105116263acce_nt
accents113511233accents
accept123210623acce_pt
acceptee14105713acceptee
accepter14144933accepter
accepts13356353accepts
access1037673acce_ss
accesses1287493accesses
accident13148183accident
accidia1246993accidia
accidie1247733accidie
accidies1338043accidies
accoladed1543943accoladed
accord1178843acc_ord
accorder1395223accorder
accosted1345503accosted
accredit1344843accredit
accredited1642663accredited
accrete1137843accrete_
accretes1238113accretes
accrue1035823accrue_
accrues1135323accrues
accursed1354633accursed
accuse103411033accuse_
accuser11347933accuser
accuses114112193accuses
aced79540883a_c__ed
acedia9310393a_cedia
ached119227833a_c_hed
achene11313813achene_
achenes12313493achenes
achieved1743713achieved
ackee115825363acke_e_
ackees124914573acke_es
acned87520663a_c_ned
acnode938193acnode_
acnodes1037823acnodes
acorned10238263acorned
acred87126353a_c_red
acrider1038623acrider
acted88521733a_c_ted
added84918433a__dded
adeemed1145393adeemed
adhered1239233adhered
aedes64625143a__edes
agreed84712503agre_ed
aided75828933a__ided
alcade91111513alcade_
alcades101011473alcades
alcoved1375613alcoved
aliened81011743aliened
alleged9389313alleged
alluded9327093alluded
altered83215733altered
amended11328313amended
aneled74719273a_neled
angeled93211503angeled
angered93013473angered
annexed1535753annexed
anteceded1343463anteceded
anteed75616113ante_ed
appended1435483appended
arcade91013643arcade_
arcades101113193arcades
arced88224163arc__ed
arched125717323arc_hed
arcked136211943arc_ked
ascared10399523ascared
ascend9429733asce_nd
ascender1136733ascender
asceses938623asceses
attended1035763attended
avoided1235553avoided
awarded1236223awarded
axseed1456993axse_ed
baccated15148373baccated
cached145419203cac_hed
cacheted16148233cacheted
cackled164613293cackled
cameoed1238383cameoed
canceled13279393canceled
cancered132411553cancered
capered123014043capered
carded105424903_carded
cascaded14135703cascaded
catered103117773catered
cede74928763__cede_
ceder85322233__ceder
cedes84927323__cedes
cered85227443__cered
cheder125113493_cheder
chefed155010563_chefed
chewed154415013_chewed
chided135113963_chided
cleped115114113_cleped
clewed1225113203_clewed
codded114515303_codded
coded95433183__coded
conceded1438283conceded
corded105923353_corded
creed85727393_cre_ed
creped114115703_creped
crewed125316553_crewed
curded104217163_curded
dackered16116893dackered
decided124312423decided
decoded123212383decoded
deeded94615543_deeded
emceed1136283emce_ed
encoded1139033encoded
exceed1636173exce_ed
exceeded1943493exceeded
excided1836203excided
faceted13509563faceted
heeded114215763_heeded
impeded13418183impeded
jacketed22146533jacketed
lackered15108673lackered
lackeyed18104513lackeyed
lanceted1137073lanceted
needed84114443_needed
occluded1492593occluded
ochered132610283ochered
packeted17148283packeted
parceled1338323parceled
preceded1438283preceded
racemed1237013racemed
racheted14149503racheted
racketed15169123racketed
reaccede1354363reaccede_
reaccedes1454463reaccedes
recede95515533recede_
recedes102816063recedes
recoded113115033recoded
reded74829113__reded
reeded84022563_reeded
saccade12107033saccade_
saccades13137253saccades
sacheted14127833sacheted
scalded11409763scalded
scended11329873scended
schemed1577753schemed
scolded11358853scolded
screed95718923scre_ed
screeded1235633screeded
screwed135710653screwed
scudded12215933scudded
secede93311993secede_
seceder10329573seceder
secedes103711983secedes
seeded84520463_seeded
speeded113310423speeded
succeed1235983succe_ed
succeeded1542383succeeded
sueded84014633_sueded
ulcered1037973ulcered
uncoded11312743uncoded
weeded113914873_weeded
ycleped1543393ycleped

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271838.40615944.2
3Display Results1831830.1231487.8
 (SQL Overall)1786911838.68520574.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.