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

273 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
archon1131175(None) 
archons12311581archons
achoo10315082a_choo
ahchoo1445712ahchoo
ancho104515302ancho_
anchor113911972anchor
anchos114214892anchos
ancon75718232anc_on
arch98628442arch__
archaeon13134072archaeon
archean1269122archean
arched125717322arched
archer115016242archer
arches114822042arches
archfoe1544722archfoe
archil11611572archil
archine125817052archine
arching136216692arching
archly1437352archly
arco68331542arc_o_
argon65520592ar_gon
arshin9312172arshin
arson55118832ar_son
barchan1469132barchan
chon96627792__chon
garcon92912482garc_on
larchen12479622larchen
marchen143312072marchen
racon75422142rac_on
racoon83814472racoon
torchon1237362torchon
urchin1138742urchin
abhor10411063a_bhor
abmho1236793abmho_
abmhos1334973abmhos
aboon74918703a_boon
ache96829823a_ch_e
ached119227833a_ched
achene11313813a_chene
aches106132293a_ches
aching126521973a_ching
achy126316093a_ch_y
acorn75616623a_corn
actin74922553a_ctin
action84719683action
actor71116073a_ctor
aeon45634613a__eon
afghan1333873afghan
agon56531883a__gon
ahoy101919183a__hoy
airshot1059493airshot
airshow1344623airshow
alcohol1244363alcohol
alphorn1246393alphorn
altho86312603altho_
althorn1047763althorn
amazon1736833amazon
amnion84812053amnion
anchors123912953anchors
anchovy1843953anchovy
ancone83916953anc_one
anion55028813a_nion
anon46134853a__non
anyhow1544103anyhow
anyon85615223a_nyon
apron7318833a_pron
arbor74818113ar_bor
arc510250903arc___
arcade91013643arcade
arcana8912583arcana
arcane81216743arcane
arced88224163arc_ed
archaea12137613archaea
archaean13135163archaean
archaic1438823archaic
archers124414573archers
archery15478063archery
archfoes1644993archfoes
archils12510533archils
archines133815253archines
archings14499863archings
archive154610483archive
archway1844893archway
arcing95819643arcing
arcked136211943arcked
arcking145811963arcking
arcs67834783arc__s
arcsine94512393arcsine
arctic10313513arctic
arcus76918863arc_us
ardor64617863ar_dor
argol65317263ar_gol
argons75018203ar_gons
argot67728653ar_got
arhat8327093ar_hat
arisen65316793arisen
armhole1236943armhole
armor75118053ar_mor
arpen74418043ar_pen
arrow83414883ar_row
arseno6318913arseno
arshins10312573arshins
arsino64113513arsino
arsons63917213ar_sons
arvo76023433ar_vo_
arvos86015663ar_vos
ascot76522513asc_ot
ashcan1135843ashcan
ashen87818673a_shen
aswoon947013aswoon
auction93412933auction
author939763author
avion84218343a_vion
axion1211316913a_xion
axon115524303a__xon
azlon144312873a_zlon
azon135725053a__zon
bacon95620593bac_on
barchans1588683barchans
barhop13319643bar_hop
baron78131243bar__on
baryon111211613bar_yon
baryton1246003baryton
beckon14309383beckon
bicron103710773bicron
birchen14347883birchen
brechan1437223brechan
cabochon1742763cabochon
cachou13310623cachou
carbon104919043car_bon
cardon94120853car_don
cardoon104813813cardoon
carhop133610763car_hop
carrion9312673carrion
carryon1237033carryon
carton84522663car_ton
cartoon94114463cartoon
chin96934743__chin
chop116024923__chop
chow125820993__chow
cion613330913__cion
clon66232483__clon
cochin131313203cochin
cocoon10312263cocoon
con510268023__c_on
coon67248943__coon
craton84517193craton
crayon114110003crayon
crepon1039943crepon
croon75522783cr_oon
croton84415453croton
dacron94310693dacron
darshan1167063darshan
dragon838843dragon
dromon939363dromon
earphone1348253earphone
earshot10410823earshot
earthen1039253earthen
echo96615953_echo_
echos105216463_echos
falchion1644343falchion
falcon11310293falc_on
garcons102411643garc_ons
garron73113493gar_ron
gascon9339723gasc_on
gaucho1256223gaucho_
gauchos1345903gauchos
grison7310103grison
gryphon1643873gryphon
halcyon1543923halcyon
harpoon1238313harpoon
harshen1339283harshen
hon67759383___hon
ichor1039483_ichor
icon66922043_ic_on
iron46728463ir__on
jargon1448823jar_gon
jargoon1545193jargoon
kerchoo1644973kerchoo
kroon94514483kr_oon
kuchen1536653kuchen
larch105919793larch__
larches124416443larches
lardon74415063lar_don
lardoon83410373lardoon
lichen114012743lichen
lochan1139093lochan
macho126120153macho_
machos135217493machos
macon94519953mac_on
macron103615673macron
marathon1346813marathon
march125622893march__
marched153813403marched
marcher143912973marcher
marches143921173marches
marching164312193marching
markhor1635463markhor
maroon83118203mar_oon
marron83717543mar_ron
mascon103612743masc_on
micron103714283micron
mucho125013443mucho_
nacho105414383nacho_
nachos115014183nachos
narcein936293narcein
narco76718243narc_o_
narcos86714203narc_os
ochone11311293_ochone
orcein838183orcein
orchid1289573orchid
orchil1158653orchil
orchis11710773orchis
orcin72716573orc_in
orison6411663orison
orlon5415003or_lon
orphan1137733orphan
ortho8312293ortho_
parachor1546653parachor
paragon10311023paragon
parch125123003parch__
parched154013693parched
parches143720003parches
parching164313053parching
pardon94618733par_don
parson83817903par_son
parton84720993par_ton
pechan13511543pechan
phon95925383__phon
prion75119993pr_ion
prison8514023prison
proton84318893proton
python1447143python
raccoon1176163raccoon
rachet115028973rachet
rachis114017653rachis
racons84319343rac_ons
racoons93912433racoons
radon64620503_radon
ramson8310463ramson
rancho114310853rancho_
ranchos123911393ranchos
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayon83815703_rayon
reckon123010543reckon
recon75624243_recon
redon65424883_redon
rewon86920583_rewon
rho65924833_r_ho_
rhos76319063_r_hos
richen113812513richen
salchow1544323salchow
scion72214993_scion
siphon1138463siphon
syphon1436853syphon
tachyon1544623tachyon
tardyon1134673tardyon
tarpon82812803tar_pon
techno1135953techno
torchons1337503torchons
trigon74513103trigon
triton63914893triton
trogon73611753trogon
tuchun1145443tuchun
tycoon1136023tycoon
typhon1436673typhon
urchins1238863urchins
warison1037083warison
warthog1444533warthog
zechin20137703zechin
zircon1754953zirc_on

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.390458182.1
2DLD Change Limit1127162734.84323274.0
3Display Results2732730.0803412.5
 (SQL Overall)1786912735.31333632.8
 
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.