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

223 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
nattiness923933(None) 
battiness11239841battiness
cattiness112310631cattiness
fattiness12239371fattiness
nastiness92310571nastiness
nuttiness9207561nuttiness
tattiness9239411tattiness
antsiness937852antsiness
artiness81615412_artiness
bittiness11228332bittiness
brattiness1255842brattiness
chattiness1565122chattiness
dottiness1058042dottiness
hastiness122410882hastiness
jettiness1675692jettiness
knottiness1483592knottiness
maltiness112910572maltiness
matiness102114752ma_tiness
nappiness1335232nappiness
nattiest83215352natti_est
nattinesses11119322nattinesses
niftiness1236362niftiness
pastiness112312352pastiness
pettiness1178702pettiness
pottiness1179702pottiness
ruttiness9258792ruttiness
saltiness93312112saltiness
snottiness1055592snottiness
tartiness92112052tartiness
tastiness92311142tastiness
wittiness12197222wittiness
achiness1339703_achiness
airiness8412223_airiness
angriness1036463angriness
aptness9268573_apt_ness
artsiness937673artsiness
ashiness1138963_ashiness
attainers9115593_attainers
attires72312953_attire_s
attunes737823_attune_s
bagginess1355953bagginess
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
batteners11238183batteners
battiest104115553batti_est
battinesses13169453battinesses
battings114010573battin_gs
bawdiness15235543bawdiness
bustiness111810483bustiness
caginess11310303ca_giness
cakiness1449553ca_kiness
campiness1537543campiness
canniness1138643canniness
catties94023053catti_e_s
cattiest103016333catti_est
cattinesses13129703cattinesses
craftiness1545753craftiness
daffiness1634843daffiness
daftness1235533daft_ness
dailiness1038673dailiness
daintiness1145963daintiness
datedness1187753datedness
dirtiness1039473dirtiness
ditsiness1048153ditsiness
ditziness1945883ditziness
draftiness1444863draftiness
dustiness102211033dustiness
earliness939693earliness
earthiness1377243earthiness
easiness8313043ea_siness
emptiness1335373emptiness
fanciness1437673fanciness
fastness11238763fast_ness
fatalness1245773fatalness
fatness103311293fa_t_ness
fatteners12236883fatteners
fatties103018203fatti_e_s
fattiest113514313fatti_est
fattinesses14118973fattinesses
faultiness1344823faultiness
fustiness121910243fustiness
gabbiness1434413gabbiness
gaminess112911063ga_miness
gassiness10268323gassiness
gastness9278483gast_ness
gaudiness1136263gaudiness
gauziness1934623gauziness
gawkiness1734753gawkiness
gnattiest1035383gnatti_est
goutiness1038773goutiness
grittiness1145183grittiness
gustiness10189903gustiness
gutsiness10226973gutsiness
hairiness1238013hairiness
hamminess1635713hamminess
handiness132110933handiness
happiness1636003happiness
hardiness132310363hardiness
haziness20248513ha_ziness
heartiness1338033heartiness
heftiness1536313heftiness
inaptness1144333inapt_ness
jauntiness1743973jauntiness
jazziness2432843jazziness
laciness102112553la_ciness
lankiness1338053lankiness
larkiness1338113larkiness
lateness82614073la_teness
latrines8515013latrine_s
lattices1038383lattice_s
lattins74115483lattin__s
laziness17239983la_ziness
loftiness1236573loftiness
lustiness92010453lustiness
manginess122010413manginess
manliness111310123manliness
martinets1138883martinets
massiness112810143massiness
mateyness1444473mateyness
matinees102110423ma_tinees
mattings11369673mattin_gs
mattins93316143mattin__s
mattress1036533matt_ress
maziness19239543ma_ziness
meatiness11311183meatiness
mistiness111911633mistiness
mustiness112211663mustiness
naiveness1277493naiveness
nakedness1445043nakedness
nasties73520493nasti_e_s
nastiest83615953nasti_est
nastinesses111110743nastinesses
natheless1244963natheless
nathless11127023na_thless
nativeness1357833nativeness
natives10310823na_tive_s
natters73718063natt__ers
nattier73614623natti_e_r
naughtiness1542383naughtiness
neatness839153neat_ness
neediness10227733neediness
nerdiness10208333nerdiness
nerviness12226873nerviness
nettiest83112433netti_est
nettings9288103nettin_gs
newsiness1236033newsiness
nippiness1334713nippiness
nittiest82712603nitti_est
noisiness948353noisiness
nosiness83211393n_osiness
notedness1047323notedness
nubbiness1334173nubbiness
nuttiest82312143nutti_est
nuttinesses11117753nuttinesses
nuttings9276783nuttin_gs
paltriness1244993paltriness
pastness102510503past_ness
patchiness1744933patchiness
patines95225763pa_tine_s
patness92912283pa_t_ness
patroness1137493patroness
patties93425143patti_e_s
pawkiness1835443pawkiness
pithiness1437563pithiness
prettiness1257393prettiness
raciness102413453ra_ciness
raininess949283raininess
randiness102511443randiness
ranginess101610213ranginess
raptness1046733rapt_ness
raspiness1137303raspiness
ratines75328583ra_tine_s
ratlines83815293ratline_s
ratteners9237273ratteners
rattiest83516113ratti_est
ritziness1835833ritziness
rootiness979063rootiness
runtiness92410393runtiness
rustiness92111943rustiness
saltines82917793saltine_s
saltness82610243salt_ness
sandiness102111713sandiness
sappiness1337443sappiness
sassiness8249333sassiness
satinets8311733sa_tinets
sauciness1138043sauciness
savviness1534713savviness
scantiness1236883scantiness
slatiness92511363slatiness
smuttiness1244403smuttiness
snakiness1367473sna_kiness
snappiness1443833snappiness
snootiness1085833snootiness
sootiness999833sootiness
spottiness1285763spottiness
staginess1038753staginess
tacitness1134873tacitness
tackiness1557693tackiness
talkiness1356913talkiness
tanginess10239283tanginess
tardiness10229923tardiness
tarriness9229243tarriness
tartness82210133tart_ness
tatties74120343tatti_e_s
tattiest83415383tatti_est
tattinesses11128943tattinesses
tattings9408823tattin_gs
tautness8217183taut_ness
tawniness1245123tawniness
testiness9209753testiness
unaptness1154173unapt_ness
vastness11257293vast_ness
wackiness1836523wackiness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
wateriness1348083wateriness
wattless11268723watt_less
waviness1437723wa_viness
waxiness1836723wa_xiness
yeastiness1344883yeastiness
zaniness1738663za_niness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412236.75022020.9
3Display Results2232230.1102027.3
 (SQL Overall)1786912237.28324535.4
 
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.