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

128 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
nippiness133471(None) 
dippiness1435971dippiness
hippiness1635461hippiness
lippiness1335411lippiness
nappiness1335231nappiness
happiness1635992happiness
hippieness1743252hippieness
niftiness1236362niftiness
nippiest12279972nippi_est
nippinesses1545062nippinesses
peppiness1235182peppiness
pipiness1238002pi_piness
sappiness1337432sappiness
snappiness1443822snappiness
soppiness1336542soppiness
tipsiness1135702tipsiness
wimpiness1635292wimpiness
wispiness1435632wispiness
airiness8412213ai_riness
bittiness11228333bittiness
bumpiness1535283bumpiness
campiness1537543campiness
choppiness1973563choppiness
crispiness1444793crispiness
dinginess1137823dinginess
dippiest132511133dippi_est
dippinesses1635243dippinesses
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
dopiness11289973_dopiness
dumpiness1435653dumpiness
emptiness1335373emptiness
fieriness1238623fieriness
filminess1435983filminess
fishiness1537343fishiness
floppiness1742863floppiness
giddiness1234683giddiness
grapiness1238253grapiness
hilliness1248923hilliness
hiplines13310593hipline_s
hipness12277383hi_p_ness
hippies142813743hippi_e_s
hippiest152611613hippi_est
hippinesses1845493hippinesses
humpiness1635773humpiness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiness1435023_iffiness
inaptness1144333inaptness
ineptness1145073ineptness
inkiness1238693_inkiness
jumpiness2034293jumpiness
kinkiness1235763kinkiness
liminess10510643li_miness
limpidness1543083limpidness
limpness1246703limp_ness
lippiest122310613lippi_est
lippinesses1535513lippinesses
lippings13296093lippin_gs
loopiness11136543loopiness
lumpiness1336483lumpiness
miffiness1734523miffiness
milkiness1536523milkiness
miriness10310463mi_riness
mistiness111911633mistiness
mopiness12259063_mopiness
nappies114613393nappi_e_s
nappiest122510883nappi_est
nappinesses1555923nappinesses
nastiness92310573nastiness
nattiness9239333nattiness
neediness10227733neediness
nerdiness10208333nerdiness
nerviness12226873nerviness
newsiness1236033newsiness
niceness1039843ni_ceness
nighness1236103ni_ghness
nimbyness1641543nimbyness
nippers113012623nipp__ers
nippier11319833nippi_e_r
nipping123412873nippin__g
nippingly1743983nippingly
nipples11319663nipp_le_s
noisiness948343noisiness
nosiness83211393n_osiness
nubbiness1334173nubbiness
nuttiness9207563nuttiness
oiliness8311563oi_liness
pickiness1737623pickiness
pigginess1375453pigginess
pippins10319753pippin__s
pithiness1437563pithiness
pixiness1736093pi_xiness
preppiness1344423preppiness
pulpiness1335603pulpiness
raspiness1137303raspiness
riminess10510093ri_miness
ripeness1039363ri_peness
riskiness1336963riskiness
ritziness1835823ritziness
ropiness102311073_ropiness
silkiness1337253silkiness
silliness9510363silliness
sissiness8217963sissiness
siziness1737423si_ziness
skimpiness1842863skimpiness
sloppiness1443743sloppiness
sniffiness1643763sniffiness
snippiest1345723snippi_est
soapiness1138293soapiness
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
tidiness938793ti_diness
tininess8310633ti_niness
tinniness936093tinniness
tippiest122310013tippi_est
unhappiness1852283unhappiness
waspiness1435793waspiness
weepiness14215963weepiness
wiliness1139113wi_liness
windiness1337373windiness
wiriness1138953wi_riness
wittiness12197223wittiness
yippies14279293yippi_e_s
zippiest21248093zippi_est

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411286.39023261.5
3Display Results1281280.0602133.3
 (SQL Overall)1786911286.87325999.0
 
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.