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

278 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
acnodes103782(None) 
acnode938191acnode_
anodes74418751a_nodes
tacnodes1144991tacnodes
abodes94417512a_bodes
accedes1237712accedes
acnes75922622acn__es
ancones93116342ancones
anode65021032a_node_
anoles64827422a_noles
canoes84725882cano_es
codes86247292_c_odes
dynodes1235452dynodes
encodes10310642encodes
nodes64633492__nodes
tacnode1045082tacnode_
abides94719893a_bides
abioses9311493abioses
abode85518813a_bode_
aboded104912513a_boded
aboves114512843a_boves
abrades10312073abrades
accede1138293accede_
acceded1336093acceded
acceder1235353acceder
acceders1334793acceders
accidies1338023accidies
accolades1445423accolades
accorded14155343accorded
accorder1395223accorder
accorders14144113accorders
accords1247243accords
accosts11107993accosts
accrues1135323accrues
accuses114112193accuses
aces67645093ac___es
acetones10310033acetones
achenes12313493achenes
aches106132293ac__hes
achiotes1339003achiotes
acidoses1136773acidoses
acids87121003ac_id_s
acinose938573acinose_
acinous9310923acino_us
ackees124914573ac_kees
acmes96020653ac__mes
acne66625873acn__e_
acned87520663acn__ed
aconites10314343aconites
acorns85013013ac_orns
acres76327763ac__res
acrider1038623acrider
acridest1138143acridest
acrogen1038193acrogen
acrogens1147243acrogens
across8312643acro_ss
actinides12188323actinides
actives12311523actives
actors81016753acto_rs
acutes83917723ac_utes
adenoses947903adenoses
adnouns835453adnouns
adobes94411523a_dobes
adores74420713a_dores
aedes64625143a__edes
aerobes9311493aerobes
agnates82813183agnates
agnizes17328843agnizes
agnomen1036763agnomen
agnomens1144893agnomens
agones75719863a_gones
agonies83016623agonies
aides65336603a__ides
alamodes1148013alamodes
alcades101011473alcades
alcaides11117673alcaides
alcaldes11114983alcaldes
alcaydes14133723alcaydes
alcoves1297873alcoves
aldoses8311203aldoses
allods73615083allod_s
alludes83610333alludes
almudes10418263almudes
aloes54933673a_lo_es
ambones11312683ambones
amides95722663a_mides
amniotes1036603amniotes
amoles84122193a_moles
anadem939183a_nadem
anadems1036143a_nadems
ancone83916953ancone_
ands57833613a_n_d_s
aneles64626293a_neles
anes45255933a_n__es
angles74426703a_ngles
animes84719593a_nimes
anises64826693a_nises
ankles104818383a_nkles
annates72415423annates
annexes1437203annexes
annonas738793annonas
annoyed1185863annoyed
annoyer1095603annoyer
annoyers1185033annoyers
annoys967523anno_ys
anoas57226493a_no_as
anodal72512113a_nodal
anodic92813133a_nodic
anodizes1837963a_nodizes
anodynes1244443a_nodynes
anole55330373a_nole_
anomies93316983a_nomies
antes56334323a_n_tes
antinodes1099603antinodes
antres65021003a_ntres
anuses66218773a_nuses
aphides134711203aphides
apnoea867093apno_ea
apnoeas946353apnoeas
apods86316343a_pod_s
apposes11511473apposes
apsides103911303apsides
arbores94016033arbores
arcades101113193arcades
areoles71016953areoles
arkoses113910833arkoses
asides75118873a_sides
atones65225773a_tones
atonies75320953atonies
aubades1038743aubades
aunties73920073aunties
axones134614513a_xones
azides165113803a_zides
azoles154614613a_zoles
azotes154312223a_zotes
blondes104213163blondes
bodes84935103__bodes
cades85440733_c_ades
cajoles163712103cajoles
cajones163311333cajones
canapes111213083canapes
candies104125613candies
candles104422343candles
candors104216763candors
canes75350373can__es
cangues10611823cangues
canids95118133canid_s
canines93724033canines
canoe75627253cano_e_
canoed94618953cano_ed
canoer85121073cano_er
canoers94318373canoers
canolas9313993canolas
canoness1039393canoness
canons85522063cano_ns
canoodles1243993canoodles
canopies12311853canopies
cantles94721413cantles
canzones1939153canzones
capotes11314643capotes
cathodes1439373cathodes
cedes84927323_c_edes
cenotes92814543cenotes
chides124620473_chides
chokes154917383_chokes
chores114828023_chores
choses115825123_choses
clades94920463_clades
clods85320863_clod_s
clones84526563_clones
closes85425593_closes
cloves114918823_cloves
clozes174915563_clozes
codas84724243_c_odas
code77347733_c_ode_
codec107120343_c_odec
codecs115112933_c_odecs
coded95433183_c_oded
coden86128543_c_oden
codens94821013_c_odens
coder86134213_c_oder
coders95426973_c_oders
codex155817573_c_odex
cods76848103_c_od_s
coeds85920163_c_oeds
cokes115537193_c_okes
coles76055063_c_oles
comes97246993_c_omes
condoes104319203_condoes
condos94322333_condos
cones76457423_c_ones
conges94928173_conges
conies84338593_conies
contes84432913_contes
cooees85621893_cooees
copes97747103_c_opes
cores76361853_c_ores
coses76949493_c_oses
cotes76347843_c_otes
coves105539173_c_oves
coxes145430863_c_oxes
cozes166033243_c_ozes
crones84729243_crones
crores86121163_crores
crozes174417663_crozes
crudes96218623_crudes
crunodes1144973crunodes
decodes113914983decodes
denotes83817003denotes
denudes91510043denudes
diodes83915783_diodes
dynode1135023dynode_
echoes114715523echo_es
encode9310443encode_
encoded1139033encoded
encoder1038633encoder
encoders1137513encoders
encores9315213encores
epodes94315563_epodes
erodes74819883_erodes
facades1339033fac_ades
genomes103611703genomes
geodes8412153_geodes
gnomes93812973_gnomes
gnoses76515163_gnoses
icones84616383ic_ones
ignores8269003ignores
incomes11712373incomes
incudes10319523incudes
ionones7313883ionones
kathodes1646183kathodes
lactones10311223lactones
lactoses1039813lactoses
lodes66436913__lodes
maenades1137473maenades
mannoses1039083mannoses
modes85537413__modes
monades103713823monades
mondes94322353mon_des
monodies11312493monodies
nides65229133__nides
node513036883__node_
nods55838223__nod_s
nodus66315993__nodus
noes45845393__no_es
nomes74933123__nomes
nones55639133__nones
noses55435643__noses
notes55034583__notes
nudes64723293__nudes
odes57243243___odes
palinodes1245883palinodes
pentodes11310363pentodes
pinoles93418703pinoles
pinones94717063pinones
pycnoses1554973pycnoses
rachides141511223rachides
recodes102918633recodes
rodes614039083__rodes
saccades13137243saccades
sarodes84216143sarodes
schnozes2244483schnozes
sconces113811453sconces
scones84521303sc_ones
scopes104719593sc_opes
scores84725923sc_ores
scrods94111603scrod_s
secondes1138133secondes
senores73218113senores
snores64324313_snores
sondes74922873son_des
spodes94817433_spodes
synods1077953synod_s
triodes84012503triodes
uncoded11312743uncoded
undoes73917403_undoes
vacuoles1345013vacuoles
winoes94317013wino_es

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272786.20321606.8
3Display Results2782780.0962895.8
 (SQL Overall)1786912786.45527682.6
 
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.