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

148 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
shininesses144829(None) 
spininesses1358451spininesses
whininesses1746181whininesses
brininesses1338982brininesses
phoninesses1636452phoninesses
raininesses11310482raininesses
shadinesses1538642shadinesses
shakinesses1837612shakinesses
shiftinesses18105242shiftinesses
shininess1237332shinine_s_s
showinesses1735992showinesses
sizinesses1938652s_izinesses
skinninesses1643472skinninesses
sliminesses1338092sliminesses
slinkinesses1645812slinkinesses
spicinesses1547102spicinesses
spikinesses1746522spikinesses
stinginesses1375962stinginesses
stoninesses1138252stoninesses
sunninesses11148382sunninesses
thingnesses1545192thingnesses
thinnesses1346262thin_nesses
tininesses10311162_tininesses
airinesses102613613_airinesses
ashinesses1339163ash__inesses
blindnesses1446183blindnesses
boninesses121111453_boninesses
bonninesses1337353bonninesses
braininesses1446553braininesses
canninesses1368853canninesses
chancinesses1945033chancinesses
charinesses1639563charinesses
chewinesses1945143chewinesses
chicnesses1745213chi_cnesses
chillinesses1744983chillinesses
chillnesses1644723chillnesses
corninesses13410593corninesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
dinginesses1337473_dinginesses
downinesses1536143downinesses
faintnesses1447143faintnesses
finenesses13310713_finenesses
flintinesses1546323flintinesses
funninesses14106873funninesses
graininesses1346593graininesses
griminesses14167553griminesses
hairinesses14198943hairinesses
handinesses151410273_handinesses
hazinesses2239223_hazinesses
highnesses1746083_highnesses
hillinesses1458503_hillinesses
hipnesses1436753_hi_pnesses
hippinesses1845493_hippinesses
hokinesses1758943_hokinesses
holinesses13511493_holinesses
hominesses15510863_hominesses
horninesses1459003horninesses
icinesses11310073__icinesses
inkinesses1439423__inkinesses
juicinesses2035893juicinesses
kindnesses1537213_kindnesses
kinkinesses1435873_kinkinesses
liminesses121310853_liminesses
looninesses1197993looninesses
mirinesses121512313_mirinesses
mooninesses13127943mooninesses
noisinesses1139483noisinesses
oilinesses101512443_oilinesses
pinknesses1636583_pinknesses
pipinesses1448603_pipinesses
pixinesses1937373_pixinesses
puninesses121110753_puninesses
riminesses121211413_riminesses
runninesses11137693runninesses
saintlinesses1344363saintlinesses
saltinesses11311453saltinesses
sandinesses12911393sandinesses
sanenesses10412693s_anenesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
scalinesses1339323scalinesses
scantinesses1437313scantinesses
scantnesses1376533scantnesses
scarinesses1339903scarinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
sexinesses1739213s_exinesses
shabbinesses1953433shabbinesses
shagginesses1743963shagginesses
sharpnesses1645233sharpnesses
sheernesses1445843sheernesses
shinneries1345713shin_neries
shoddinesses1743783shoddinesses
shortnesses1446793shortnesses
shrillnesses1543503shrillnesses
shynesses1535313sh__ynesses
sicknesses1636763s_icknesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
sissinesses9118313sissinesses
skimpinesses2043183skimpinesses
slanginesses1346963slanginesses
slatinesses11311633slatinesses
slicknesses1745193slicknesses
slimnesses1236423sli_mnesses
smokinesses1736253smokinesses
snakinesses1538553snakinesses
snidenesses1248653snidenesses
sniffinesses1843693sniffinesses
snowinesses1436413snowinesses
soapinesses1339713soapinesses
sogginesses1346773sogginesses
sootinesses11410053sootinesses
soppinesses1566843soppinesses
sorrinesses11310093sorrinesses
soundnesses1247523soundnesses
spacinesses1538103spacinesses
spiffinesses2043013spiffinesses
spininess1137963spinine_s_s
sponginesses1544773sponginesses
springinesses16104063springinesses
spunkinesses1844383spunkinesses
staginesses1238463staginesses
stickinesses1845083stickinesses
stiffnesses1743593stiffnesses
stillnesses1146733stillnesses
stringinesses14124533stringinesses
sulkinesses1557723sulkinesses
supinenesses1446013supinenesses
surlinesses11310053surlinesses
swankinesses1944783swankinesses
swiftnesses1744503swiftnesses
swinishnesses1843653swinishnesses
tawninesses1436153tawninesses
thicknesses2043913thicknesses
thorninesses1544393thorninesses
tidinesses1139223_tidinesses
tinninesses1136863tinninesses
vainnesses1337343vain_nesses
whininess1535123whinine_s_s
whitenesses1746653whitenesses
wilinesses131911093_wilinesses
windinesses1557813_windinesses
wirinesses131811523_wirinesses
zaninesses19310383_zaninesses

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331484.87624945.2
3Display Results1481480.0931591.4
 (SQL Overall)1786911485.35933344.1
 
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.