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

247 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
manliness11131012(None) 
manginess122010411manginess
bandiness122310242bandiness
canniness1138642canniness
dailiness1038672dailiness
earliness939692earliness
fanciness1437672fanciness
handiness132110932handiness
lankiness1338052lankiness
mainliners1243992mainliners
mainlines1138512mainline_s
maleness10312312ma_leness
malines93625602ma_line_s
maltiness112910572maltiness
manless93012932manl__ess
manliest102314942manli_est
manlinesses13910192manlinesses
marlines103818712marline_s
massiness112810142massiness
matiness102114742ma_tiness
maziness19239542ma_ziness
mealiness11310062mealiness
randiness102511442randiness
ranginess101610212ranginess
sandiness102111712sandiness
tanginess10239282tanginess
unmanliness1344022unmanliness
womanliness1643032womanliness
zaniness1738662zan_iness
achiness1339703_achiness
airiness8412213_airiness
aliners74717723_a_liners
alines65735223_a_line_s
ampleness1345303ampleness
angriness1036453_angriness
anilines8415133_aniline_s
antsiness937843_antsiness
artiness81615403_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
baldness1137043ba_ldness
balkiness1556903balkiness
balminess1356593balminess
battiness11239843battiness
bawdiness15235543bawdiness
boniness102211803bon_iness
bonniness1136733bonniness
burliness1137833burliness
caginess11310303ca_giness
cakiness1449553ca_kiness
calmness1236643ca_lmness
campiness1537543campiness
candidness1444773candidness
canines93724033can_ine_s
canoness1039393can_oness
carlines103521643carline_s
cattiness112310633cattiness
chanciness1745123chanciness
cleanliness1343263cleanliness
crankiness1636173crankiness
curliness1138553curliness
daffiness1634843daffiness
dailyness1343643dailyness
daintiness1145963daintiness
dankness13256693dan_kness
deadliness12115893deadliness
dinginess1137823dinginess
eanlings9128463eanlin_gs
easiness8313043ea_siness
fanciless1444603fanciless
fanzines2036913fanzine_s
fattiness12239373fattiness
faultiness1344823faultiness
funkiness16226873funkiness
funniness12256533funniness
gabbiness1434403gabbiness
gaminess112911053ga_miness
gantlines1039323gantline_s
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
godliness1136593godliness
hairiness1238013hairiness
haleness11312623ha_leness
halfness1435563ha_lfness
hamminess1635703hamminess
happiness1635993happiness
hardiness132310353hardiness
hastiness122410883hastiness
haziness20248513ha_ziness
hilliness1248923hilliness
holiness112512503_holiness
inkiness1238693_inkiness
jauntiness1743973jauntiness
jawlines18126363jawline_s
jazziness2432843jazziness
jolliness1636213jolliness
jowliness1934853jowliness
kaolines1239283kaoline_s
kindliness1544043kindliness
kingliness1543953kingliness
kinkiness1235763kinkiness
laciness102112553la_ciness
landlines1039753landline_s
lankness12237043lan_kness
lanolines939973lanoline_s
larkiness1338113larkiness
laziness17239983la_ziness
loneliness1046083loneliness
lowliness1236403lowliness
machines15312883machine_s
madness10310073ma__dness
maidenliness1552083maidenliness
mailings113011923mailin_gs
mailless10248583mail_less
mainline1039863mainline__
mainlined1254353mainline_d
mainliner1144673mainline_r
malices114316623ma_lice_s
maligners12104783ma_ligners
maline84529083ma_line__
malingers1285853ma_lingers
mallings113413093mallin_gs
mandolines1347093mandoline_s
maneless102812343man_eless
manfulness1545643manfulness
manganese1244803manganese
manganeses1345023manganeses
mangiest112815903mangi_est
manginesses1499593manginesses
mangonels1294373mangonels
manifest1339503man_ifest
manifests1444123man_ifests
manilles102312593manille_s
manlier92414023manli_e_r
manlike133012783manlike__
manlikely1842053manlikely
mannerliness1452563mannerliness
manners93417833man__ners
mannishness1643973mannishness
mannites10312613mannite_s
mantises10317923mantise_s
mantlings12207223mantlin_gs
mariners103113863ma_riners
marines93928013ma_rine_s
marliest102415183marli_est
marline93320953marline__
marlings113713483marlin_gs
marlins93420473marlin__s
marlites103415263marlite_s
marshiness1555063marshiness
martinets1138883martinets
mateyness1444473mateyness
matinees102110423ma_tinees
matless93014043matl__ess
mazedness2194573mazedness
meanness1037183mean__ness
meatiness11311173meatiness
merriness1138283merriness
messiness11248223messiness
midlines112613333midline_s
miffiness1734523miffiness
mildness1136523m_ildness
milkiness1536523milkiness
milliners11289953milliners
millines102718063milline_s
miriness10310463m_iriness
mistiness111911633mistiness
moldiness12227053moldiness
moodiness12197593moodiness
mooniness11157863mooniness
mopiness12259063m_opiness
mossiness11258323mossiness
mousiness11219023mousiness
muddiness1334753muddiness
mugginess1354633mugginess
murkiness15206283murkiness
mushiness14248213mushiness
muskiness15237433muskiness
mussiness11238293mussiness
mustiness112211653mustiness
muzziness1933143muzziness
myelines1337123myeline_s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
oiliness8311563_oiliness
paleness10312983pa_leness
pallidness1343283pallidness
pastiness112312353pastiness
pawkiness1835443pawkiness
puniness101610273pun_iness
punkiness15226983punkiness
raciness102413453ra_ciness
raininess949273raininess
rancidness1344223rancidness
rankness12267943ran_kness
raspiness1137303raspiness
ratlines83815293ratline_s
runniness9247103runniness
runtiness92410393runtiness
saintliness1144153saintliness
salines74029413sa_line_s
saltiness93312113saltiness
saltness82610243sa_ltness
saneness82313723san_eness
sappiness1337433sappiness
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scaliness1149303scaliness
scantiness1236873scantiness
silliness9510353silliness
slanginess1146273slanginess
smallness1174513sma_llness
smarminess1444303smarminess
snakiness1367473snakiness
sunniness9247943sunniness
surliness939943surliness
swankiness1744253swankiness
tackiness1557693tackiness
taglines92210823tagline_s
talkiness1356913talkiness
tallness837103ta_llness
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tininess8310633tin_iness
tinniness936093tinniness
ugliness936863_ugliness
validness13125363va_lidness
valines104520213va_line_s
wackiness1836523wackiness
wanness102610683wan__ness
wariness11313213wa_riness
washiness1537043washiness
waspiness1435793waspiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weakliness1753853weakliness
wiliness1139113_wiliness
windiness1337373windiness
wooliness12147693wooliness

Search took 9 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.1531167915.0
2DLD Change Limit1486412478.53317419.5
3Display Results2472470.1102245.5
 (SQL Overall)1786912478.79620315.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.