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

134 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
dippiness143597(None) 
hippiness1635461hippiness
lippiness1335411lippiness
nippiness1334711nippiness
dinginess1137822dinginess
dippiest132511132dippi_est
dippinesses1635242dippinesses
dirtiness1039472dirtiness
ditsiness1048142ditsiness
ditziness1945882ditziness
dizziness1834182dizziness
dopiness11289972d_opiness
dumpiness1435652dumpiness
happiness1635992happiness
hippieness1743252hippieness
nappiness1335232nappiness
peppiness1235182peppiness
pipiness1238002pi_piness
sappiness1337432sappiness
soppiness1336542soppiness
tipsiness1135702tipsiness
wimpiness1635292wimpiness
wispiness1435632wispiness
airiness8412213ai_riness
bittiness11228333bittiness
bumpiness1535283bumpiness
campiness1537543campiness
choppiness1973563choppiness
crispiness1444793crispiness
daffiness1634843daffiness
dailiness1038673dailiness
daintiness1145963daintiness
dampness1336073damp_ness
dapperness1543153dapperness
deepness1136443deep_ness
dewiness1238453d_ewiness
diakineses1543693diakineses
diakinesis1542733diakinesis
diamines11311643diamine_s
diazines1838713diazine_s
dimness1038843di__mness
dipnets10109033di_p_nets
dippers123615183dipp__ers
dippier123111393dippi_e_r
dipping134014833dippin__g
direness9311303di_reness
dispenses121210763dispenses
diviners12308353di_viners
divines113514723di_vine_s
divinest123012173di_vinest
dodginess1235283dodginess
dopeyness1543473dopeyness
dorkiness14248053dorkiness
dottiness1058043dottiness
dowdiness1485693dowdiness
downiness13106713downiness
doziness18228553d_oziness
drippiest1445363drippi_est
drippings15313903drippin_gs
duskiness14216683duskiness
dustiness102211033dustiness
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
inkiness1238693_inkiness
jumpiness2034293jumpiness
kinkiness1235763kinkiness
liminess10510643li_miness
limpidness1543083limpidness
limpness1246703limp_ness
lippiest122310613lippi_est
lippinesses1535513lippinesses
lippings13296093lippin_gs
loopiness11136543loopiness
lumpiness1336483lumpiness
miffiness1734523miffiness
milkiness1536523milkiness
miriness10310463mi_riness
mistiness111911633mistiness
mopiness12259063_mopiness
niftiness1236363niftiness
nippiest12279973nippi_est
nippinesses1545063nippinesses
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
snappiness1443823snappiness
soapiness1138293soapiness
spiciness1347053spiciness
spikiness1536313spikiness
spininess1137963spininess
tidiness938793ti_diness
tininess8310633ti_niness
tinniness936093tinniness
tippiest122310013tippi_est
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 Limit1486411345.98324843.9
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.46927622.7
 
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.