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

493 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
ancone8391695(None) 
ancon75718231ancon_
ancones93116341ancones
anyone94612731anyone
acne66625872a_c_ne
acnode938192acnode
agone65924552a_gone
alcove1178082alcove
alone55732962a_lone
anconal939422anconal
anconeal1045592anconeal
anemone9119452anemone
anion55028812anion_
anions64123032anions
annona648872annona
anode65021032an_ode
anole55330372an_ole
anon46134852an_on_
anyon85615222anyon_
anyons94513502anyons
arcane81216742arcane
atone56527982a_tone
axone125918472a_xone
canzone1858812canzone
cone67256962__cone
encode9310442encode
encore8314772encore
income10712092income
incony1139082incony
intone61115432intone
none45743172_n_one
scone74621832_scone
undone7914252undone
abalone938903abalone
abode85518813a_bode
aboon74918703aboon_
above105414323a_bove
abscond1244503abscond
accede1138293accede
accent105116263accent
accord1178843accord
accost101112263accost
account11109043account
accrue1035823accrue
accuse103411033accuse
ace59656833a_c__e
acetone9310793acetone
ache96829823a_c_he
achene11313813achene
acing87429153a_cing
acini75718983a_cini
ackee115825363a_ckee
acme86924323a_c_me
acned87520663a_c_ned
acnes75922623a_c_nes
acnodes1037823acnodes
acock132110213a_cock
acold86214923a_cold
aconite9315473a_conite
acorn75616623a_corn
acorned10238263a_corned
acorns85013013a_corns
acre67330773a_c_re
acute74720363a_cute
adobe84814713a_dobe
adore65723673a_dore
adoze155713833a_doze
aedine73218393aedine
aeon45634613a_eon_
aeons57624653a_eons
aerobe8412403aerobe
affine12310503affine
afore85818603a_fore
agene65621583a_gene
aglycone1442873aglycone
agon56531883a_gon_
agones75719863a_gones
agons66423783a_gons
agony96415653a_gony
akene95818663a_kene
alane56135613a_lane
alcade91111513alcade
alcoved1375613alcoved
alcoves1297873alcoves
aldose7311093aldose
alencon945733alencon_
alencons1045473alencons
aline57243153a_line
alkane104313323alkane
alkene104114003alkene
alkine104916803alkine
alkyne13436863alkyne
allonge837023allonge
almond91410433almond
almoner949383almoner
aloe45540193a_lo_e
along65419493a_long
alpine84417373alpine
alvine94614583alvine
amarone9311203amarone
ambones11312683ambones
amidone10349313amidone
amine75835383a_mine
ammine10314493ammine
ammono1047373ammono
amnion84812053amnion_
amnions93710913amnions
amniote936963amniote
amole75724593a_mole
among85813303a_mong
anaconda1143783anaconda
anagoge9166643anagoge
ananke1038283ananke
ancho104515303anc_ho
anchor113911973anchor
anchored1438593anchored
anchoret13412453anchoret
anchors123912953anchors
anchos114214893anchos
anchovy1843953anchovy
ancient9514733ancient
anconoid1146463anconoid
andante8311273andante
ane37866953a___ne
anecdote1183673anecdote
anele55628833an_ele
anemones10249473anemones
anent54931843an_ent
angina7413133angina
angle64528873an_gle
angora71111573angora
anguine839913anguine
anile54634463an_ile
aniline7418473aniline
anime75423203an_ime
anionic9312873anionic
anise55129703an_ise
anisole71010833anisole
ankle95220253an_kle
anlace82513923anlace
anlage72514223anlage
anna45529013an__na
annex12310883an__nex
annexe1337813annexe
annonas738793annonas
announce1044323announce
annoy869713anno_y
annoyed1185863annoyed
annoyer1095603annoyer
annoys967523annoys
anoa45634473an_o_a
anoas57226493an_oas
anodes74418753an_odes
anodyne1144153anodyne
anoint6423633anoint
anoles64827423an_oles
anomie83215963anomie
anomy105113393an_omy
anonym1136383an_onym
ansae55720973an_sae
ansate64517863ansate
antae56828293an_tae
ante46538903an__te
anting75827023anting
antonym1246513antonym
antre55224523an_tre
anymore1256243anymore
apocope1346033apocope
appose10411993appose
apron7318833apron_
aproned10311503aproned
aprons8316993aprons
arcade91013643arcade
arcana8912583arcana
archine125817053archine
archon11311753archon_
archons12311583archons
arcing95819643arcing
arco68331543arco__
arcsine94512393arcsine
arene55329413a_rene
areole61017283areole
argon65520593argon_
argons75018203argons
ariose64818723ariose
arkose104911343arkose
arose55832083a_rose
arsine64021043arsine
arson55118833arson_
arsons63917213arsons
ascend9429733ascend
ascent84519653ascent
ascot76522513asco_t
ascots85312513ascots
ashore9414613ashore
aslope839013aslope
astony9510523astony
atoned75417543a_toned
atoner64817193a_toner
atones65225773a_tones
atony87218853a_tony
attune637983attune
avion84218343avion_
avions94114393avions
awoke124912003a_woke
axion1211316913axion_
axions134713483axions
axon115524303a_xon_
axones134614513a_xones
axons125517933a_xons
azine146721413a_zine
azlon144312873azlon_
azlons154110423azlons
azole145118033a_zole
azon135725053a_zon_
azons146518253a_zons
azote144416343a_zote
bacon95620593bacon_
bacons104917583bacons
balcony1435853balcony
banco94019393banco__
bancos104713893banco_s
bandore10611633bandore
become123312593become
begone9512133begone
bicorne11297553bicorne
bizone1738603bizone
bone65949323__bone
bygone1256173bygone
calcine11315273calcine
calzone1848623calzone
cancan10314103cancan_
cancans11311873cancans
cane66653123__cane
canine83826703can_ine
cannon84514443cannon_
cannoned11118133cannoned
cannons94412883cannons
canoe75627253can_o_e
canon74725303can_on_
canons85522063can_ons
canton85722993canton_
cantoned111411523cantoned
cantons95221203cantons
canyon114512033canyon_
canyons124511593canyons
canzona1836073canzona
canzones1939153canzones
canzonet19410583canzonet
canzoni1836153canzoni
cine66242943__cine
clone75728163_clone
code77347733__code
coke107038383__coke
cole66956113__cole
colone85425003colone
come87547703__come
con510268023__con_
condone102616293condone
coned86040053__coned
cones76457423__cones
coney105932883__coney
conge85227593__conge
coni65534803__coni
conk106531443__conk
conn66229133__conn
cons66057693__cons
conte76633203__conte
cony96537833__cony
cope86847383__cope
core67263113__core
cote66648733__cote
cove95837073__cove
crone75231333_crone
cyclone1437243cyclone
dance85223133danc__e
dancing113611563dancing
dapsone1038463dapsone
debone93714783debone
decane93818873decane
decode104414743decode
depone93616553depone
done55747913__done
drone65324983_drone
encage93713503encage
encase83714363encase
encina8310443encina
enclose999993enclose
encoded1139033encoded
encoder1038633encoder
encodes10310643encodes
encored10412103encored
encores9315213encores
engine71114863engine
enrobe86610793enrobe
ensconce1244713ensconce
eocene8311613eocene
evzone1894683evzone
falcon11310293falcon_
falconer1346033falconer
falconet13410353falconet
falcons1239123falcons
fanion94514323fanion_
fanions103713073fanions
fanon84619013fan_on_
fanons96115213fan_ons
fanzine1937123fanzine
fascine12510583fascine
fucose11167683fucose
garcon92912483garcon_
garcons102411643garcons
gascon9339723gascon_
gascons10289103gascons
gnome84213953gn_ome
gone55639043__gone
hambone1439313hambone
hance105424153hanc__e
hexone16289233hexone
hone77549323__hone
icon66922043_icon_
icones84616383_icones
icons76516493_icons
impone103011863impone
inane52820343in_ane
incage93513623incage
incant82418503incant
incase83615283incase
incense92410303incense
incent83320723incent
incise83515333incise
incite83618733incite
incline9314643incline
inclose9910223inclose
incog838253inco_g
incogs937903incogs
incomer1169943incomer
incomes11712373incomes
inconnu945053inconnu
incuse83513573incuse
indene73215373indene
indole74516053indole
inion54620183inion_
inions64417003inions
insane6314883insane
insole63515863insole
intine61021983intine
intoned8811993intoned
intoner7811673intoner
intones7816543intones
invoke1336213invoke
inwove12167273inwove
ionone6313443ionone
irone55126363_irone
jaconet16311483jaconet
jawbone19134443jawbone
jocose1537103jocose
ketone105014533ketone
krone94018733_krone
lactone9311393lactone
lacune8169673lacune
ladrone83611873ladrone
lance75126723lanc__e
lancing103314123lancing
lanose6313593lan_ose
leone55018823_leone
lone45849133__lone
macon94519953macon_
macons104017243macons
madrone102812663madrone
manche133515103manc_he
mangonel1185763mangonel
manhole12311343manhole
mannose939243mannose
manrope1138033manrope
mascon103612743mascon_
mascons113411583mascons
mucose10149313mucose
nacre75715363nac_re
nance74721843nanc__e
narcose95910383narcose
narine63422553narine
nene45932063_n_ene
neon47026423_neon_
neoned7311483_neoned
neons55818683_neons
nine45842173_n_ine
node513036883_n_ode
nome66038423_n_ome
nona46929063_n_ona
nonce75719823_n_once
noncore9411953noncore
nones55639133_n_ones
nonet54540843_n_onet
noon47134623_noon_
noons54125283_noons
noose55624063_noose
nope65934193_n_ope
nose46739363_n_ose
note46239963_n_ote
ochone11311293ochone
once65423083onc__e
oncogene1145953oncogene
one37050913___one
onion54320973onion_
onions64016433onions
oniony9369703oniony
online6315843online
orgone71110913orgone
oscine8311563oscine
ozone14310613_ozone
padrone102512073padrone
pancake1536673pancake
pandore10411853pandore
pangene102711963pangene
panne76623653pan__ne
panoche1456383panoche
phone105621933_phone
pinbone1138183pinbone
pinecone1246063pinecone
pone65747533__pone
prone75332623_prone
pyrone112714473pyrone
racon75422143racon_
racons84319343racons
rance75028513ranc__e
rancor8810373ranco_r
rancored1137223rancored
rancors9811373rancors
rancour987133rancour
recane83022873recane
recode93618713recode
recon75624243recon_
recons84922993recons
redone74820053redone
rezone153814783rezone
scene77220573_scene
sconce104711723_sconce
scones84521303_scones
scope94821483_scope
score75526733_score
second9411153second
seconde1037413seconde
shone83725983_shone
snooze15439993snooze
snore55424953sn_ore
sone46649983__sone
stone55431183_stone
syncope1445383syncope
tacnode1045083tacnode
talcose938133talcose
throne98517603throne
tone46953743__tone
trone55131863_trone
unboned103014223unboned
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
unchoke16248193unchoke
unciae83215313unciae
uncini8310153uncini
uncle7317053unc_le
unclose91111643unclose
unco66021403unco__
uncock1438563uncock
uncoded11312743uncoded
uncoil8811853uncoil
uncoined111813023uncoined
uncool8610113uncool
uncork1239043uncork
uncos74117033unco_s
uncover1239003uncover
uncoy104111413unco_y
uncute82912133uncute
undine7817263undine
unfond10149113unfond
union54519793union_
unions64216753unions
unrobe82611673unrobe
unrove92511683unrove
untune62511603untune
unwon84512343unwon_
unwove12238883unwove
unyoke1367293unyoke
unzoned172310653unzoned
vaccine1437323vaccine
wanion93213063wanion_
wanions104011373wanions
wanton94413813wanton_
wantoned12117223wantoned
wantoner1187563wantoner
wantons103713013wantons
xanthone1847113xanthone
zone135231083__zone

Search took 6 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.1401276364.3
2DLD Change Limit1127164934.90622975.1
3Display Results4934930.1563160.3
 (SQL Overall)1786914935.20234350.4
 
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.