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

259 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
anarch1131039(None) 
anarchs1237091anarchs
anarchy1544931anarchy
inarch1139171inarch
aargh96314082a_argh
anarchic1546852anarchic
arch98628442__arch
autarch1246622autarch
endarch1345442endarch
eparch13258422eparch
exarch18196172exarch
larch105919792_larch
march125622892_march
monarch1445952monarch
narc67127952_narc_
narco76718242_narco
narcs76122022_narcs
natch105018222_natch
parch125123002_parch
search113312422search
snatch114310602snatch
starch113013202starch
aah616252963a_a__h
aarrgh10786303aarrgh
abaca95118043aba_ca
abaci94718843aba_ci
aback134816173aba_ck
abash106016513aba_sh
acari75020283acar_i
acarid95017073acarid
acarus8312193acarus
afar76720783afar__
afars85716513afar_s
agar58726413agar__
agaric93513633agaric
agarics10319943agarics
agars66120643agar_s
airth85621023a_irth
aitch105216163a_itch
ajar116217703ajar__
alack114820063ala_ck
alar46340073alar__
alarm76621423alar_m
alarms85913053alarms
alarum85411983alarum
alary86123443alar_y
amah98927493ama__h
amarna839793amarna
amerce10310513amerce
ana39559833ana___
anabas8314083anabas
anabranch1652833anabranch
anadem939183anadem
anagram1058193anagram
anal48037523ana__l
anally9513503anally
analog7159973analog
ananke1038283ananke
anarchies1448183anarchies
anarchism1645653anarchism
anarchist1447563anarchist
anas46649863ana__s
anasarca1043493anasarca
anatto6139913anatto
ancho104515303an__cho
andro6314163andr_o
andros7313303andros
anear55420323anear__
aneared8512743aneared
anears63717183anear_s
anergy10156863anergy
angaria8311583angaria
angary10311323angar_y
angry9310863angr_y
ankh111114413an__kh
ankush13114433ankush
anlace82513923anlace
anorak1038923anorak
antic75728863antic_
antick124814583antick
antics84621453antics
antra56521923antr_a
antral65719413antral
antre55224523antr_e
antres65021003antres
antrum8611313antrum
anural65714743anural
anuran64313243anuran
anuria6313123anuria
anuric8812103anuric
apace94718383apa_ce
apache134210773apa_che
apart74330673apar_t
apercu1057383apercu
arc510250903__arc_
arco68331543__arco
arcs67834783__arcs
arrack121110253arrack
asarum84610913asarum
attach11118393attach
autarchs1344993autarchs
autarchy1643603autarchy
avarice1238033avarice
avouch1434833avouch
award97118043awar_d
awards107113453awards
aware86420023awar_e
awash116613163awa_sh
ayah108022993aya__h
bach116131393_ba_ch
barca91319433_barca
batch124620103_batch
beach124623893bea_ch
birch124914023_birch
blanch133410853blanch
brach126123303bra_ch
branch134014773branch
canard9314763canar_d
canards10311203canards
canary11314693canar_y
caroch13911763_caroch
catarrh1245003catarrh
catch125120373_catch
church1636483church
clach124617823cla_ch
coach125919453coa_ch
cranch133613533cranch
cratch134110793cratch
curch124415413_curch
dearth104212513dearth
diarchy1644673diarchy
dyarchy1942503dyarchy
each95530583_ea_ch
earth85023053_earth
enact73525363ena_ct
endarchy1743343endarchy
enrich1138943enrich
eparchs14196243eparchs
eparchy17204753eparchy
ethnarch1642413ethnarch
exarchs19165193exarchs
exarchy22193693exarchy
farce104925323_farce
farci105919313_farci
farcy135217093_farcy
ganache1346203gana_che
garth94720223_garth
gnar56021383gnar__
gnarl65115573gnar_l
gnarls74210773gnarls
gnarly104610383gnarly
gnarr64810693gnar_r
gnarrs7407663gnarrs
gnars66718853gnar_s
gnash9449833gna_sh
gynarchy2042103gynarchy
harsh116418053_harsh
hatch135719593_hatch
hearth125315213hearth
inarched1486113inarched
inarches1358043inarches
inarm7314423inar_m
inarms8410093inarms
inch95420823in__ch
inearth1037043inearth
infarct1249013infarct
klatch15445933klatch
knack104311043kna_ck
knar85818723knar__
knarry1334613knarry
knars94416113knar_s
laich105920713_laich
latch104620463_latch
leach105422523lea_ch
loach105116363loa_ch
lurch104814633_lurch
mach116134483_ma_ch
marc87034633_marc_
marcs95726623_marcs
marsh105320853_marsh
match125621103_match
menarche1545813menarche
merch125417963_merch
mesarch1445533mesarch
monarchs1544833monarchs
monarchy1843603monarchy
nacho105414383_na_cho
nacre75715363_nacre
nah69847003_na__h
nance74721843_nance
nancy105214923_nancy
narcos86714203_narcos
nard56634453_nar_d
nards65928463_nards
nares55544153_nares
naric76824173_naric
naris55735293_naris
nark85230063_nar_k
narks96026033_narks
narky126017803_narky
nary76931223_nar_y
nautch1144813nautch
nomarch1445353nomarch
north86018273_north
notch105613323_notch
omniarch1562723omniarch
orach105219233ora_ch
panache1458423pana_che
patch125221223_patch
peach125422493pea_ch
pentarch1544943pentarch
perch124518833_perch
planch133711443planch
poach124917863poa_ch
porch125918623_porch
quaich2047693quaich
ranch105019793_ranch
ratch104221363_ratch
reach105123883rea_ch
roach105717003roa_ch
sauch104918773_sauch
scarce104013633scarce
scarph13429603scarph
scorch13198093scorch
slatch114510533slatch
smirch1356463smirch
snack114718063sna_ck
snare54429983snar_e
snared74824553snared
snarer64620843snarer
snares65329033snares
snarf86525423snar_f
snarfs95113423snarfs
snark95419943snar_k
snarks104815733snarks
snarky134210843snarky
snarl54921083snar_l
snarls64016873snarls
snarly93815003snarly
snash84815673sna_sh
snatchy15355293snatchy
snath86419803sna_th
snitch11357943snitch
stanch113812373stanch
starchy15286743starchy
swarth126012083swarth
swatch14549283swatch
tach96132753_ta_ch
teach105221123tea_ch
thatch1435613thatch
torch107420933_torch
unarched14128553unarched
unarm7314453unar_m
unarms839243unarms
unary8315993unar_y
unearth1037063unearth
unlatch1245053unlatch
watch135617063_watch
xerarch1943843xerarch

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.390458182.1
2DLD Change Limit1127162596.03318683.2
3Display Results2592590.0763407.9
 (SQL Overall)1786912596.49927495.2
 
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.