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

253 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
archly143735(None) 
achy126316092a_ch_y
arch98628442arch__
arched125717322arched
archer115016242archer
archery15478062archery
arches114822042arches
archil11611572archil
archils12510532archils
archon11311752archon
archway1844892archway
aridly105513702aridly
artily92814712artily
earthly13387382earthly
harshly1636272harshly
muchly1686202muchly
racily11715172racily
rashly123410212rashly
richly1438002richly
ably99725133a__bly
ache96829823a_ch_e
ached119227833a_ched
aches106132293a_ches
achoo10315083a_choo
acidly125211793acidly
acidy117214893a_cidy
acold86214933a_cold
acridly13396533acridly
acyl95314293a_cyl_
acyls104211523a_cyls
aerily93017013aerily
agedly1136463agedly
agly86821803a__gly
ahchoo1445713ahchoo
ahoy101919183a__hoy
airily93014823airily
alchemy1743113alchemy
alchymy2041843alchymy
ally76935643a__lly
alphyl1484083alphyl
amply125012913a_mply
anally9513503anally
anarchy1544933anarch_y
ancho104515303anch_o
anchor113911973anchor
anchos114214893anchos
anchovy1843953anchovy
apishly1535663apishly
apply125111393a_pply
aptly105111813a_ptly
arable81821003arable
arc510250903arc___
arcade91013643arcade
arcana8912583arcana
arcane81216743arcane
arced88224163arc_ed
archaea12137613archaea
archaic1438823archaic
archean1269123archean
archers124414573archers
archfoe1544723archfoe
archine125817053archine
arching136216693arching
archive154610483archive
archons12311583archons
archways1944063archways
arcing95819643arcing
arcked136211943arcked
arco68331543arc__o
arcs67834783arc__s
arctic10313513arctic
arcus76918863arc_us
areal55928733areal_
areally10411243areally
areola6813673areola
areole61017283areole
argal65023393argal_
argala74712673argala
argali75013753argali
argals75517713argals
argil65116883argil_
argils75213623argils
argle65421563ar_gle
argol65317263argol_
argols74514613argols
argosy1036423argosy
argufy1344093argufy
argyle1066063argyle
argyll1033643argyll
arhat8327093ar_hat
ariary94114203ariary
ariel55228973ariel_
ariels65119373ariels
aril45843023ar_il_
arils58732203ar_ils
armhole1236943armhole
armory114211473armory
army96624183ar__my
array86317143ar_ray
arrowy12288273arrowy
arshin9312173arshin
artal55525473artal_
artel56122743artel_
artels66216233artels
artery9911453artery
artsy86012963ar_tsy
arty77531313ar__ty
arval86017013arval_
aryl75922343ar_yl_
aryls87015813ar_yls
ashy107717353a_sh_y
auntly95211063auntly
aurally10310543aurally
avidly13548783avidly
barchan1469133barchan
barely114716793bar_ely
barfly14339653bar_fly
brashly15427613brashly
brawly144312353brawly
brolly114510853brolly
carcel105018673carcel_
carcels114516063carcels
catchfly2143333catchfly
catchy16559583catch_y
chay124924873__chay
churchly2142973churchly
cicely1338833cicely
coly96940533__coly
crackly18397703crackly
crawly144610763crawly
darkly145411073dar_kly
diarchy1644673diarch_y
drably123511613drably
drawly134910723drawly
drily95816523dr_ily
drolly105411673drolly
drooly104911073drooly
drumly1235703drumly
dryly12538453dr_yly
duchy144310873duch_y
dyarchy1942503dyarch_y
early85324123ear__ly
earthily1445613earthily
earthy12399943earth_y
eparchy17204753eparch_y
erectly1257483erectly
exarchy22193693exarch_y
fancily1538253fancily
farcy135217093farc__y
feckly18335963feckly
fickly18318533fickly
freckly19124593freckly
freely12310963freely
freshly16286833freshly
frilly124111443frilly
garishly1545693garishly
gauchely1742743gauchely
grayly13287963grayly
greyly13316543greyly
grimly12459933grimly
grisly104310583grisly
growly13499173growly
hackly18298733hackly
hardily143310273hardily
hardly135112833har_dly
highly1636823highly
icily101211693_icily
itchily1574493itchily
itchy13449013itch_y
lacily11612763lacily
laithly1335653laithly
larceny1234853larceny
larch105919793larch__
larchen12479623larchen
larches124416443larches
largely1136703largely
lichtly15255523lichtly
lushly12247343lushly
marbly134111933mar_bly
marcel103714853marcel_
marcels113212373marcels
march125622893march__
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marly106925613mar__ly
marshy14558333marsh_y
muhly1358523_muhly
nicely1139493nicely
ochry13346933_ochry
orally93113593orally
orchid1289573orchid
orchil1158653orchil
orchils1277703orchils
orchis11710773orchis
packly17228333packly
parcel103915473parcel_
parcels113712663parcels
parch125123003parch__
parched154013693parched
parches143720003parches
partly116315473par_tly
patchily1885813patchily
patchy16509573patch_y
poshly1437723poshly
pricily142710283pricily
prickly18367893prickly
primly13439623primly
rachet115028973rachet
rachis114017653rachis
rackle123917293rackle
racy95825683rac__y
rally84725903_rally
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rattly94111543rattly
rawly115115833_rawly
redly94217203_redly
refly113914563_refly
rely75428953_r_ely
reply104015853_reply
roily86121113_roily
ruly76323143_r_uly
saucily1237913saucily
scaly104718723_scaly
scarcely1534313scarcely
sickly153110483sickly
stanchly1644443stanchly
starchily1745013starchily
starchy15286743starch_y
tardily11269583tardily
tartily103511573tartily
tartly96014023tar_tly
techily1537123techily
techy135612013tech_y
torchy14549533torch_y
trachle12311853trachle
trebly1138973trebly
trickly16369893trickly
trigly103810943trigly
trimly114410893trimly
triply114211023triply
trolly94012363trolly
truly84111553tr_uly
urchin1138743urchin
vichy1639043vich_y
warily122915093war_ily
warmly14228063war_mly
wryly14356703wr_yly
yarely122810303yar_ely
yechy16519083yech_y

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 Limit1127162534.93622835.5
3Display Results2532530.0803162.5
 (SQL Overall)1786912535.40633054.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.