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

324 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
aptness926857(None) 
patness92912281patness
raptness1046731raptness
actress948532actress
adeptness1273952adeptness
apartness1146052apartness
apneas83211382ap_neas
aptest82917512apt_est
aptnesses11168992aptnesses
artiness81615422artiness
artless73712512artless
daftness1235532daftness
fastness11238762fastness
fatness103311292fatness
fitness10299392fitness
gastness9278482gastness
hotness1038612hotness
inaptness1144332inaptness
pastness102510502pastness
saltness82610242saltness
tartness82210132tartness
tautness8217182tautness
unaptness1154172unaptness
vastness11257292vastness
wetness10277722wetness
witness103010012witness
abbess10509783a_bbess
abruptness1442033abruptness
abscess1133903abscess
access1037683a_ccess
achiness1339703achiness
acidness1136723acidness
acnes75922623a_cne_s
actressy1342603actressy
acuteness1145863acuteness
address956103address
adultness1043973adultness
aeneus61111143a_eneus
aethers103614943aethers
afters94717073aft_ers
agedness1036683agedness
ageless8310343ageless
agenes74720253agene_s
ageneses939303ageneses
agenesis938043agenesis
aggress935593aggress
agones75719863agone_s
aidless83612073aidless
aimless93610813aimless
airiness8412223airiness
airless73712043airless
akenes104817343akene_s
alertness946053alertness
aliners74717723aliners
alines65735223aline_s
almners9399563almners
alpines94016193alpine_s
alters64924223alt_ers
altheas1038233altheas
amines84727983amine_s
ampleness1345303ampleness
ancress978613ancress
anes45255933a__ne_s
antes56334323ant_e_s
anthems12309423anthems
anthers103715203anthers
antheses11311473antheses
anthesis11312503anthesis
antlers74014743antlers
antres65021003antre_s
antsiness937853antsiness
apers76629133ap__ers
apes66047433ap__e_s
apexes1539133apexe_s
apheses12610703ap_heses
aphesis12610513ap_hesis
apices104916263apice_s
apishness1445753apishness
apnea73413413ap_ne_a
apneal83411123ap_neal
apneic1078623ap_neic
apnoeas946353apnoeas
apogees1037103apogees
apothems1544223apothems
appels104312793ap_pels
appends1236393appends
apples104315763apple_s
applets115710063applets
apposes11511473apposes
apres75426403ap_re_s
apses76823913ap_se_s
apter76120203apt_e_r
archness1337513archness
arenes64928393arene_s
aridness939233aridness
armless9369943armless
artels66216233art_els
artiest73121993artiest
artsiness937673artsiness
ashiness1138963ashiness
ashless10318453ashless
assess65710463a_ssess
asters65631603ast_ers
ates45047923a_t_e_s
atoners75013963atoners
atones65225773atone_s
attends8257593attends
attest62618613a_ttest
attests7278813a_ttests
attunes737823attune_s
avenses1049643avenses
avidness1246113avidness
awayness1443303awayness
aweless1038723aweless
awless939263a_wless
awnless1035923awnless
axones134614513axone_s
azines155517073azine_s
badness1039573badness
baldness1137043baldness
baptises1238923baptises
bareness10912813bareness
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
battiness11239843battiness
bigness1038193bigness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
campiness1537543campiness
canoness1039393canoness
capless114312763cap_less
cattiness112310633cattiness
coyness1277323coyness
curtness1037263curtness
cuteness1039673cuteness
dampness1336073dampness
dankness13256693dankness
daphnes13327683daphne_s
darkness13247343darkness
deftness1236303deftness
dimness1038843dimness
dopiness11289973dopiness
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunness8298983dunness
easiness8313043easiness
emptiness1335373emptiness
exactness1843623exactness
faintness1235833faintness
fairness1136563fairness
farness102912203farness
fatless103212203fatless
fattiness12239373fattiness
fewness1335003fewness
feyness1334923feyness
flatness1138153flatness
fulness10248963fulness
gameness112810693gameness
gaminess112911063gaminess
gapless10349993gap_less
gauntness1044203gauntness
gayness1136843gayness
grapiness1238263grapiness
gutless82610713gutless
haleness11312623haleness
halfness1435563halfness
haltless11308443haltless
hapless123311333hap_less
happiness1636003happiness
haptenes133810823haptenes
haptens124511343hapt_ens
hardness122411083hardness
harness102413933harness
hastiness122410883hastiness
hatless103813443hatless
haziness20248513haziness
hipness12277383hipness
hitless103211193hitless
iciness938863iciness
illness736473illness
ineptness1145083ineptness
jitneys17313173jitneys
justness1535323justness
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
lateness82614073lateness
laxness1436043laxness
laziness17239983laziness
lioness739103lioness
liteness82213213liteness
lostness837683lostness
lowness1037813lowness
madness10310073madness
maleness10312313maleness
maltiness112910573maltiness
mastless102610023mastless
matiness102114753matiness
matless93014043matless
mattress1036533mattress
maziness19239543maziness
meetness1036653meetness
mootness1036753mootness
mopiness12259063mopiness
muteness1039013muteness
napless93110283nap_less
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
neatness839153neatness
ness45526563___ness
netless739863netless
newness1035703newness
nowness1037033nowness
oddness935313oddness
oldness836403oldness
oneness7512143oneness
openers9339493openers
openest9312913openest
openness1035473openness
opines84820703opine_s
oppress1135993oppress
packness1636933packness
painless10108363painless
paleness10312993paleness
panels84716523_panels
panes76148693_pane_s
panners93621273panners
pannes85522853panne_s
partners102711143partners
pastiness112312363pastiness
pastless102411203pastless
patens84820863pat_ens
patents94815203patents
paters84935843pat_ers
pates76047893pat_e_s
pathless13138043pathless
patines95225773patine_s
patnesses111611793patnesses
patroness1137493patroness
pattens95414923pattens
patters94825193patters
patzers184210573patzers
pawnees12298173pawnees
pawners124311073pawners
peartness1137773peartness
penes75839223_pene_s
pertness10310093pertness
pines76048863_pine_s
pipiness1238003pipiness
pones74547043_pone_s
press75425953_p_ress
ptoses83514673_ptoses
raciness102413453raciness
rankness12267943rankness
rapidness12155473rapidness
rapines95120863rapine_s
raptnesses1248523raptnesses
rareness81112853rareness
rashness1138093rashness
raspiness1137303raspiness
rawness1038153rawness
redness82012443redness
ripeness1039373ripeness
ropiness102311073ropiness
sadness8310613sadness
safeness11239633safeness
sageness92111983sageness
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
sapless93313443sap_less
sappiness1337443sappiness
scantness1135733scantness
shyness1344993shyness
slyness1035263slyness
smartness1136143smartness
soapiness1138293soapiness
softness1136433softness
spanless10247363spanless
spenses92913573spenses
spinels94512443spinels
spines85132033spine_s
spinets94714813spinets
spinless10238703spinless
spotless1037043spotless
spryness1334003spryness
stress66616673_stress
swartness1236113swartness
tacitness1134873tacitness
tactless10288463tactless
tallness837103tallness
tameness102411253tameness
tapeless10218643tapeless
tartiness92112063tartiness
tastiness92311143tastiness
tattiness9239413tattiness
titaness836723titaness
tress55423163__tress
uptoss836093upt_oss
vainness1136063vainness
vapidness15144423vapidness
votress1035483votress
waeness102512783waeness
waitress1135223waitress
wanness102610683wanness
wariness11313223wariness
warmness1337063warmness
wartless11279923wartless
waspiness1435793waspiness
wattless11268723wattless
waviness1437723waviness
waxiness1836723waxiness
whatness1435093whatness
witless103310983witless
witneys13274723witneys
woeness1020211543woeness
wryness13113983wryness
zaniness1738663zaniness
zaptiehs2241863zaptiehs

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.406440125.6
2DLD Change Limit1340273246.72019944.5
3Display Results3243240.1232634.1
 (SQL Overall)1786913247.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.