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

135 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
wimpiness163529(None) 
wispiness1435631wispiness
bumpiness1535282bumpiness
campiness1537542campiness
dippiness1435972dippiness
dumpiness1435652dumpiness
hippiness1635462hippiness
humpiness1635772humpiness
jumpiness2034292jumpiness
liminess10510642lim_iness
limpidness1543082limpidness
limpness1246702limp_ness
lippiness1335412lippiness
lumpiness1336482lumpiness
nippiness1334712nippiness
pipiness1238002pi_piness
riminess10510092rim_iness
skimpiness1842862skimpiness
swampiness1773352swampiness
waspiness1435792waspiness
weepiness14215962weepiness
wiliness1139112wi_liness
wimpiest1538762wimpi_est
wimpinesses1835632wimpinesses
wimpishness2143212wimpishness
windiness1337372windiness
wiriness1138952wi_riness
wittiness12197222wittiness
airiness8412213ai_riness
bittiness11228333bittiness
comfiness1646953comfiness
crispiness1444793crispiness
dampness1336073damp_ness
dimness1038843dim__ness
dinginess1137823dinginess
dirtiness1039473dirtiness
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
dopiness11289973_dopiness
emptiness1335373_emptiness
fieriness1238623fieriness
filminess1435983filminess
fishiness1537343fishiness
flimsiness1543453flimsiness
gaminess112911063gam_iness
gemminess1464643gemminess
giddiness1234683giddiness
gimpiest1338483gimpi_est
grapiness1238253grapiness
griminess1236703grim_iness
grumpiness1543273grumpiness
gumminess1454973gumminess
hamminess1635713hamminess
happiness1636003happiness
hilliness1248923hilliness
hipness12277383hi_p_ness
hippieness1743253hippieness
hominess132712463hom_iness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiness1435023_iffiness
imines84918353_im_ine_s
impanels1245233_impanels
impingers14284063_impingers
impinges13297423_impinges
impings12348553_impin_gs
impishness1744123_impishness
impones112712253_impone_s
impress1137773_imp_ress
inkiness1238693_inkiness
kinkiness1235763kinkiness
loopiness11136543loopiness
miffiness1734523miffiness
milkiness1536523milkiness
miriness10310463mi_riness
mistiness111911633mistiness
mopiness12259063_mopiness
nappiness1335233nappiness
niftiness1236363niftiness
nimbyness1641543nimbyness
oiliness8311563oi_liness
peppiness1235183peppiness
pickiness1737623pickiness
pigginess1375453pigginess
pithiness1437563pithiness
pixiness1736093pi_xiness
pulpiness1335603pulpiness
raspiness1137303raspiness
ripeness1039363ri_peness
riskiness1336963riskiness
ritziness1835823ritziness
ropiness102311073_ropiness
sappiness1337443sappiness
silkiness1337253silkiness
silliness9510363silliness
simpleness1445173simpleness
sissiness8217963sissiness
siziness1737423si_ziness
sliminess1137423slim_iness
soapiness1138293soapiness
soppiness1336543soppiness
tidiness938793ti_diness
timeliness1245303timeliness
timidness1244623timidness
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135703tipsiness
wackiness1836523wackiness
wariness11313213w_ariness
washiness1537043washiness
waviness1437723w_aviness
waxiness1836723w_axiness
weariness1238843weariness
weediness13247043weediness
whininess1535123whininess
wideness12259473wi_deness
wifeliness1644483wifeliness
wildness1236203wi_ldness
wimpier14248053wimpi_e_r
wimping153911013wimpin__g
wimpish1765693wimpi__sh
wimples143311173wimp_le_s
wintriness1345543wintriness
wiseness112010753wi_seness
wispiest1339513wispi_est
wispinesses1636273wispinesses
witness103010013wi__tness
womanness1444473womanness
woodiness13147873woodiness
wooliness12147693wooliness
wooziness21125213wooziness
wordiness13138633wordiness
worminess14127613worminess
yumminess1653643yumminess

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.403443402.0
2DLD Change Limit1486411356.20323962.8
3Display Results1351350.0632142.9
 (SQL Overall)1786911356.66926794.3
 
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.