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

180 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
archery1547806(None) 
archer115016241archer_
archers124414571archers
alchemy1743112alchemy
archean1269122archean
arched125717322arche_d
arches114822042arche_s
archly1437352arch_ly
archway1844892archway
artery9911452ar_tery
hatchery19326382hatchery
lechery15257642lechery
marcher143912972marcher_
marchers153710812marchers
ochery14319442_ochery
abhenry1543333a_bhenry
acerb9312763a_c_erb
ache96829823a_che__
ached119227833a_che_d
achene11313813a_chene
aches106132293a_che_s
achier113914263a_chier_
achy126316093a_ch__y
adhere10310333a_dhere
aery77231683a___ery
aether94213673aether_
aethers103614943aethers
aircheck1942903aircheck
alchymy2041843alchymy
ambery133811133a_mbery
anchor113911973anchor_
anchors123912953anchors
anchovy1843953anchovy
anther93715063anther_
anthers103715203anthers
apery106517903a__pery
arced88224163arc_e_d
arch98628443arch___
archaea12137613archaea
archaeal13115463archaeal
archaean13135163archaean
archaeon13134073archaeon
archaic1438823archaic
archenemy1982123archenemy
archeries14411223archeries
archetype1952353archetype
archfoe1544723archfoe
archil11611573arch_il
archils12510533archils
archine125817053archine
arching136216693arching
archive154610483archive
archness1337513archness
archon11311753arch_on
archons12311583archons
archways1944063archways
arcked136211943arcke_d
arguer74510543arguer_
arguers8489033arguers
ariary94114203ar_iary
arider74717743arider_
armer76924443ar_mer_
armers85520273ar_mers
armory114211473ar_mory
armoury12376233armoury
artier63419733artier_
astheny1345293astheny
batcher144414853batcher_
batchers153613273batchers
bitchery18236563bitchery
botchery18366763botchery
bravery15428133bravery
brewery15376963brewery
bribery14426493bribery
briery114510773br_iery
butchery18326253butchery
cachexy2443283cachexy
catcher143115823catcher_
catchers153114063catchers
chary135023133__chary
cheery144913153__cheery
cherry144810763__cherry
chert105232103__chert
cherty144612473__cherty
chevy16479993__chevy
chewy165011903__chewy
crockery19356603crockery
cutchery18265173cutchery
cyclery1763493cyclery
dithery14318943dithery
drapery13387943drapery
etcher113912943etcher_
etchers123411293etchers
farcer115016083farc_er_
farcers124713443farc_ers
farriery14295403farriery
farther1348343farther_
fishery16397733fishery
gauchely1742743gauchely
gaucher1337233gaucher_
grapery13457953grapery
grocery13336763grocery
harsher13310363harsher_
hatcher153314723hatcher_
hatchers163113173hatchers
incher114114033incher_
inchers123912523inchers
jagghery2351803jagghery
larceny1234853larc_eny
larchen12479623larche_n
larches124416443larche_s
lathery133911123lathery
lecher113415853lecher_
lechers123313963lechers
lurcher12338133lurcher_
lurchers13307153lurchers
marched153813403marche_d
marchen143312073marche_n
marches143921173marche_s
marchesa15346883marchesa
marchese15358913marchese
marchesi15337323marchesi
matcher143214283matcher_
matchers153012433matchers
mercery14397623merc_ery
mockery18376913mockery
mothery153710513mothery
ocher104516103_ocher_
ochers113915303_ochers
ochry13346933_och_ry
orchard1346933orchard
ornery938463or_nery
orphrey15133393orphrey
orrery936783or_rery
parched154013693parche_d
parches143720003parche_s
parchesi15358213parchesi
patcher143515143patcher_
patchers153413303patchers
percher143313423percher_
perchers153611523perchers
prudery1335243prudery
puckery18306263puckery
racer75233023rac_er_
racers84725433rac_ers
rachet115028973rache_t
rachets124516833rachets
racier85120973racier_
racker124824553racker_
rackers134320453rackers
rackety16499113rackety
rancher123013633rancher_
ranchero13277423ranchero
ranchers133311793ranchers
rasher95024123rasher_
rashers104020913rashers
rather94319743rather_
revery124014213_revery
richer114015043richer_
rockery16439253rockery
ropery114313873_ropery
rosery93813283_rosery
rudery10419033_rudery
searcher13209103searcher_
searchers14197353searchers
sorcery1237033sorc_ery
sphery14318883_sphery
tocher114014913tocher_
tochers123413093tochers
torchere1347683torchere
tracery12399793tracery
tracheary1744803tracheary
treachery1744693treachery
trickery17297343trickery
tushery1335633tushery
unchary1537263unchary
watchcry2142363watchcry
watcher153113403watcher_
watchers163511793watchers
witchery19236093witchery

Search took 8 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.420425454.8
2DLD Change Limit1340271806.92319359.7
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.40624127.9
 
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.