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

148 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
archness133751(None) 
achiness1339702a_chiness
archers124414572arch_ers
arches114822042arch_e_s
archines133815252archine_s
archnesses1547172archnesses
aridness939222aridness
artiness81615402artiness
harshness1545962harshness
muchness1534072muchness
raciness102413452raciness
rashness1138092rashness
richness1337432richness
suchness1335762suchness
access1037683a_c_cess
achenes12313493a_chenes
aches106132293a_ch_e_s
achiest12315183a_chiest
acidness1136723acidness
acnes75922623a_c_ne_s
acridness1245073acridness
actress948533a_ctress
agedness1036683agedness
airiness8412213airiness
anchoress1445243anchoress
ancones93116343ancone_s
ancress978613anc_ress
apishness1445743apishness
aptness9268573a_ptness
arachnids1574303arachnids
arcades101113193arcade_s
arcane81216743arcane__
arcanums1274163arcanums
archaea12137613archae_a
archaeal13115463archaeal
archaean13135163archaean
archaeans14134143archaeans
archaeon13134073archaeon
archaise1348473archaise
archaises1448403archaises
archaism1547103archaism
archaisms1646073archaisms
archaist1349863archaist
archaists1446583archaists
archangels1643283archangels
archean1269123arch_ean
arched125717323arch_e_d
archenemy1982123archenemy
archer115016243arch_e_r
archery15478063arch_ery
archfoes1644993archfoes
archils12510533arch_ils
archine125817053archine__
archings14499863archings
archives16399553archives
archons12311583arch_ons
archways1944063archways
arcsines104010343arcsine_s
arcuses94814693arcuse_s
arenes64928393ar_ene_s
armless9369943ar_mless
arsines73518813arsine_s
artless73712513ar_tless
artsiness937653artsiness
ashiness1138963ashiness
ashless10318453a_shless
avidness1246113avidness
awayness1443303awayness
bareness10912813bar_eness
baroness101210063bar_oness
brashness1436323brashness
butchness1643453butchness
carcanets1347303carcanets
chess105016923__ch_ess
darkness13247343dar_kness
drabness1135803drabness
dryness11114783dr_yness
duchess1335553duch_ess
earliness939693earliness
earthiness1377243earthiness
erectness1146123erectness
fanciness1437673fanciness
farness102912203far__ness
freeness11710443freeness
freshness1545943freshness
garishness1445743garishness
gaucheness1642773gaucheness
grayness1235933grayness
greyness1235243greyness
grimness1175993grimness
hardiness132310353hardiness
hardness122411083har_dness
harness102413933har__ness
highness1536053highness
iciness938863_iciness
ironness836953ironness
itchiness1444753itchiness
laciness102112553laciness
larceners1135993larceners
larches124416443larch_e_s
largeness1038273largeness
larkiness1338113larkiness
lushness1136233lushness
marchers153710813march_ers
marches143921173march_e_s
marchesa15346883march_esa
marchese15358913march_ese
marchesi15337323march_esi
marchioness1842733marchioness
marshiness1555063marshiness
matchless1644683matchless
niceness1039843niceness
nighness1236103nighness
orchises1338773orchises
packness1636933packness
parceners1337453parceners
parcheesi16233763parcheesi
parcheesis17174053parcheesis
parches143720003parch_e_s
parchesi15358213parch_esi
parchesis16318213parch_esis
patchiness1744933patchiness
poshness1356653poshness
primness1276763primness
rachets124516833rach_ets
rachises131412413rachises
ranchless1444453ranchless
rankness12267943rankness
raptness1046733raptness
rareness81112853rareness
rawness1038153_rawness
redness82012443_redness
sarcenets1146953sarcenets
sauciness1138043sauciness
scarceness1444763scarceness
searchless1543373searchless
sickness1437833sickness
starchiness1643943starchiness
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tartness82210133tar_tness
trigness968403trigness
trimness1067563trimness
trueness838693trueness
wariness11313213war_iness
warmness1337063war_mness
wryness13113983wr_yness

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621486.37622923.8
3Display Results1481480.0602466.7
 (SQL Overall)1786911486.84226116.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.