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

181 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
happiness163599(None) 
hippiness1635461hippiness
nappiness1335231nappiness
sappiness1337431sappiness
campiness1537542campiness
choppiness1973562choppiness
dippiness1435972dippiness
hairiness1238012hairiness
hamminess1635712hamminess
handiness132110932handiness
happiest152411672happi_est
happinesses1876162happinesses
hardiness132310352hardiness
hastiness122410882hastiness
haziness20248512ha_ziness
hippieness1743252hippieness
humpiness1635772humpiness
lippiness1335412lippiness
nippiness1334712nippiness
peppiness1235182peppiness
raspiness1137302raspiness
snappiness1443822snappiness
soppiness1336542soppiness
unhappiness1852282unhappiness
waspiness1435792waspiness
achiness1339703_achiness
airiness8412213_airiness
alpines94016193_alpine_s
aptness9268573_a_ptness
artiness81615403_artiness
ashiness1138963_ashiness
bagginess1355953bagginess
balkiness1556903balkiness
balminess1356593balminess
bandiness122310243bandiness
battiness11239843battiness
bawdiness15235543bawdiness
bumpiness1535283bumpiness
caginess11310303ca_giness
cakiness1449553ca_kiness
canniness1138643canniness
cappings15369493cappin_gs
cattiness112310633cattiness
chanciness1745123chanciness
chappies172610093chappi_e_s
chariness14310063cha_riness
chattiness1565123chattiness
daffiness1634843daffiness
dailiness1038673dailiness
dampness1336073damp_ness
dapperness1543153dapperness
dopiness11289973_dopiness
dumpiness1435653dumpiness
earliness939693earliness
easiness8313043ea_siness
emptiness1335373emptiness
fanciness1437673fanciness
fattiness12239373fattiness
floppiness1742863floppiness
gabbiness1434403gabbiness
gaminess112911063ga_miness
gappiest13259473gappi_est
gassiness10268313gassiness
gaudiness1136253gaudiness
gauziness1934613gauziness
gawkiness1734753gawkiness
grapiness1238253grapiness
haleness11312623ha_leness
halfness1435563ha_lfness
hapless123311333ha_p_less
haplites1339993haplite_s
happened1635653happene_d
happens14359173happ__ens
happier143312033happi_e_r
happing153817233happin__g
haptenes133810823haptene_s
hardness122411083ha_rdness
harmines132715143harmine_s
harness102413933ha__rness
harpies123818313harpi_e_s
harpings14379773harpin_gs
harpins123615703harpin__s
harshness1545963harshness
hatpins123410643hatpin__s
headiness132510363headiness
heartiness1338033heartiness
heaviness15207063heaviness
heftiness1536313heftiness
hilliness1248923hilliness
hiplines13310593hipline_s
hipness12277383h_ip_ness
hippies142813743hippi_e_s
hippiest152611613hippi_est
hippinesses1845493hippinesses
hoariness1238823hoariness
hokiness152510183h_okiness
holiness112512503h_oliness
hominess132712453h_ominess
hoppiest152610723hoppi_est
hoppings16306523hoppin_gs
horniness12309143horniness
horsiness12259473horsiness
huffiness1844283huffiness
huskiness16206583huskiness
jazziness2432843jazziness
jumpiness2034293jumpiness
laciness102112553la_ciness
lankiness1338053lankiness
larkiness1338113larkiness
laziness17239983la_ziness
loopiness11136543loopiness
lumpiness1336483lumpiness
maltiness112910573maltiness
manginess122010413manginess
manliness111310123manliness
mappings15296413mappin_gs
massiness112810143massiness
matiness102114753ma_tiness
maziness19239543ma_ziness
mopiness12259063_mopiness
nappies114613393nappi_e_s
nappiest122510883nappi_est
nappinesses1555923nappinesses
nastiness92310573nastiness
nattiness9239333nattiness
paperiness1446133paperiness
pappies103214823pappi_e_s
pappiest112611113pappi_est
pastiness112312353pastiness
pawkiness1835443pawkiness
pipiness1238003_pipiness
preppiness1344423preppiness
pulpiness1335603pulpiness
raciness102413453ra_ciness
raininess949273raininess
randiness102511443randiness
ranginess101610213ranginess
rapidness12155473rapidness
rapines95120863ra_pine_s
raptness1046733ra_ptness
ropiness102311073_ropiness
saltiness93312113saltiness
sandiness102111713sandiness
sappiest122612573sappi_est
sappinesses1567563sappinesses
sassiness8249333sassiness
sauciness1138043sauciness
savviness1534713savviness
scrappiness1752283scrappiness
shabbiness1743133shabbiness
shadiness1337463sha_diness
shagginess1543933shagginess
shakiness1637083sha_kiness
shapeliness1663163shapeliness
sharpness1434933sharp_ness
sloppiness1443743sloppiness
soapiness1138293soapiness
spaciness1337083spaciness
swampiness1773353swampiness
tackiness1557693tackiness
talkiness1356913talkiness
tanginess10239283tanginess
tappings13267713tappin_gs
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
tawniness1245123tawniness
tipsiness1135703tipsiness
vapidness15144423vapidness
wackiness1836523wackiness
wariness11313213wa_riness
washiness1537043washiness
waviness1437723wa_viness
waxiness1836723wa_xiness
weepiness14215963weepiness
wimpiness1635293wimpiness
wispiness1435633wispiness
zaniness1738663za_niness
zappiest21228023zappi_est

Search took 8 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 Limit1486411816.70322175.3
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.20224811.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.