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

279 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
accede113829(None) 
acceded1336091acceded
acceder1235351acceder
accedes1237711accedes
acceders1334792acceders
accent105116262accent
accept123210622accept
access1037672access
accidie1247732accidie
accrete1137842accrete
accrue1035822accrue
accuse103411032accuse
aced79540882a_ced_
ached119227832ached_
achene11313812achene
ackee115825362acke_e
acned87520662acned_
acnode938192acnode
acred87126352acred_
acted88521732acted_
alcade91111512alcade
arcade91013642arcade
arced88224162arced_
cede74928762__cede
reaccede1354362reaccede
recede95515532recede
saccade12107032saccade
secede93311992secede
aahed917816443aahed_
abed79734133a_bed_
abele76323253a_bele
abide86223713a_bide
abled86926833abled_
abode85518813a_bode
abrade9313053abrade
academe1244703academe
accedence1344573accedence
acceding1446093acceding
accented13107773accented
accents113511233accents
accepted15105373accepted
acceptee14105713acceptee
accepter14144933accepter
accepts13356353accepts
accessed1385403accessed
accesses1287493accesses
accident13148183accident
accidia1246993accidia
accidies1338043accidies
accolade1346043accolade
accord1178843accord
accorded14155343accorded
accorder1395223accorder
accords1247243accords
accost101112263accost
accredit1344843accredit
accreted1336333accreted
accretes1238113accretes
accrued1233823accrued
accrues1135323accrues
accused12368423accused
accuser11347933accuser
accuses114112193accuses
ace59656833a_c__e
acedia9310393a_cedia
acerb9312763a_cerb
aces67645093a_ce_s
aceta74017353a_ceta
ache96829823a_c_he
achenes12313493achenes
aches106132293ache_s
achieve1545023achieve
acid77533393a_cid_
acids87121003a_cids
acidy117214893a_cidy
ackees124914573ackees
acme86924323a_c_me
acmes96020653acme_s
acne66625873a_c_ne
acnes75922623acne_s
acnodes1037823acnodes
acold86214923acold_
acre67330773a_c_re
acreage1037833acreage
acres76327763acre_s
acrid86920103acrid_
acrider1038623acrider
active11313743active
acuate8315633acuate
acute74720363a_cute
added84918433added_
adhere10310333adhere
adzed166012543adzed_
aedes64625143a__edes
aged67334253a_ged_
agee56241493a_ge_e
agene65621583a_gene
aglee65728493agle_e
agree65226033agre_e
agreed84712503agreed
ahed89536253a_hed_
aide56044993a__ide
aided75828933aided_
ailed66240283ailed_
aimed85626053aimed_
aired66032923aired_
ajee115928233a_je_e
akee85936813a_ke_e
akene95818663a_kene
albedo956123albedo
alcades101011473alcades
alcaide1088453alcaide
alcalde10104953alcalde
alcayde13103723alcayde
alcid85817973alcid_
alcids94812293alcids
alcove1178083alcove
alee46652323a_le_e
alkene104114003alkene
allee54932123alle_e
allege74314643allege
allele64514563allele
allude73910903allude
almude9399933almude
amide86128483a_mide
amped104820513amped_
ampere10514413ampere
ancone83916953ancone
anele55628833a_nele
annexe1337813annexe
anode65021033a_node
antecede1145023antecede
anted66328243anted_
anteed75616113anteed
aped78538153a_ped_
apiece10510083apiece
arcaded1178973arcaded
arcades101113193arcades
arcane81216743arcane
arched125717323arched_
arcked136211943arcked_
areae55229743a_reae
arene55329413a_rene
arete56031353a_rete
armed86324433armed_
ascend9429733ascend
ascended1246513ascended
ascender1136733ascender
ascends10388203ascends
ascent84519653ascent
asceses938623asceses
ashed97829773ashed_
aside65122083a_side
asked106919313asked_
aubade939223aubade
awed88436033a_wed_
awee76336643a_we_e
awned96615953awned_
axed128829613a_xed_
axled135315813axled_
axseed1456993axseed
azide155617163a_zide
baccae12119703bacc_ae
baccate131011263baccate
bached145519893bached_
backed155725723backed_
brede85520503_brede
cache125122483cac_he
cached145419203cached_
cackle143416923cackle
cade76443913__cade
caged95426363caged_
caked126128623caked_
caned85838093caned_
caped104931803caped_
cared86050093cared_
cascade12118603cascade
cased86032413cased_
caved116227563caved_
cawed116627063cawed_
ceded96118553__ceded
ceder85322233__ceder
cedes84927323__cedes
cedi74919273__cedi
cee55952703__ce_e
cepe84926653__cepe
cere66741473__cere
cete64934783__cete
cheder125113493_cheder
chide115321013_chide
clade85821013_clade
clepe94617383_clepe
code77347733__code
coed77140543_coed_
coeds85920163_coeds
concede12310093concede
coude85022633_coude
cred76530883_cred_
credo84815563_credo
creds85418773_creds
creed85727393_creed
creme94319323_creme
crepe95520723_crepe
crude86018573_crude
cued76329563_cued_
danced105315253danced_
decade104216163decade
decide104116873decide
decode104414743decode
diced95824683diced_
eched116919223eched_
ecocide1246733ecocide
emcee9315943emce_e
emceed1136283emceed
encode9310443encode
eocene8311613eocene
exceed1636173exceed
excide1638423excide
facade1238803facade
faced117727653faced_
facete115014833facete
farced125216533farced_
glede75517833_glede
hacked164923513hacked_
hackee154921833hacke_e
iced78721893_iced_
impede11469623impede
jacked204817523jacked_
laced87132643laced_
lacked135324653lacked_
lanced93717723lanced_
lycee104716743lyce_e
macchie1647193macchie
maced108528693maced_
machete14310883machete
macled116718113macled_
mycele1335853mycele
nacred95212493nacred_
occlude1263183occlude
ocreae83310273ocreae
paced106931683paced_
packed154822603packed_
precede1239643precede
raced87635313raced_
raceme1039733raceme
racked134526083racked_
reacceded1573993reacceded
reaccedes1454463reaccedes
receded112713043receded
recedes102816063recedes
recode93618713recode
rede55037663__rede
riced85825543riced_
saccades13137253saccades
saccate111311763saccate
saccule1136743saccule
sacked135525213sacked_
sacred94917103sacred_
sauced93913303sauced_
scene77220573_scene
scheme1379633scheme
scree720031703scre_e
screed95718923screed
seceded11319203seceded
seceder10329573seceder
secedes103711983secedes
sicced11489653sicced_
succeed1235983succeed
suede64419753_suede
swede94413203_swede
sycee105018623syce_e
tacked134723943tacked_
tacnode1045083tacnode
talced93811003talced_
ticced11438443ticced_
unceded11410563unceded
vaccine1437323vaccine
viced115118183viced_
yacked164516793yacked_

Search took 7 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 Filter1786911127160.203880251.2
2DLD Change Limit1127162796.11018447.8
3Display Results2792790.0933000.0
 (SQL Overall)1786912796.40627894.3
 
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.